I think I have seen it somewhere but I'm not sure how to use the PRINT to displace the sublimate values on the BODY of the email?

Hi,

Okay thanks, but how do I fixed the date to be '01-APR' and then the relevant year?

Thanks

So with my current script that I have found what actually needs to be changed for it to work as not sure now?

Thanks

So my current script i have cannot be amended to work pon what I have on there now?

Hi,

Thanks for the reply, I'm not sure what to change now on my script?

Thanks

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

Anyone?

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-' + ...

Thanks Eric, that seems to have done the trick!

Hi,

I tried to do a cross join but it wasn't working, do you have a example?

Thanks

Anyone know how to do this?

A0001 still needs to appear as 50 as a Difference for the InjectedDate 2015-03-05 23:19:01.727

Hi Eric,

This is not giving me the result I require.

Thanks

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...

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...