Viewing 15 posts - 49,261 through 49,275 (of 59,065 total)
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...
July 9, 2008 at 8:51 pm
Leo Mepham (7/9/2008)
Any CLR experts want to offer help?
No... but you don't need any CLR experts to do this either... Leo... I'm not picking on you but
I have a...
July 9, 2008 at 8:28 pm
MentalWhiteNoise (7/9/2008)
July 9, 2008 at 7:50 pm
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...
July 9, 2008 at 7:38 pm
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.
July 9, 2008 at 7:34 pm
Drat... I forgot you said you had a header row... you'll need to add a FIRSTROW = 2 to that...
July 9, 2008 at 6:50 pm
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.
July 9, 2008 at 6:39 pm
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,...
July 9, 2008 at 6:35 pm
Steve Jones - Editor (7/9/2008)
July 9, 2008 at 5:48 pm
Now, there's the 64 thousand dollar question! 🙂
July 9, 2008 at 5:12 pm
Sure... here's a modified example from BOL...
BULK INSERT AdventureWorks.Sales.SalesOrderDetail
FROM 'f:\orders\lineitem.tbl'
WITH
(
FIELDTERMINATOR =',',
...
July 9, 2008 at 5:04 pm
Lynn Pettis (7/9/2008)
PORK CHOPS!!!!! (lol) :w00t:Couldn't resist (well, I could have, but didn't want too!)
😎
Now THAT's entertainment! 😛 Haven't tried it yet, but I understand that Pork...
July 9, 2008 at 4:45 pm
GSquared (7/9/2008)
Relational Theory is a wonderful thing, but every now and again (not more than ten or fifteen times per nanosecond), it runs into this...
July 9, 2008 at 4:43 pm
Tom Hamilton (7/9/2008)
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...
July 9, 2008 at 4:39 pm
Viewing 15 posts - 49,261 through 49,275 (of 59,065 total)