Thank you for your replies all.. am looking at the ways to tune the index.

thanks.

Thank you for your reply. But i didnt get your "get"part. Can you explain a bit more.

thanks.

you can use this:

ALTER DATABASE [your databasename] SET PARTNER OFF

Now, to remove mirroring you can execute

RESTORE DATABASE [your databasename] WITH RECOVERY

Please find herewith the table and the data for this request.

CREATE TABLE [dbo].#[RealTable](

[id] [int] IDENTITY(1,1) NOT NULL,

[DOC_NO] [varchar](50) NULL,

[DOC_DATE] [datetime] NULL,

[DOC_TYPE] [varchar](255) NULL,

[CUST_NO] [varchar](255) NULL,

[Line] [varchar](255) NULL,

[Amt] [decimal](13, 2) NULL

)...

Hi, I have gone through the articles and tried. But the cross tab is not working for me.

please help.

Thanks

Hi ,

Its true that its sort of pivot table .

but in my case, I cant predefine the number of occurance of the Line and amt and so how can...

This is really interested, in my case, our HR cant even trust full IS team and the whole product is outsourced even though we tried our best to give all...

Sorry for the disturbing data.. I will take care...

I want to update another field with this data on the same table.

Hi ,

I need:

The course name that corresponds to the earliest course date per group id?

So for the sample data I have given,I need to get course4 for the first row...

Hi,

Thank you for your reply.

I want to get the first avialable course in that group. so i thought if we group by coursestartdate, I can take the min value.

Is there...

I tried this, but giving error because its giving error:

Msg 512, Level 16, State 1, Line 1

Subquery returned more than 1 value. This is not permitted when the subquery follows...

Thank you for your reply.

Thats giving me the real data i want.

But

When I tried all values for Rank as false, its giving me NULL as value.

How can I...

Any help please??

The rowcount >1 is the duplicates for me.

so the duplicates are:

PGN-0312639bb2

PGN-0312640cc2

PGN-0312641dd2

PGN-0312642ee2

PGN-0312643ff3

I tested this one and working fine for me.please check.

I really need to get a help ASAP if u can.INSERT INTO [SF].[dbo].[PackageData1] ([Package Grp No] ,[Account] ,[Package Item No] ,[Opportunity...