Viewing 15 posts - 631 through 645 (of 1,464 total)
February 22, 2019 at 1:53 pm
The issue with using simple DATEADD or DATEDIFF is that they count Year Boundaries. In other words, they count the number of times that the year has changed. The following...
February 22, 2019 at 1:52 pm
February 21, 2019 at 9:45 pm
February 21, 2019 at 9:29 pm
You did not define the logic for the sorting, but I thing that this should do the trickwith cteMaxDate as (
select companyid, maxDate =...
February 20, 2019 at 9:44 pm
CREATE TABLE myTable
(
UpdateDate VARCHAR(30)
)
INSERT myTable
VALUES ('17/01/2019')
And I have this query
February 13, 2019 at 3:29 am
February 12, 2019 at 12:59 am
February 8, 2019 at 4:13 am
Some sample SQL to find the list of SIDs that you can useDECLARE @NumSids int = 5; -- This is the number of new SIDs that you want...
February 8, 2019 at 3:51 am
February 8, 2019 at 3:39 am
Can someone let me know what I;m doing wrong here?
I thought this was correct but...
February 5, 2019 at 12:42 pm
February 1, 2019 at 11:31 pm
Viewing 15 posts - 631 through 645 (of 1,464 total)