Viewing 15 posts - 61 through 75 (of 279 total)
GilaMonster - Thursday, July 13, 2017 11:40 AMIs there a trigger on that table?
Yes , there is a Instead of Insert (check...
July 13, 2017 at 12:02 pm
July 10, 2017 at 1:51 pm
July 6, 2017 at 1:36 pm
And it should look like this:
July 6, 2017 at 1:34 pm
Just update on this : I was able to insert the Text , it was SSMS clipboard issue. When i copy text it is not copying entire text and thats...
June 27, 2017 at 8:53 am
June 26, 2017 at 2:33 pm
I am getting this error when i tried to change "faltfile column to dt_ntext"
Error: The data type for "Flat_file.Outputs[Flat File Source Output].Columns[Load]" is DT_NTEXT, which is not...
June 26, 2017 at 1:56 pm
June 22, 2017 at 2:36 pm
Thanks everyone was able to get the monday's from Getdate()
SELECT DATEADD(wk, -5, DATEADD(DAY, -5-DATEPART(WEEKDAY, GETDATE()), DATEDIFF(dd, 0, GETDATE())))
SELECT DATEADD(wk, -4, DATEADD(DAY, -5-DATEPART(WEEKDAY, GETDATE()), DATEDIFF(dd, 0, GETDATE())))
SELECT...
June 22, 2017 at 1:55 pm
the % for most of them shows 0 ...if it is negative needs to show negative ......normally is this right way to calculate the %varience?
June 13, 2017 at 1:23 pm
Select *,CASE WHEN Currentdate = 0 then (PriorDate * 100.0/ [Date-2])
ELSE
CASE WHEN PriorDate=0 THEN (Currentdate * 100.0 / [Date-2])
...
June 13, 2017 at 1:17 pm
CREATE TABLE Dbo.Percentagecalculation
(
Currentdate int
,PriorDate int
,[7DayAvg] Int
,[14dayavg] Int
,[Date-2] int)
INSERT iNTO Dbo.Percentagecalculation VALUES(607 ,480 ,524 ,506 ,590)
GO
INSERT iNTO Dbo.Percentagecalculation...
June 13, 2017 at 12:50 pm
June 2, 2017 at 11:11 am
Viewing 15 posts - 61 through 75 (of 279 total)