Hope the below links will help you...

http://www.sqlservercentral.com/articles/Development/commontableexpressionsinsqlserver2005/1758/

http://searchwindevelopment.techtarget.com/tip/0,289483,sid8_gci1278207,00.html

Bob, i just wanted to say what you said... 🙂

the difference is, i used temporary table and you used table variable.... 😀

Hi Jaime,

Sorry! consider it as my reply in hurry....... 😛

@phumlo1

what exactly you want to know?

1) how to select duplicate records?

2) How to cleanup your database without keeping duplicate records?

Please give some more specification.

You can use temporary table into SP-1.

in sp-1

create table #temptbl (col1 dt1, col2 dt2)

insert into #temptbl exec sp2

......................

drop table #temptbl

Hi Jewel,

Please check if 'MSSQL.1' folder is exists into '..\Program Files\Microsoft SQL Server\'? - Do you have enough rights on the system?

- R u logged in with the same...

Hi Jaime,

I have some confusion in your code. here,

I think, you need to put where condition...

Absolutely right... any stored procedure...

Hi arup_kc,

please conclude your solution in brief.

what i understand regarding your post, due to that,

Yes, when I create the procedure that way it returns a recodset of several records. So in short, the answer to my...

you can visit Microsoft notifications.. you may get something from there..

Also, check for Microsoft download notifications... this might not give you d latest news for all new releases, but provides...

Can you pls specify what may be your inputs and what should be your desired output?

@umar iqbal

I am hiring a lobbyist who can go to INDIA and get work from there and bring it here. How is that. i would love to see...

What will you get, if you hard code @workinschema variable into Cursor only? (mean, dont take it out of cursor)

You might not have select permission on [eLOTTERY]..[TB_eL_ApplicationPath] !!

Please check.