i suppose you could add this to the where clause

AND PIT != CONVERT(CHAR(10),GETDATE(),121) + '16:00:00'

This will check the PIT column and exclude the current day at 16:00. Remember though...

personall i prefer a join - like so:

DELETE a

FROMtablea a

INNER JOINtableb b

ONa.column = b.column

WHEREcondition

As far as standards go - i'm not too sure,...

This may be a bit ott, but check this out:

http://sqlcms.codeplex.com/

This is the sql server central management system.

You can use policies (using the policy management framework) to check the...

so you have another column called PIT which holds datetime values?

Thats what the community is for right ? 🙂

It certainly is possible 🙂

WHERE[DateTime_Column] >= CONVERT(CHAR(10),DATEADD(DD,-7,GETDATE()),121)

AND[DateTime_Column] < CONVERT(CHAR(10),DATEADD(DD,91,GETDATE()),121)

the dateadd function is very flexible. You can + or - days, months, years, minutes, hours etc. play around with...

I don't quite understand, 1 week back would be 24th jan 🙂

for a view instead of declaring variables change the where clause to the following;

WHERE[DateTime_Column] >= CONVERT(CHAR(10),GETDATE(),121)

AND[DateTime_Column] < CONVERT(CHAR(10),DATEADD(DD,91,GETDATE()),121)

what version of sql server are you using? The way i've declared the variables are specific to sql 2008 +

a select statement could look like the following:

DECLARE @DateStart DATETIME = CONVERT(CHAR(10),GETDATE(),121);

DECLARE @DateEnd DATETIME = DATEADD(DD, 91, @DATESTART);

SELECT*

FROM

WHERE[DateTime_Column] >= @DateStart

AND[DateTime_Column] < @DateEnd

Hope that helps

//Edit made the dateadd add 91 days...

I've attended one of...

exec or execute

http://msdn.microsoft.com/en-us/library/ms188332.aspx

sp_executesql

http://msdn.microsoft.com/en-us/library/ms188001.aspx

simples.

SQL Kiwi (1/31/2012)

---

Loundy (1/31/2012)

---

I've seen a few examples on the forums where some people have used a CTE with the row_number() function and others have used cross apply - I...

I believe something like this will do the trick.

CREATE TABLE #table1 (ID INT,SIN_ID INT,AgentCode_ID VARCHAR(30), Amount DECIMAL(5,2))

CREATE TABLE #table2 (ID INT,SIN_ID INT,AgentCode_ID VARCHAR(30), Amount DECIMAL(5,2))

CREATE TABLE #table3 (ID INT,SIN_ID INT,AgentCode_ID...

Paul,

I've seen a few examples on the forums where some people have used a CTE with the row_number() function and others have used cross apply - I understand both...