Try this ,

SELECT COL.VALUE('LOCAL-NAME(.)','VARCHAR(MAX)') AS COLUMNNAME, COL.VALUE('.','VARCHAR(10)') AS VALUE

FROM ( SELECT C1,C2,C3,C3 -- SHOULD LIST THE COLUMN NAMES EXPLICITELY ( DONT PUT * )

...

Yes.. Thank you. But Is there any way to manipulate the records through case statements. I still believe that there could be a way to control it.

Thanks All for your responses.

i tried this and its working... but not sure how far its accurate as its based on physical location.

my requirment is to get top 3 the...

Sorry. Let me reframe my question.

I know the message_id and the passing parameters value for raiserror().

e.g..

raiserror(60071, 10, -1, @a, @b-2)

Error text for 60071...

Thanks a lot. Got it.

To be precise now, The query used to take only 15 to 20 seconds when no other users are available whereas when all are available its...

Great,

Very clear explanations.

Thanks a lot.

Regards,

Santhosh.

Yes Chris, appologies.

I thought i had posted in the wrong category so posted under T-SQL too.

Thanks Manish ,

I tried this and its working fine

USE master;

EXEC xp_cmdshell '"full path\job.bat"'

GO

Thanks Manish ,

I tried this and its working fine

USE master;

EXEC xp_cmdshell '"full path\job.bat"'

GO