When people say "Open Source", they don't really care if it's "Open Source" or not... they just want "free".

James,

Are all the mice in the same downline? I believe that your code is resolving the whole tree trying to find %mouse% and it may actually be resolving the...

Also, let me know if you need any help splitting that pig. 😉

You don't need a format file for this nor even BCP. Just do a BULK INSET and specify the FIELDTERMINATOR = ''.

Starting reading here... all is explained in that post and additional clarifications are made further down.

http://www.sqlservercentral.com/Forums/Topic165368-8-1.aspx#bm165996

You still have to identify the server and, maybe the instance using the -S parameter.

Dugi (11/18/2008)

---

Try to truncate table

TRUNCATE TABLE name_of_your_table

couz the DELETE command is logged and every deleted action will recorded on log file and if you have million of records sure that...

It would be really helpful if you posted the stored procedure so we can...

Magy (11/18/2008)

---

I am trying to simulate an array within a stored procedure by passing in a large group of values like this:

EXEC sp_EpiData 1,25,'G1000026, G1000086, G1000088, G1000090, G1000092, G1000094, G1000096,...

bitbucket (11/18/2008)

---

May I sugget reading the EXCELLENT article by Jeff Moden

http://www.sqlservercentral.com/articles/TSQL/62867/

About half way through the article Jeff has an example that is very, very close to what you want...

Lots of code will have temporary blocks that make it look like it's blocking itself. But, thats NOT the reason it takes an "age" to run... the cursor has...

My recommendation is to leave the temp tables as they are instad of converting them to table variables... Read Q3/A3 and Q4/A4 in the following to see why...

http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k

Yeah... I...

The question Christopher is asking is what is in the mdtrans table that is also in the TESTsalescontract table? For example, is there a ResortID column in the mdtrans...

Yep... see the following

http://www.sqlservercentral.com/articles/T-SQL/63003/

I've gotta agree with Michael... the questions have gotten a lot worse. Yeah, I agree that they're probably for the reasons Steve and a couple of others have identified,...