June 16, 2009 at 12:49 pm
rodjkidd (6/16/2009)
Roy Ernest (6/16/2009)
Roy, have you been keeping up with it? Or is 20-20 not your thing?
I have been keeping up with it. Seems like Sri Lanka and South Africa are the best team out there.
Yep and unless India do something special this evening SL and SA will be in different semi finals!
We should be in for 3 cracking matches for the semi's and final! Both Pakistan and Windies are blowing hot and cold and SL and SA are being solid as ever....
And we all know who's going to win, right? 😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 16, 2009 at 12:53 pm
i cant find this thread in the main forum? only from my email notifications i can read it. Has this been removed from main forum?
June 16, 2009 at 12:55 pm
Gail, I think it will be Sri Lanka that is going to take it. SA has no clue how to play spinners.. 🙂 They are struggling against Indians... 🙂
But I would love to see SA win atleast one Major cup. 🙂
-Roy
June 16, 2009 at 12:58 pm
Jeff Moden (6/6/2009)
Paul White (6/6/2009)
The requirement to alias a table variable for UPDATE is not spectacularly well documented in BOL. A quick skim over the entry for the UPDATE statement revealed nothing to me - I may have missed it, but I don't think so. It is logical once you think about it, but I don't think it is obvious.It is logical. But, it's also an undocumented feature (it's not to be found in BOL or any Microsoft document I've ever seen). With that in mind, lots of folks say to never use undocumented features because they could change anytime without notice.
Digging up the past, I know, however...
I just got word from the documentation people. The lack of the UPDATE <alias> was simply an oversight and it will be corrected in a future version of BoL. Apparently it was documented in both the 6.5 and 7 docs, but somehow fell out of the SQL 2000 revision and was never added back.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=466432
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 16, 2009 at 12:58 pm
ps (6/16/2009)
i cant find this thread in the main forum? only from my email notifications i can read it. Has this been removed from main forum?
It's there. When I looked it was the first item under "Anything that is NOT about SQL!"
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 16, 2009 at 1:04 pm
Roy Ernest (6/16/2009)
Gail, I think it will be Sri Lanka that is going to take it. SA has no clue how to play spinners.. 🙂
Ooohhh... You're asking for it, aren't you. 😉 😀
Go Proteas!
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 16, 2009 at 1:07 pm
rodjkidd (6/16/2009)
In fact we have a fun few weeks coming up, 2 weeks of Wimbledon where the entire nation bands together and all become tennis fans and forget all about football (soccer), and then 3 to 4 weeks where all of England becomes Cricket fans (and forget about football)...Then of course it's back to the status quo and it's football football foootball for 40 odd weeks!
Rodders...
so true 😀
-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."
June 16, 2009 at 1:08 pm
Alvin Ramard (6/16/2009)
ps (6/16/2009)
i cant find this thread in the main forum? only from my email notifications i can read it. Has this been removed from main forum?It's there. When I looked it was the first item under "Anything that is NOT about SQL!"
Yes, you can get to it directly from the appropriate forum and from the active threads link, but it does not show up when looking at the Recent Posts|Posts added today list. Or at least it doesn't show up on the first page as I would expect as there are posts to it more recently than some of the "newest" posts currently in that list...
-Luke.
June 16, 2009 at 1:08 pm
Alvin Ramard (6/16/2009)
ps (6/16/2009)
i cant find this thread in the main forum? only from my email notifications i can read it. Has this been removed from main forum?It's there. When I looked it was the first item under "Anything that is NOT about SQL!"
Lol. my system doesn't show it up!!
i refreshed the page and here is the content.
------------------
Is a history table required for maintaining a column's previous value? Today @ 1:31:14 AM
Last Post By: By 8kb
Moving Backup Today @ 1:30:51 AM
moving over the networkLast Post By: By Pradyothana Shastry
adding instances and backing up system db's Today @ 1:30:07 AM
Last Post By: By Mani Singh
New Install of SQL Server Developer Today @ 1:29:06 AM
How do I install the application from other than a CDLast Post By: By Gift Peddie
db suspect mode Today @ 1:26:32 AM
Db as gone to suspect mode???Last Post By: By amarbreddy21
Backup of Standby DB (Transaction logs) Today @ 1:24:40 AM
Backup of Standby DB (Transaction logs)Last Post By: By tosscrosby
Monitoring SQL mirroring and gathering statistics Today @ 1:23:41 AM
how can i get performance statisticsLast Post By: By Dean Jones
SQL Command Help with Case statement Today @ 1:21:14 AM
Last Post By: By kam7395
Can we rebuild the indexes for all the share point databases in SQL Server 2005... Today @ 1:20:36 AM
Last Post By: By Mani Singh
TempDB mdf file has grown to 11GB Today @ 1:20:12 AM
Is there a way to reduce the size of temp DB without restarting the SQL Server.Last Post By: By tosscrosby
============================================
June 16, 2009 at 1:10 pm
Luke L (6/16/2009)
Alvin Ramard (6/16/2009)
ps (6/16/2009)
i cant find this thread in the main forum? only from my email notifications i can read it. Has this been removed from main forum?It's there. When I looked it was the first item under "Anything that is NOT about SQL!"
Yes, you can get to it directly from the appropriate forum and from the active threads link, but it does not show up when looking at the Recent Posts|Posts added today list. Or at least it doesn't show up on the first page as I would expect as there are posts to it more recently than some of the "newest" posts currently in that list...
-Luke.
Yep!! till few hours back it was showing up in the posts added today list... I noticed this behavior just now.
June 16, 2009 at 1:12 pm
Luke L (6/16/2009)
Alvin Ramard (6/16/2009)
ps (6/16/2009)
i cant find this thread in the main forum? only from my email notifications i can read it. Has this been removed from main forum?It's there. When I looked it was the first item under "Anything that is NOT about SQL!"
Yes, you can get to it directly from the appropriate forum and from the active threads link, but it does not show up when looking at the Recent Posts|Posts added today list. Or at least it doesn't show up on the first page as I would expect as there are posts to it more recently than some of the "newest" posts currently in that list...
-Luke.
I don't think you're looking in the right place, or you're looking at a cached page.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 16, 2009 at 1:17 pm
no i'm getting all updated posts if i click on posts added today.
except this thread.. also tried to refresh by ctrl+F5.. same results...
June 16, 2009 at 1:17 pm
GilaMonster (6/16/2009)
Roy Ernest (6/16/2009)
Gail, I think it will be Sri Lanka that is going to take it. SA has no clue how to play spinners.. 🙂Ooohhh... You're asking for it, aren't you. 😉 😀
Go Proteas!
Gail tell him something about RSA Springboks,
now that is a real sport 🙂
-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."
June 16, 2009 at 1:21 pm
ps (6/16/2009)
no i'm getting all updated posts if i click on posts added today.except this thread.. also tried to refresh by ctrl+F5.. same results...
Same here, getting updated lists of posts from the Posts Added Today link, but this topic does not appear. It used to, but for some reason it no longer does. Perhaps it's just grown too large? That or it's trying to hide itself as it prepares to take over the world...
-Luke.
June 16, 2009 at 1:25 pm
Luke L (6/16/2009)
ps (6/16/2009)
t or it's trying to hide itself as it prepares to take over the world...-Luke.
Looks like this is the most probable reason.:w00t:
Viewing 15 posts - 5,761 through 5,775 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply