Viewing 15 posts - 91 through 105 (of 178 total)
Joseph M. Steinbrunner (11/25/2015)
...did you notice that the EOMONTH returns a DATE instead of what the tooltip reads (DATETIME)?
November 25, 2015 at 8:08 am
I have a question for the community. What's the reasoning that DATE fields can't simply have a number added to them without the use of the DATEADD function? ...
November 25, 2015 at 7:49 am
Joie Andrew (6/8/2015)
June 10, 2015 at 10:53 am
Thanks for posting. I've never had the need to change the logical names (thus the reason I've never looked it up) except for on the rare occasion that I'm...
June 8, 2015 at 12:50 pm
Ed Wagner (6/3/2015)
... using the move parameters to specify your new filenames.
I personally don't have any experience with the Copy feature but I wanted to endorse Ed's approach and...
June 4, 2015 at 7:35 am
Luis Cazares (5/29/2015)
thisisfutile (5/29/2015)
jshahan (5/28/2015)
Just picked up from The Thread that old Joe has been banned from SSC.
You picked up from this thread that Joe is banned? Maybe I...
May 29, 2015 at 12:44 pm
jshahan (5/28/2015)
Just picked up from The Thread that old Joe has been banned from SSC.
You picked up from this thread that Joe is banned? Maybe I scanned it too...
May 29, 2015 at 12:38 pm
Sam Vanga (4/20/2015)
April 20, 2015 at 8:26 am
What about Text Qualifiers? I've never used SSIS and every flat file I've ever worked with has been comma or tab delimited and they utilize double-quotes as text qualifiers.
The...
April 20, 2015 at 7:59 am
Matt Miller (#4) (3/30/2015)
... biting the heads off of chickens and non ANSI SQL syntax users :hehe:
Um, it was BATS. You really need to read up on your...
April 6, 2015 at 9:25 am
Jeff Moden (12/17/2014)
Phil Parkin (12/17/2014)
... though I would not categorise a CROSS JOIN as advanced.
Heh... you're also not a neophyte, Phil. All the "heavy hitters" take it for...
December 19, 2014 at 12:19 pm
I have a great opportunity making $90,000 a week, stuffing envelopes, FROM HOME...Just kidding. I couldn't resist. :hehe:
I love everything about this job, and I do mean everything,...
December 12, 2014 at 9:06 am
Jack Corbett (12/10/2014)
December 10, 2014 at 12:08 pm
I notice that each SQL Agent GUID ties out to an entry in the ReportServer database on the ReportSchedule table. Since I have dozens of scheduled jobs, all running...
December 10, 2014 at 6:44 am
Eric M Russell (9/24/2014)
September 24, 2014 at 10:53 am
Viewing 15 posts - 91 through 105 (of 178 total)