Viewing 15 posts - 61 through 75 (of 183 total)
Well the Error was #Error.
But I figured it out , Just multipled by * -1 in the expression and didn't have to use and Abs
January 23, 2015 at 2:09 pm
No Worries, Was able to get thru with the help of this :
DateAdd("d",-Weekday(now(),FirstDayofWeek.Tuesday),now())
January 20, 2015 at 12:59 pm
How about adding that fake parameter in your query
If (@Parameter = 'Fake')
Select
......
Else
Select
...
where xyz = @Parameter
January 20, 2015 at 11:38 am
Yeah but since there are just 2-3 such additional activities . I was wondering we we can tweak the query and see if the table has it if not add...
January 14, 2015 at 11:51 am
Yes , I am using Isnothing... But looks like at the wrong place 🙁
January 12, 2015 at 9:14 am
Sample :
21 Dec 2014 00:16:15
25 Oct 2014 00:16:18
30 Dec 2014 00:16:53
90000
23 Oct 2013 00:16:27
January 6, 2015 at 11:40 am
Its bad data... No I don't have access to changing datatypes
January 6, 2015 at 11:26 am
ok here it is :
Create Table #Temp
(Name Varchar(255) Null
,Week_1 Int
,Week_2 Int
,Week_3 Int
,Week_4 Int
,Week_5 Int
,Week_6 Int
,Week_7 Int
,Week_8 Int
,Week_9 Int
,Week_10 Int
)
Insert Into #Temp (Name , Week_1 ,Week_2 ,Week_3...
December 15, 2014 at 9:43 am
Great! Thanks a lot. Will definitely try
December 4, 2014 at 9:40 am
Viewing 15 posts - 61 through 75 (of 183 total)