@satishthota

I think you have posted a topic regarding same earlier also. Please continue the same topic, as both seems related.

The separtaion must be s/o (or) w/o (fathername), wap...

OwnerName/FatherName/RationCardnO

Aakula Anjaiah S/o Veeraiah Wap 6825011205 Aakula Sada Nandam S/o Veeraiah Aakula Veeraiah S/o Bhumaiah Wap Aakula Shivadeenam S/o Veeraiah Wap 7825011257

Sayad Ajimuddin S/o Bhasumiya Wap 6825010014 Shaik Shassina Begam...

you can use BCP too.

Hope this helps

http://forums.sqlwire.com/showthread.php?t=20063

http://www.bigresource.com/MS_SQL-Query-results-to-text-file--sxhmazqA.html#

I did.. and it works for me too... I think, it is general script, so will work for anybody... 😀 just kidding..

Hope this helps you...

http://www.sqlservercentral.com/Forums/Topic156462-23-1.aspx#bm156674

I have seen such problem in 2-3 more scripts....

You can advice to use ur script!!! :hehe:

Hi Ritesh,

Really nice script!

But there is a confusion, though it is completely off topic: It shows that your script has been posted on 2009/05/06!!!?

How!?

Can you pls provide some more info?

You can use value() method of XQuery to retrive individual information from xml and insert it into your destination table.

Backup!!?

Hummm... So, it means i once again hv to think over my decision!!!! 🙂

But thanks to you all guys for providing me such useful information... I could not get this...

Hi Robert,

Currently i m working on both 2k5 and 2k8.. we are planning to upgrade all our systems from 2k5 to 2k8 soon.

That's y i choose 2k8 for certification.

But...

DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)

what is 'dd' in above statement? Any column name or a variable?

Hi,

You can do some like this (if you want your unique key based on your any other column value)

create table #temp (uniqueid varchar(10), uname varchar(5), age int)

insert into #temp (uname,...