Martin,

I also have to say that this is usually a very bad thing to do in SQL Server... most

will tell you that if you need to do it for...

No... but you don't need any CLR experts to do this either... Leo... I'm not picking on you but

I have a...

MentalWhiteNoise (7/9/2008)

---

You should be able to track depth easily with yoru CTE (if you are not already). Use this depth to append a precursor string... such as REPLICATE('-', Depth) +...

This will help... details are in the comments

[font="Courier New"]--===== How to force messages to screen on long running queries

--=========================================================================

-- What normally happens is...

Make your life easy... import the date#time into a single column and replace the # sign with a space in the process of converting it to a real date/time.

Drat... I forgot you said you had a header row... you'll need to add a FIRSTROW = 2 to that...

Not quite... IDENT_CURRENT('table_name') takes a table name as it's operand and has no scope other than the table itself... trigger shouldn't affect it like it can @@IDENTITY.

Here's another way using one of the "new" functions in SQL Server 2005 and a Classic Cross Tab... this example would require two Pivot clauses and a join or two,...

Steve Jones - Editor (7/9/2008)

---

It doesn't really matter too much to me if I get it again, and if someone else like Michael Coles or Jeff Moden or Gail Shaw...

Thanks for the feedback, Tom. 🙂

Now, there's the 64 thousand dollar question! 🙂

Sure... here's a modified example from BOL...

BULK INSERT AdventureWorks.Sales.SalesOrderDetail

FROM 'f:\orders\lineitem.tbl'

WITH

(

FIELDTERMINATOR =',',

...

Now THAT's entertainment! 😛 Haven't tried it yet, but I understand that Pork...

GSquared (7/9/2008)

---

Jeff, I do the same thing.

Relational Theory is a wonderful thing, but every now and again (not more than ten or fifteen times per nanosecond), it runs into this...

Tom Hamilton (7/9/2008)

---

Hi Jeff,

I was researching cross-tab like products and your postings come as one who knows how.

I need to produce a of Cases and comma-separated list of Jurisdictions, like...