Viewing 15 posts - 316 through 330 (of 844 total)
Try this:declare @StartDate date = '01-01-2018',
@EndDate date = '09-30-2018'
;
SELECT C.No_ AS [No_],
C.Name, C.Spcode, C.Address, C.City, C.[PostCode], C.County, D.dcValue
INTO...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 4, 2018 at 8:12 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 3, 2018 at 2:23 pm
If I know for sure the date field does NOT carry any time values then I agree with using the between. But if it has time, you could miss records. ...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 2, 2018 at 1:17 pm
Jeff Moden - Monday, October 1, 2018 9:02 AMExactly.
I can see your points. But as with many things in SQL I...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 2, 2018 at 12:50 pm
Just added a few tweaks:DECLARE @StartDate DATE;
DECLARE @EndDate DATE;
DECLARE @PrevYearStart DATE;
DECLARE @PrevYTDEnd DATE;
DECLARE @MonthStart DATE;
SET @StartDate = '01-01-2018';
SET @EndDate =...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 2, 2018 at 12:33 pm
Looks like you got the YTD numbers. Use the DATEADD to determine your Previous year start and end dates, same for month to date.
Start by writing these as...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 2, 2018 at 10:36 am
You have a comma after Facility, that is what is casing the error.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 2, 2018 at 7:30 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 2, 2018 at 7:28 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 1, 2018 at 8:28 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 1, 2018 at 8:18 am
If you are running a DELETE SQL statement you could use the OUTPUT statement to write the rows deleted to another table.
https://msdn.microsoft.com/en-us/library/ms177564.aspx
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 1, 2018 at 8:01 am
What part is taking the most time? Can you split it up to see?
Try replacing the first SQL with something like this:
SET @prep_date_start = COALESCE(@prep_date_start,...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 28, 2018 at 9:59 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 27, 2018 at 9:46 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 26, 2018 at 7:56 am
ManicStar - Monday, September 24, 2018 12:05 PMCheddar
Provolone
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 24, 2018 at 1:51 pm
Viewing 15 posts - 316 through 330 (of 844 total)