Viewing 15 posts - 1,591 through 1,605 (of 2,645 total)
Instead of 112 you need 105
SELECT CONVERT(DATE,MAX(dato),105) FROM dbo.dutyrostershift WHERE employeeid = 11
April 25, 2019 at 8:06 am
You should check how to post questions with consumable data before posting a question:
;WITH CTE AS
(
SELECT * FROM (VALUES
(34,1,1003,convert(time,'06:43:00'),convert(date,'01.04.2019'),101),
...
April 25, 2019 at 8:03 am
Change the MERGE to be an UPDATE followed by an INSERT. This will probably give you a 40% performance improvement.
Check if the merge is updating any indexes, as this could...
April 24, 2019 at 3:52 pm
Declare @TheTable table (ID int, V1 varchar(1), V2 varchar(2), V3 varchar(1), V4 varchar(1))
Insert into @TheTable values (1, 'A', NULL, NULL, NULL)
Insert into @TheTable values (2, 'B', NULL,...
April 23, 2019 at 9:04 am
March 26, 2019 at 10:42 am
March 25, 2019 at 10:43 am
March 25, 2019 at 9:15 am
March 25, 2019 at 7:36 am
It will exist with a count of zero.
You need to replace 'COUNT(*)' with '*'
March 25, 2019 at 4:55 am
March 22, 2019 at 11:58 am
March 22, 2019 at 10:21 am
I am looking for an output like this