Viewing 15 posts - 54,616 through 54,630 (of 59,067 total)
Thought I'd post something folks can play with... could easily be turned into a proc... can be easily modified for an Insert/Values instead of an Insert/Select. With a little forethought,...
October 12, 2007 at 9:14 pm
Nigel Rutter (10/4/2007)
SELECT @InsertQuery = @InsertQuery + column_name + ',' from ##Temp_Generate
Hope Jeff M doesn't see...
October 12, 2007 at 8:32 pm
dobrzak (4/6/2006)
SELECT object_name(id), rows
FROM sysindexes
WHERE indid...
October 12, 2007 at 8:11 pm
SELECT @@VERSION
Then, check the Microsoft site for the build number...
October 12, 2007 at 7:54 pm
That nice little cross-join you included as a derived table sure did the trick.
October 12, 2007 at 6:51 pm
Now, that's what I'm talking about! Nice job, Kirk!! And, thanks for posting your solution! 😀
October 12, 2007 at 6:03 pm
No, no... Unless I'm totally misreading this, a good ol' fashioned partitioned view will do all of that without the overhead of triggers and the extra table. It'll be...
October 12, 2007 at 5:51 pm
You don't? :blink: There's an example of what the input file looks like, what the table looks like, what the BCP format file looks like, and what the...
October 12, 2007 at 5:48 pm
No, no.... the overhead of a cursor is not required here. Take my previous suggestion and find out how to build a recursive CTE to resolve these types of...
October 12, 2007 at 7:34 am
Jeff Moden (10/11/2007)
Looks like any decent HTML editor or a Word macro to change spaces to the literal " " (without the quotes) will do the trick.
Sorry folks... I didn't check...
October 12, 2007 at 7:29 am
Heh... thanks, Marcus. Most folks keep that type of info in two separate columns...
So, are you all set or do you still need help?
October 12, 2007 at 7:25 am
Viewing 15 posts - 54,616 through 54,630 (of 59,067 total)