Viewing 15 posts - 2,431 through 2,445 (of 6,679 total)
Declare @acctPeriod int = 201801;
Select dateadd(month, -1, datefromparts(left(@acctPeriod, 4), right(@acctPeriod,...
October 15, 2018 at 2:40 pm
Try this:
Declare @acctPeriod int = 201801;
Select dateadd(month, -1, datefromparts(left(@acctPeriod, 4), right(@acctPeriod, 2), 1))
October 15, 2018 at 2:37 pm
October 15, 2018 at 11:40 am
I know this is a common problem but I just don't see how folks...
October 8, 2018 at 12:08 pm
Should the sort be done by the first character putting M and...
October 7, 2018 at 12:09 pm
October 7, 2018 at 12:05 pm
In this particular case - we can shorten it to:
Order By
iif(left(person_name, 1) In ('M', 'S'), 0, 1)
, person_name
October 7, 2018 at 11:40 am
We have a report server at my work,we want to move the current...
October 7, 2018 at 10:59 am
October 7, 2018 at 10:27 am
October 4, 2018 at 3:28 pm
October 4, 2018 at 3:11 pm
October 4, 2018 at 12:24 pm
What version of Visual Studio are you using?
If you installed SSDT as a separate install - you should now have an application available named 'SQL Server Data Tools...
October 4, 2018 at 12:18 pm
Assuming that you can identify the single day - and that if any row is updated/changed it will be updated so you can identify it has changed - then a...
October 4, 2018 at 12:08 pm
Viewing 15 posts - 2,431 through 2,445 (of 6,679 total)