MS SQL Server 2005 - SQL Problem - Database Discussion Boards

First Prev Next

Re: "displaying recs randomly in a table"

Mark J. Miller11-Jan-07 5:23

Mark J. Miller

11-Jan-07 5:23

Are you talking about a System.Data.DataTable that's already populated and you want to pull a random record from it? Or are you talking about writing a select statement that randomly selects a row?

If it's a datatable you could use Random.Next(DataTable.Rows.Count) to get a random integer with a maximum value set to the row count.

If it's a sql query you want to write you could get a random number based on the RAND() function and the COUNT() function then write something like:

DECLARE @Id INT, @Count INT, @Rnd INT
SELECT @Count = COUNT(*) FROM table
SET @Rnd = CAST((@Count*rand())+1 AS INT)

SELECT TOP (@Count) @Id = Id FROM table ORDER BY CartNumber

SELECT * FROM table WHERE Id = @Id

If you're not using SQL 2005 you'll have to build the SELECT TOP query as a string and call EXECUTE instead.

Re: "displaying recs randomly in a table"

Mark J. Miller11-Jan-07 9:52

Mark J. Miller

11-Jan-07 9:52

Oops, a small mistake. Change this:

SELECT TOP (@Count) @Id = Id FROM table ORDER BY CartNumber

to this:

SELECT TOP (@Rnd) @Id = Id FROM table

Re: "displaying recs randomly in a table"

jezemine11-Jan-07 6:38

jezemine

11-Jan-07 6:38

on mssql:

select top 100 * from yourtable order by newid()

www.elsasoft.org

reporting by crystal report

Pradip Kishore10-Jan-07 20:29

Pradip Kishore

10-Jan-07 20:29

i have around 20 fields in my database.i want to print them through crystal report.but all the 20 fields cann't accomodate in one page of a crystal report.are there any other methods except sub report concepts so that i can print all my records in a single page..?(i may use A12 sheet in dot matrix printer as usually used in offices)

thanks in advance

i m pradip kishore

Re: reporting by crystal report

Saud AKhter16-Jan-07 19:48

Saud AKhter

16-Jan-07 19:48

you can have multiple detail sections in your report. one more workaround is to change the report to landscape.

hope that works.

Regards
Saud

saud

Re: reporting by crystal report

Pradip Kishore17-Jan-07 20:57

Pradip Kishore

17-Jan-07 20:57

hi saud
thanks for your reply.but i am still not able to accomodate all the fields in one page of crystal report..can you give me any tutorials link or any further help in this regard..?

thanks again..

pradip kishore

Re: reporting by crystal report

Saud AKhter18-Jan-07 3:47

Saud AKhter

18-Jan-07 3:47

Hi pardeep ,

Multi detail section is your only solution. have u tried that. if u need assitance of how to add multiple detail section let me know.

saud

MS SQL Server 2005 - SQL Problem

Programm3r10-Jan-07 19:18

Programm3r

10-Jan-07 19:18

Hi all,

Can SQL Server 2005 handle non-case sensitive sql statements. i.e.
A table with the fields (fieldOne - fieldTwo) has some values:
fieldOne fieldTwo
i insert
L lenght
c car
I inject
C construct
l loose

So if one would to do a sql statement on that table i.e:
A bit of ASP: var x = Request.QueryString("variable");
Lets say the value of x was: l
"SELECT fieldTwo FROM table WHERE fieldOne = '"+x+"'"

The output would be: Lenght .... This is what is happening to me .. Confused | :confused:

Can anyone help.....

The only programmers that are better than C programmers are those who code in 1's and 0's..... Smile | :)

Programm3r

Re: MS SQL Server 2005 - SQL Problem

karam chandrabose10-Jan-07 21:59

karam chandrabose

10-Jan-07 21:59

you have to alter your collation settings,
the default collation in sql server 2005 is latin1_general_CI_AS
CI = case insensitve
AS = Accent sensitive

you might have to change it in to Case sensitive.
do google on "SQL Server Collation" for more details.

have fun. cheers

Re: MS SQL Server 2005 - SQL Problem

Programm3r10-Jan-07 22:39

Programm3r

10-Jan-07 22:39

Thank you very much ... Smile | :)

Regards,

The only programmers that are better than C programmers are those who code in 1's and 0's..... Smile | :)

Programm3r

Migrating blob data using SSIS component

gvrvvpjavan10-Jan-07 17:05

gvrvvpjavan

