Viewing 15 posts - 5,176 through 5,190 (of 13,872 total)
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
We have a license for Standard. I installed the developer edition thinking that it was the...
September 11, 2017 at 10:47 am
I want to convert blob data into normal file using SQL, So, I...
September 11, 2017 at 10:26 am
September 11, 2017 at 10:24 am
September 11, 2017 at 7:20 am
September 10, 2017 at 8:22 pm
September 8, 2017 at 6:10 pm
Viewing 15 posts - 5,176 through 5,190 (of 13,872 total)