Try this - it might not give you exactly what you need but it will be close enough for you to correct:

SELECT policy, currency, sequence, amount,

GroupID = DENSE_RANK() OVER(PARTITION...

Ringo-394296 (4/18/2011)

---

Thank you for the for the tip, I did look briefly at these functions but they seem to continue the number series across each window ... is it possible...

Phineas Gage (4/18/2011)

---

ChrisM@home (4/18/2011)

---

Plan B, using Lowell's code:

declare @Last7Days CHAR(8)

SELECT @Last7Days = CAST(YEAR(CURRENT_TIMESTAMP - 7) * 10000 + MONTH(CURRENT_TIMESTAMP - 7) * 100 + DAY(CURRENT_TIMESTAMP - 7) AS CHAR(8))

SELECT...

Is there any advantage in includeing all of the columns in that index? Have you tried the same index with no included columns?

Plan B, using Lowell's code:

declare @Last7Days CHAR(8)

SELECT @Last7Days = CAST(YEAR(CURRENT_TIMESTAMP - 7) * 10000 + MONTH(CURRENT_TIMESTAMP - 7) * 100 + DAY(CURRENT_TIMESTAMP - 7) AS CHAR(8))

SELECT ...

WHERE table-name-removed >=...

Double check the datatype of that INT date column. I reckon it's a text type, not an INT.

@ninja - good spot, mate - you saw this coming 🙂

Try it with the quotes.

You're nearly there...check out RANK() and DENSE_RANK().

Did you include the single quotes around the number?

How long does it take to run this:

WHERE table-name-removed >= '20110411'

Ryan Keast (4/18/2011)

---

Morning,

I am importing the following example of data into a SQL 2000 database -

01|171|Fri|A0277730|.03|1|.0333|JOBS|03/12/10||

01|171|Fri|A0277742|.03|2|.0333|JOBS|03/12/10||

01|193|Mon|A0277843|1.45|1|1.4499|JOBS|06/12/10||

01|193|Mon|A0278032|.03|2|.0333|JOBS|06/12/10||

01|193|Mon|A0278054|.23|3|.2333|JOBS|06/12/10||

01|193|Mon|A0278256|1.48|4|1.4833|JOBS|06/12/10||

When imported the data is being held as .03 and .23 as examples.

How...

Jeff Moden (4/18/2011)

---

ChrisM@home (4/18/2011)

---

nikplic (4/17/2011)

---

Because, i want to have one code with whom i want to call datasources for my forms. I use FoxPro9 and SQL SErver 2008, and code...

nikplic (4/17/2011)

---

Because, i want to have one code with whom i want to call datasources for my forms. I use FoxPro9 and SQL SErver 2008, and code is that write...

sunnymalhotra (4/18/2011)

---

OK, This is what I have implemented.

If exists (select idbatch from jbjob inner join insts_temp on insts_temp.inst = jbjob.idInst and insts_temp.BusDate = jbjob.BusinessDate and jbjob.idbatch=40)

Begin

...

Hi Sunny

Posting your solution may help others with a similar problem - also, it would allow the community to verify your solution and if necessary make further recommendations.