10-Jan-07 17:05

Is there anyother alternate way to migrate blob data instead of using import column transformation and export column transformation using SSIS component. if so please tell me.

Thanks in Advance

gvr

Collation Name

kifahhk10-Jan-07 15:19

kifahhk

10-Jan-07 15:19

hello
can i change my database collation name after i create it
and fill it with data

how please ???????

Re: Collation Name

karam chandrabose10-Jan-07 22:03

karam chandrabose

10-Jan-07 22:03

[

i did the same using sql 200, it is a very very tedious process, would recomment you to re install the DB using proper collation and dump in data, and re run sp's , this is much much better approach,

GridView

vasini10-Jan-07 14:47

vasini

10-Jan-07 14:47

Hi,
I made a GirdView and fill it with data from database. In this GirdView
I have five columns. First column is Name of item that is represented
in this grid. I want to make items in this column url addresses so when
I click on item name it opens another page to edit the item on which I
clicked.

Can this be done? And if can, how?

Thanks!

Vasini

Re: GridView

Saud AKhter16-Jan-07 20:05

Saud AKhter

16-Jan-07 20:05

add hyperlink column to your page in the design time. you can notice smart tag at the righ top edge of the grid. hyperlink column need a url u can give the url of your required page there.

do let me know if u need further assistance

Regards
Saud

saud

How good is ADO.NET vNext CTP now?

cebyrjoe210-Jan-07 10:14

cebyrjoe2

10-Jan-07 10:14

Hi to all,

Some years ago I have made some experiences with ‘ADO.NET vNext CTP’ predecessor ObjectSpaces. Some while ago I also made my experiences with an O/R mapper (EntityBroker) from THONA Software & Consulting Ltd..
No I will give ‘ADO.NET vNext CTP’ a chance.
How good is Microsoft now?
Is ‘ADO.NET vNext CTP’ better than ObjectSpaces? And when YES which changes Microsoft has done?
Use anyone from you ‘ADO.NET vNext CTP’? Productive? J

Regards,
cyberjoe

Running asp in Visual Studio 2005

dptalt10-Jan-07 3:42

dptalt

10-Jan-07 3:42

I have an old asp website and trying to run it in Visual Studio 2005. It does not run. It says "This type of page is not served". Is there away to run it to fix an error?

Re: Running asp in Visual Studio 2005

Colin Angus Mackay10-Jan-07 4:37

Colin Angus Mackay

10-Jan-07 4:37

dptalt wrote:
I have an old asp website and trying to run it in Visual Studio 2005. It does not run. It says "This type of page is not served". Is there away to run it to fix an error?

I wouldn't think that is an error. Why would VS2005 handle classic ASP?

Upcoming Scottish Developers events:
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Creating a stand alone Datarow, without the DataTable

Tristan Rhodes10-Jan-07 1:05

Tristan Rhodes

10-Jan-07 1:05

I've been perplexed by this for a while now, and have found no real solution.

I cannot find a way to create a stongly typed DataRow, without first creating a DataTable, which i don't want to do.

Basicaly, i want to wrap my business object around a datarow, so that it can be used with a data table, without exposing the table and adapter to the external code, and using the datarow to enforce the validation initialy.

Can anyone give me any pointers as to how to do this? I've tried a number of ways and been blocked by various caveats.

Cheers

Tris

[Update]
I'm thinking about using a single instance of each type of data table as a row factory, and wrap them in a static class with static members. Can anyone comment on the thread safety of this approach?

Re: Creating a stand alone Datarow, without the DataTable

Riaan Booyzen11-Jan-07 1:56

Riaan Booyzen

11-Jan-07 1:56

hey there, have you tried

System.Data.DataRow myDataRow;

Riaan Booyzen

How to use in operator

Uma Kameswari10-Jan-07 0:43

Uma Kameswari

10-Jan-07 0:43

hello,
Can I give a list of values in a valiable and use this variable in select query where clause with in operator
for instance

declare @list nvarchar(1000)
set @list = select words from sample
select * from emp where dept in(@list)

regards,
Uma

Re: How to use in operator

_AK_10-Jan-07 0:59

_AK_

10-Jan-07 0:59

yes you can give...
You can use it something like this:

declare @tt varchar(100)<br />
declare @sql varchar(100)<br />
set @tt = '''0004'','+'''0005'','+'''0006'''<br />
set @sql='select * from mst_employees where emp_no in ('+@tt+')'<br />
exec (@sql)