What about this solution?:

select T1.StorID,

 T1.Text1 as "Name",

 T2.Text1 as "ClientSurname",

 T3.Text1 as "Policy",

 T4.Text1 as "Date"

from MyTableT1

 join MyTable T2 on T1.StorID = T2.StorID and T2.LineNumber = 2

 join MyTable T3 on T1.StorID = T3.StorID and...

Kenneth,

You could consider those statuses as a kind of workflow. I will give you some examples:

St_megr_1 could have 3 statuses: 0=Initial state, 1=Order received, 2 Order accepted

St_megr_2 could...

Thanks guys,

Basically what I would need a help for is a kind of design hint.

I'm just thinking about making separate table just for thoses statuses which would act as a...

What about

exec(@SQLCmd)

or

sp_executesql @SQLCmd

What do you mean by "non duplacate rows"?

Is something like this suitable for you?:

select * from Table1

left join Table2

 on Table1.Student_ID = Table2.Student_ID

 and Table1.Col2 = Table2.Col2

 and Table1.Col3 = Table2.Col3

 and...

Don't you want to wait until SQL2005 aka Yukon is coming out?

Colin,

Would you give us the DDL of your tables and the query itself.

Besid each table it would be good if you could indicate the number of rows it contains, as...

The limit is only your HW and OS, not the BCP

Why not to use computed columns?

create table #t

 (

 d datetime,

 d1 as convert(datetime, convert(char(10), d, 103), 103)

&nbsp

create index I1 on #t(d1)

/* by setting an index on...

ajroney,

There is something I would like to understand.

You told as

"The log file for database 'tempdb' is full."

and

"In addition, there is about 120 GB free on the SAN partition...

You have to open the port you are communicating.

The very first task you have is the make your DB2 client working and accessing the server. Once it's done creating the...

It's easy.

First install the DB2 client on your SQLServer box.

Then configure the access within Client Configuration Assistant to your DB2 server/database.

Configure the ODBC as well

Test it.

Then create a new linked...

Exactly this question is answered here

Thanks to everybody. Nice and quick help

You could also consider creating some new covering indexes for your selects if you are selecting frequently the same columns.

And as David told you you could split your table into...