montgomery johnson (6/13/2008)

---

I'm using Excel 2003. Do you mean "Import External Data"? Please be more specific. We have many spreadsheets with data imports to more than 10 tabs each. Can...

dbishop (6/13/2008)

---

As a rule, I don't like to use them and try to avoid them as the 'easy way out,' but to say you NEVER use them and you...

Chris.Strolia-Davis (6/13/2008)

---

while (select count(*) from @table) > 0

begin

select top 1 'do something', @id=id from @table

delete from @table where id=@id

...

"Firehose" cursors do not keep the same types of locks... in fact, they're pretty much...

Absolutely NOT true... please see Q4/A4 in the following URL. In fact,...

Which service pack are you running?

Do you have example code of how to use OpenQuery to export to a CSV File?

Why not use "Get External Data"? Much easier... look it up in Excel Help.

8.0

5

1 SQLCHAR 0 8 "|" ...

Heh... I'd have to say just about never... with the exception of RegEx, there's not much that can't be done using some form of set based programming in SQL Server...

Try calling the following function from within the trigger. You would pass the name of the table to @TableName and the value of COLUMNS_UPDATED ( ) to @BinaryColNums. ...

Tech_Newbie (6/12/2008)

---

help please.

I have the following situation:

I want to populate two related tables

Person (PersonID, PersonName, PersonLName)

PersonAddress(PersonAddressID, PersonID, PersonAddr, PersonCity, PersonState, PersonZip, County)

from a table which contains all the data...

Like I said on the other article discussion, this isn't the right place and you haven't told us what version of SQL Server you are using... take a look at...

This is probably the wrong place to ask for such help... and we'd really need to know which version of SQL Server you're using. It would probably be better...

That's 2,000,000 rows that you're returning to the screen... don't measure how...