Viewing 15 posts - 16 through 30 (of 166 total)
When doing large updates from files, I usually load the records into a staging table first, which guarantees that I have all updates loaded and nothing missing from the file. ...
May 15, 2019 at 5:15 pm
If you have a process that is adding steps, then that is the best place to maintain the records. First, update the existing current step to end the process:
May 7, 2019 at 11:42 pm
WITHAllShifts
AS(/* If the start date is before the end date, then the shift crosses a date boundary; adjust either the start or end date as needed, but...
April 28, 2019 at 9:10 pm
I keep trying to post on this thread with my solution, but the post is not being shown. If I post without code, the reply shows. I then try to...
April 25, 2019 at 6:01 pm
This was removed by the editor as SPAM
April 25, 2019 at 5:43 pm
This was removed by the editor as SPAM
April 25, 2019 at 5:41 pm
This was removed by the editor as SPAM
April 25, 2019 at 5:39 pm
This was removed by the editor as SPAM
April 25, 2019 at 5:38 pm
This was removed by the editor as SPAM
April 25, 2019 at 5:35 pm
This was removed by the editor as SPAM
April 25, 2019 at 5:34 pm
I see that the formatter changed two single quotes in the text to double quotes. The line that says, "SUM(CASE WHEN UnitImportDate..." should have all single quotes, not double and...
April 19, 2019 at 7:03 pm
I would normally do this job by creating a temp table, then dynamically adding and populating columns, then select the output. The advantage of that is that I can account...
April 19, 2019 at 4:29 pm
While there is probably a way to calculate all invoices and credits in a single query using recursive CTEs, I think this case is better served by using loops. ...
April 12, 2019 at 6:14 pm
"@Recipients + ‘; test_email@hp.com‘" is an expression, and expressions cannot be used when calling stored procedures. Any values you want must be set into variables before you call...
April 4, 2019 at 8:33 pm
This is not a full solution, I know, but I made a start for you. I had a hard time understanding exactly how the sample data you provided related to...
March 22, 2019 at 9:22 am
Viewing 15 posts - 16 through 30 (of 166 total)