Try this:

DECLARE @ReportId int, @ReportId2 INT

SET @ReportId = -- YOUR VALUE

SELECT Top 1 @ReportId2 = ReportId

FROM MaturitiesReports

WHERE [Report_Month] < (

SELECT [Report_Month]

FROM MaturitiesReports

WHERE [ReportId] = @ReportId)

ORDER...

Lynn Pettis (12/22/2009)

---

Let's take another step back. Help us help you, read the first the article I have referenced below in my signature block. Follow the instructions in...

Thanks. Last question, I think: for each RowID in the table Maturity_Detail,...

Cool - now the biggie: are the values of RowID unique within the table?

If not, are they always uniquewithin a single [ReportId]?

It's a pretty picture - but many will feel...

Is this 52 weeks, or is the 52 just a concidence?

How many different values of RowID do you have?

abcim (12/22/2009)

---

I think this is very nice but the problem is that there is not a single Row. So @local_variable must NOT be used to SELECT Query to return...

Merry...

You really don't want to use the "quirky update" trick for this

@ variable

Is a...

lmu92 (12/22/2009)

---

You could use CTEs (common table expressions) to determine @Total2 (see BOL for details).

This would make the whole query much more readable and most probably would make it more...

@Difference will always return NULL

@Total2...

khandaresarang (12/22/2009)

---

Hi all,

I created a table in which there r n fields and in that two of them are date field i.e., startdate and enddate.

Now i...

Even if there were a way to do this with any certainty (and reproducibility / reliability) without changing your table structure, why would you want to? If you can provide...

Rumour has it that someone is deep in thought...