Viewing 15 posts - 2,416 through 2,430 (of 4,080 total)
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2009 at 7:24 pm
Sigh.... my Rebels beat Tiger High, but it wasn't pretty.
Hope you weren't emotionally invested in the game, Alvin. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2009 at 7:03 pm
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
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2009 at 6:55 pm
Drew: Sweet 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2009 at 2:29 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2009 at 12:55 pm
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2009 at 12:46 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2009 at 9:02 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2009 at 7:59 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2009 at 7:32 am
Do you want this to read 20510 or 2051 ??
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2009 at 5:08 pm
I'm not following your description. Could you please draw a picture of the table as it should look with the rows calculated correctly?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2009 at 4:58 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2009 at 3:00 pm
Data type "bool"? What are you running?
Also, your statement is only true for the small number of rows in your example. Its a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2009 at 2:38 pm
Good question and a good reminder.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2009 at 2:31 pm
Jacob... this may help you understand the chart. Single digit styles are for character strings that show only the last two digits of year. Three...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2009 at 2:26 pm
Viewing 15 posts - 2,416 through 2,430 (of 4,080 total)