Viewing 15 posts - 5,176 through 5,190 (of 13,877 total)
Try running this and see what you think. I'm not surprised that you had trouble coding it. There must be a better way than what I've come up with.
September 13, 2017 at 12:58 pm
September 13, 2017 at 12:02 pm
September 13, 2017 at 11:55 am
Well done on taking the time to post all of your set-up scripts ... this is a great start.
But I am having trouble understanding what is so special about...
September 13, 2017 at 11:21 am
An iTVF may do what you need.
September 12, 2017 at 2:52 pm
Like this, perhaps?
DECLARE @actvt_dt DATE = '20150815';
SELECT CASE
WHEN @actvt_dt BETWEEN '20150814' AND '20150910' THEN
DATEDIFF(DAY, '20150814', @actvt_dt) + 1
END;
September 12, 2017 at 1:40 pm
September 12, 2017 at 11:14 am
September 12, 2017 at 10:28 am
We did need installation media from the reseller. Thanks for everyone's help.
Now I've hit a...
September 12, 2017 at 8:48 am
Another option which may be less painless than comparing scripts is to create two identical temp tables and perform the inserts to them, one from script 1 and one from...
September 12, 2017 at 6:24 am
September 12, 2017 at 5:48 am
September 11, 2017 at 12:59 pm
Joe Torre - Monday, September 11, 2017 11:23 AMIs the DDL accessible?
Joe, did you mean DLL?
September 11, 2017 at 12:04 pm
Viewing 15 posts - 5,176 through 5,190 (of 13,877 total)