Viewing 15 posts - 16 through 30 (of 88 total)
So my current script i have cannot be amended to work pon what I have on there now?
September 24, 2015 at 3:24 pm
Hi,
Thanks for the reply, I'm not sure what to change now on my script?
Thanks
September 24, 2015 at 2:10 pm
Hi,
Thanks for the your help so far, it looks good so far but how do I get the the table "DatePeriod" to be part of the query?
Thanks
September 23, 2015 at 10:09 am
Sorted it now:
Select
'01-' + substring(datename(month,dateadd(mm,-5,getdate())),1,3) + '-' + convert(varchar,datepart(yyyy,dateadd(mm,-5,getdate())))
Select
'01-' + substring(datename(month,dateadd(mm,-4,getdate())),1,3) + '-' + convert(varchar,datepart(yyyy,dateadd(mm,-4,getdate())))
Select
'01-' + substring(datename(month,dateadd(mm,-3,getdate())),1,3) + '-' + convert(varchar,datepart(yyyy,dateadd(mm,-3,getdate())))
Select
'01-' + ...
May 15, 2015 at 3:28 am
Thanks Eric, that seems to have done the trick!
March 31, 2015 at 10:52 am
Hi,
I tried to do a cross join but it wasn't working, do you have a example?
Thanks
March 31, 2015 at 7:32 am
A0001 still needs to appear as 50 as a Difference for the InjectedDate 2015-03-05 23:19:01.727
March 29, 2015 at 2:52 pm
Hi Eric,
This is not giving me the result I require.
Thanks
March 17, 2015 at 4:48 pm
1. If you happened to be working in SQL 2012, LAG would be great for this (very simple code). Oftentimes people post to the wrong forums.
We do not have SQL...
March 17, 2015 at 3:08 pm
Hi All,
Thanks for your help so far, your queries are closed but I need a entry for A0001 for the InjectedDate of "05/03/2015 23:19:02". I know there is no...
March 17, 2015 at 2:50 pm
Jeff, The Yesterday_Amount should show the Amount the Amount the ID was for yesterday. Thanks
March 17, 2015 at 2:18 pm
So am I right in saying if the field KeyRef is not one of the followings:
NULL
*CORRECT*
***FAILED***
'' (Empty)
Then it does not meet the condition so It will not get passed to...
February 23, 2015 at 2:40 am
Viewing 15 posts - 16 through 30 (of 88 total)