Viewing 15 posts - 1,516 through 1,530 (of 26,488 total)
report_Begin_date = 1/1/2017
report_End_date = 9/30/2017
Based on the begin and end date, I want previous one...
May 23, 2018 at 3:19 pm
Msg 537, Level 16, State 3, Line 1
Invalid length parameter passed...
May 23, 2018 at 2:57 pm
Here is my take on your request:
--===== Create the test table with
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF OBJECT_ID('[dbo].[PART]','U') IS NOT NULL
DROP...
May 23, 2018 at 2:33 pm
May 23, 2018 at 2:01 pm
So, based on the sample data what is the expected output?
May 23, 2018 at 1:18 pm
May 23, 2018 at 12:26 pm
From this :...
May 23, 2018 at 12:21 pm
May 23, 2018 at 12:11 pm
May 23, 2018 at 12:05 pm
May 23, 2018 at 9:50 am
May 23, 2018 at 9:04 am
May 22, 2018 at 10:26 pm
You could use something like this:
CREATE TABLE [dbo].[Devices](
DeviceUid UNIQUEIDENTIFIER NOT NULL PRIMARY KEY NONCLUSTERED
, DeviceId INT NOT NULL
, DeviceName VARCHAR(24)...
May 22, 2018 at 5:14 pm
May 22, 2018 at 4:43 pm
Viewing 15 posts - 1,516 through 1,530 (of 26,488 total)