Viewing 15 posts - 7,036 through 7,050 (of 9,715 total)
Waving to Grant across the interwebs while listening to him present on execution plans!
October 28, 2010 at 9:05 am
CirquedeSQLeil (10/28/2010)
Grant Fritchey (10/27/2010)
Worst problem I have it trying to think up stuff to write about.
I'll see you that problem and raise you a "ran out of time to...
October 28, 2010 at 8:01 am
Sean,
Thanks for pointing out that he's talking about syntax, but when I go back to read his post, he's saying ANSI is more readable than T-SQL.
I don't know why I...
October 28, 2010 at 7:58 am
Are you using PIVOT or COALESCE in your code to generate the column names?
I ask because the closest thing I've got to what you're doing sets a variable using COALESCE...
October 28, 2010 at 7:39 am
October 28, 2010 at 6:40 am
Last post until I get more info from you on how you're dynamically generating your column names (code sample?) from the database.
Looks like there was an article on SSC for...
October 28, 2010 at 6:35 am
WayneS (10/27/2010)
October 28, 2010 at 5:06 am
Jez,
So you'd be doing this manually instead of scheduled as an automatic job?
Have you tried the Import / Export Wizard? It can import flat files.
October 28, 2010 at 4:40 am
Ivan Mohapatra (10/27/2010)
Soory To all For the format of writeing in the previous post.
Ivan, that's okay. Just please don't use text-speak like "u" and "r" in these forums....
October 28, 2010 at 4:21 am
WayneS (10/27/2010)
Brandie, if I'm understand you correctly, you are saying to dynamically set the file name.
Nope. That's a different, separate thing. You can dynamically create the file, and all its...
October 28, 2010 at 4:16 am
Odd. When I do a "SELECT current_timestamp, GetDate()", I get the exact same values. So I'm not getting the point about readability.
October 28, 2010 at 4:14 am
Jeff Moden (10/27/2010)
But, my recommendation is to avoid them like the plague.... they're comparatively slow.
How much of a performance hit do styles put on the server?
October 27, 2010 at 11:23 am
Dynamic name can be done either via script or via a Variable set as "Evaluate as Expression".
Using the File Connection (not the Flat File Connection), you can dynamically create...
October 27, 2010 at 11:19 am
WayneS (10/27/2010)
Questions about this in general:1. How do we "submit" these "articles"?
Look in the upper left hand sidebar. "Write For Us" has all the details. You'll have to click through...
October 27, 2010 at 11:16 am
Viewing 15 posts - 7,036 through 7,050 (of 9,715 total)