With help from a colleague I've come up with the following that works.

SET NOCOUNT ON;

SET DATEFORMAT dmy;

...

I've tried the following

SELECT ROW_NUMBER() OVER

(

...

Thanks for the alt code sscrazy.

Thanks Jeff, after studying it I've worked out how it works.

I've come up with the following. Thanks for putting me in the right direction

declare @pSomeDate as varchar(20)

set @pSomeDate = '04/2011';

WITH

cteStartOfMonth AS

(

SELECT StartOfMonth = DATEADD(mm,CAST(LEFT(@pSomeDate,2) AS INT)-1,RIGHT(@pSomeDate,4))

)

SELECT distinct ChartDate

...

That's great Jeff, based on your example I ended up with, which works well. Is there a way I can return distinct values in ChartDate ?

declare @pSomeDate as varchar(20)

set @pSomeDate...

That's exactly what I needed, thank you very much. Have a good day

That's more or less how I'm inputting the data, the thing is the IP might not change for a couple of days but the data is still being added to...

Basically my program every 30 minutes records the date/time and the current IP Address of my PC onto a table. I want to be able to run a query that...

Thanks, dte will always change as it's a date and time field and is updated every 30 mins, the ipaddress field could remain the same over several days and then...

I was wondering if sql read each line in date order and as it went through it could tell if the previous line was different to the current one, if...

Hi, I'm more interested in running like a report to show the IP changes rather than getting a notification

Thanks for the replies

is there no way of running a stored procedure on the existing table and for it to only return a recordset of any changes?

That's great, thank you. It gives me a starting point at least.

MysteryJimbo (3/21/2014)

---

mick burden (3/21/2014)

---

Hi everyone, does anyone know if it's possible to update 2 tables that reside on 2 different servers from within one SP? I have access to 2...