Viewing 15 posts - 16 through 30 (of 30 total)
The comment prefacing the code is "This is a function..." Yes, we can see that it is a function.
Why should I use your function vs. some other method that I/We...
March 29, 2016 at 6:12 am
When you post something like this please preface it with some text about why I should use this. If I don't know why then why should I bother to understand...
March 29, 2016 at 5:33 am
Yes, the next steps are in the same sql server agent job.
December 4, 2015 at 6:04 am
Thank you, Lempster. Changing these values from the default worked. (and taught me something new.)
December 2, 2015 at 6:18 am
Next step uses the data in the table that was loaded by SSIS.
Next step will be missing an entire fiscal quarter of data unless I put a step in between...
December 1, 2015 at 6:23 am
I have found it more important to understand how the tools my users use interpret date and time fields. Some older but widely used tools don't work well with Date...
November 25, 2015 at 5:56 am
Did you ever resolve this problem? The response re: http://www.codeproject.com/Articles/33941/SQL-LIKE-Operator
was not the correct answer for this problem.
I have found that adding zzzz to the end range works....
October 7, 2015 at 10:01 am
I agree, reporting services would be overkill for most DBA stuff. I often want an email sent as part of a SQL server agent job and this is perfect for...
March 31, 2015 at 6:31 am
I wish my job was so simple that all I had to do was send the result of a single query but we typically need other text in the email...
March 26, 2015 at 6:05 am
We do exactly this for some major flat file data loads. The files are so wide it is pretty much impossible to work with in the SSIS user interface but...
July 25, 2014 at 6:21 am
Is there a way to download these examples, copying text out of those scrolling boxes is a pain and carries along formatting code.
November 29, 2012 at 5:31 am
The method with the table of dates runs four times faster. This based on repeated tests with 1.8 million rows in the source table and putting out 6.9 million rows...
October 23, 2012 at 8:55 am
Well, since you said "easy on the eyes" i reformatted this. I'll take a look at it next week.
DECLARE @T TABLE (
PatientID INT,
StartDate DATETIME,
EndDate...
October 20, 2012 at 4:55 am
Wow, Ray M. That looks very promising. Thanks!!!!
October 17, 2012 at 9:39 am
Yes, but I have to do some kind of loop to build those three records, one record for each day.
October 17, 2012 at 7:38 am
Viewing 15 posts - 16 through 30 (of 30 total)