Viewing 10 posts - 1 through 10 (of 10 total)
use the double quotes to refer your config file. For ex:
/ConfigurationFile="Folder:\Folder path\ConfigurationFile.ini"
July 29, 2019 at 11:17 am
ScottPletcher (11/26/2013)
Luis Cazares (11/26/2013)
Here are 2 options to perform your calculation:
SELECT ABS(DATEPART( dayofyear, CutoffDate) - DATEPART( dayofyear, GETDATE())),ABS(DATEDIFF( day, DATEADD( year, DATEDIFF( year, CutOffDate, GETDATE()), CutOffDate), GETDATE()))
FROM #Temp
I don't think...
November 27, 2013 at 8:34 am
Luis Cazares (11/26/2013)
Here are 2 options to perform your calculation:
SELECT ABS(DATEPART( dayofyear, CutoffDate) - DATEPART( dayofyear, GETDATE())),ABS(DATEDIFF( day, DATEADD( year, DATEDIFF( year, CutOffDate, GETDATE()), CutOffDate), GETDATE()))
FROM #Temp
Thanks, it does work....
November 27, 2013 at 5:11 am
Luis Cazares (11/26/2013)
Here are 2 options to perform your calculation:
SELECT ABS(DATEPART( dayofyear, CutoffDate) - DATEPART( dayofyear, GETDATE())),ABS(DATEDIFF( day, DATEADD( year, DATEDIFF( year, CutOffDate, GETDATE()), CutOffDate), GETDATE()))
FROM #Temp
Thanks, it is partially...
November 27, 2013 at 5:07 am
David Burrows (11/26/2013)
Is it +/- 2 days?
How many rows?
One way would be to calculate the day number +/- 2 for the current date and compare that...
November 27, 2013 at 5:04 am
HI
No, I am not. Here is the existing table structure:
CREATE TABLE [dbo].[ContributionForecast](
[Id] [int] IDENTITY(1,1) NOT NULL,
[TimeId] [int] NOT NULL,
[Q1Forecast] [decimal](18, 2) NULL,
[Q2Forecast] [decimal](18, 2) NULL,
[Q3Forecast] [decimal](18, 2) NULL,
[Q4Forecast] [decimal](18, 2)...
November 20, 2013 at 7:11 am
Hi There
I think it would be better if you could provide us the format of output required.
Anyway try this:
SELECT A.Area, B.DeliveryName, A.Item, A.Description
FROM
TableA A inner join TableB B...
March 20, 2013 at 9:32 am
Eugene Elutin (3/19/2013)
If not, then he might want dynamic cross-tab:
SELECT dow.[DAY], s.[Subject], ROW_NUMBER() OVER (PARTITION BY dow.[DAY]...
March 20, 2013 at 4:28 am
Really helpful !! Thanks a ton ! 😉
March 19, 2013 at 5:36 am
Viewing 10 posts - 1 through 10 (of 10 total)