I forgive you for any of my time you may have taken up, and I'll bet that Lutz and Drew feel the same. It was our choice to...

Have you tried looking in BOL (books online) under "Subscriptions [SQL Server query notifications]"?

You might also try out the entries from this results link. I went to...

Sigh.... my Rebels beat Tiger High, but it wasn't pretty.

Hope you weren't emotionally invested in the game, Alvin. 😉

This will work as well

;with cte as

(SELECT *,ROW_NUMBER() OVER (PARTITION BY itemID ORDER BY endDate DESC) as rowID

FROM #tab1 a

)

SELECT * FROM cte WHERE rowID = 1

Drew: Sweet 🙂

I don't think Lutz meant it was wrong for you to ask a question on Sunday. I'm sure he was happy to help. After all, we...

Please show small example of names and subgroups.

Many of us have the Adventureworks database, as a standard.

We can't solve your problem without seeing your tables, data and schema.

Hey "Forum Member"

Please take time to read the article posted under Lutz' signature. There are some very good rewards for you, if you follow the procedures outlined...

Just a few points, and one question:

(1) The code you posted will not execute, please fix it.

(2) Posting header lines above query results is not done in TSQL, but in...

There are any number of ways to convert M205100 to 20510. You could use LEFT() and RIGHT() nested. You could STUFF() the first and last characters...

Do you want this to read 20510 or 2051 ??

I'm not following your description. Could you please draw a picture of the table as it should look with the rows calculated correctly?

T-SQL does not prompt a user automatically, the way that Access does for example. Prompting for user input is a function of the user interface, including Access...

Data type "bool"? What are you running?

Also, your statement is only true for the small number of rows in your example. Its a...

Good question and a good reminder.