BEGIN
declare @g datetime
Declare @sDate as datetime
Declare @eDate as datetime
Declare @rCnt as int
set nocount on
set @g = getdate()
INSERT INTO P_Dates (StartDate, EndDate, Result, RunDate)
SELECT StartDate, EndDate, Result, REPLACE(REPLACE(Convert(nv
archar (8), getdate(), 112), '-', ' '), ' ', '')
FROM udf_Date(@g) AS g
Set @sDate = (SELECT DISTINCT REPLACE(REPLACE(CONVERT(nv
archar (8), StartDate, 112), ' ', ''), '-', ' ')
FROM P_Dates
Where Rundate = REPLACE(REPLACE(CONVERT(VA
RCHAR(8), getdate(), 112),'-',''),' ',''))
print @sDate
Set @eDate = (SELECT DISTINCT REPLACE(REPLACE(CONVERT(nv
archar (8), EndDate, 112), ' ', ''), '-', ' ')
FROM P_Dates
Where Rundate = REPLACE(REPLACE(CONVERT(VA
RCHAR(8), getdate(), 112),'-',''),' ',''))
print @eDate
SET @rCnt = (SELECT Count(ACCTNO)
FROM IMPORT)
Update P_Dates
SET RecCount = @rCnt,
StartDate = REPLACE(REPLACE(CONVERT(va
rchar(8), StartDate, 112),'/',''),' ',''),
EndDate = REPLACE(REPLACE(CONVERT(va
rchar(8), EndDate, 112),'/',''),' ','')
Where @sDate = StartDate AND @eDate = EndDate
END
StartDate EndDate RunDate
5/3/2008 12:00:00 AM 5/9/2008 12:00:00 AM 848 1 20080619 Today is not Sunday
NULL NULL NULL NULL NULL NULL
P_Dates (file layout).
[StartDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[RecCount] [int] NULL,
[RECID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
[RunDate] [nvarchar](8) NULL,
[Result] [nvarchar](100) NULL,
StartDate and EndDate should look like RunDate. I have tried everything to convert them what am I missing
When I print them after command Set @sDate = I get May 3 2008 12:00AM
May 9 2008 12:00AM. What is going on???
Thanks,
TEN
Start Free Trial