Hi John,

Thanks a lot. How I can filter this with the condition? < 20.

Hi,

It is not possible through TSQL. If you have an access to exchange server, API kind of thing will work to fetch the data. It is quiet long back,...

I think KILL command will automatically ROLLBACK the transaction my point is if we use KILL command there will be a data loss.

Do you think killing the Spid will resolve issue? What about the transaction running behind that?

Great article Paul 🙂

@Koen Verbeeck

Yeah!! Got it;-)

I don't think MERGE statement is available in SQL Server 2005. Hope it should read SQL Server 2008.

Thanks for the Prompt reply.

Still i am getting the latest date. unable to see the whole list of dates in the dump.

Thanks,

Karthik

Guys,

Thanks for your help.

I have worked out using Recursive CTE to get the desired results.

Thanks,

Karthik

I have parsed the string using space as a delimmiter, however not sure how to make it as a hierarchy. Also i need to the keep the first row value...

Yes, variable columns are accepted in the code.

Ok. Here the columns will be added dynamically based on the first row and second row description value. If the first description value is AAA BBB CCC and second description...

Hey Guys,

Sorry for providing in incorrect format.

Please find the below.

With MyCTE( Code,[Desc])

AS

(

SELECT 'A1','AAAA BBBB CCCC' UNION ALL

SELECT 'A1.1','AAAA BBBB CCCC DDDDD' UNION ALL

SELECT 'A1.2','AAAA BBBB CCCC DDDDD EEEEE' UNION ALL

SELECT...

Nice Article. I am really impressed. Keep up the good work!!

Hi Jeff,

Nice Article, Keep going.

I have a question on sys tables, most of them using the Sys.tables for generating random numbers. Assume that developers don't have an access to System...