Lynn Pettis (3/18/2009)

---

Chris Morris (3/18/2009)

---

Heh quite possibly - but the count of BEGIN - END pairs goes...

BWAAA-HAAA!!!! Hey Lynn! Now you know one of the reasons I don't like case sensitive databases. 😛

The Thread... if you want it to be a good place to meet for those that...

You guys are starting to knock rings about that and that's not right.

Sheesh!

Man... get over yourself... I used to respect your maturity until you started using cheap...

Bob Hovious (3/16/2009)

---

Hal, my apologies.

I thought perhaps there was a misunderstanding about the question. When I saw that Flo had answered to your satisfaction I...

If the formatting of each element is pretty much cast in stone, then a straight forward method may be in order...

Here's the test data...

--===== Create a demonstration table (This is...

It's going to be tough to troubleshoot this without some test data and a listing of the code that does the Bulk Insert. If the data has private information...

harish_ravi (3/16/2009)

---

Thanks for your reply. i verified it was working gr8.

but i dont think its working for comparing data with duplicate values.

like the below.

DECLARE @v1 TABLE (id INT, txt VARCHAR(100))

DECLARE...

Heh... "Survey says... ding, ding, ding, ding, ding... STUFF! Look it up in Books Online". Bruce is spot on.

"Teach a man to fish and..."

All of your questions are answered in the following two articles...

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

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

I think that it's funny as hell that anyone would call an XML file a "flat file". 😉

Before I even knew SQL Server existed and the small company I...

You bet... thanks for the feedback. 🙂

Mike Levan (3/16/2009)

---

I am using this for table count in each db, is there a way...