Viewing 15 posts - 1,546 through 1,560 (of 5,590 total)
Consider using the ROW_NUMBER() function to assign sequential record numbers.
April 8, 2011 at 7:13 am
Ian Scarlett (4/8/2011)
If not, then you won't have a problem, as both the lookup table...
April 8, 2011 at 7:10 am
vilonel (4/8/2011)
it will differ from employee but max will be 10 - Thank you
Please check out the two links in my signature dealing with Cross-Tabs and Pivot tables - parts...
April 8, 2011 at 7:06 am
Craig Farrell (4/8/2011)
April 8, 2011 at 7:04 am
Check out the FROM clause in Books-OnLine (BOL). The table on the report server will need to be specified in 4-part naming (Server.Database.Schema.Table).
Edit: Where Server = the Linked Server name...
April 8, 2011 at 6:54 am
Most hotels that I've stayed in have different rates, depending on the day of the week, events in town during that time period, etc. You might end up needing a...
April 8, 2011 at 6:52 am
Kiara (4/8/2011)
Frankly, I learn more when I get a QotD wrong than when I get it right. The points are meaningless - the knowledge, on the other hand, is priceless.
Awesome...
April 8, 2011 at 6:41 am
Ignacio A. Salom Rangel (4/7/2011)
Tom.Thomson (4/7/2011)
CirquedeSQLeil (4/7/2011)
April 7, 2011 at 6:01 pm
CirquedeSQLeil (4/7/2011)
In an effort to clarify - a request has been sent to Paul Randal on the subject.
FYI, Paul has responded (via Twitter):
"Tell them I said all vstore activity is...
April 7, 2011 at 2:15 pm
GilaMonster (4/7/2011)
WayneS (4/7/2011)
GilaMonster (4/7/2011)
WayneS (4/7/2011)
April 7, 2011 at 11:06 am
Thanks Ron - I think you summarized it very well. I did deliberately throw myths in there to try to trip up people - figured it would be a good...
April 7, 2011 at 11:00 am
GilaMonster (4/7/2011)
WayneS (4/7/2011)
April 7, 2011 at 10:52 am
So, what did you'll think of the QotD? I'm surprised that all of the options had some answers, and that only 10% have correct answers. The griping seems to be...
April 7, 2011 at 10:23 am
Hugo Kornelis (4/7/2011)
I especially liked the link to Gail's blog. I figured that the table variable option was the correct answer and answered without contemplating the version store...
April 7, 2011 at 10:06 am
mohammed moinudheen (4/7/2011)
It is very tough to get this question right:)
Actually, I meant it to be tough. The other choices are all myths that a lot of people believe,...
April 7, 2011 at 10:01 am
Viewing 15 posts - 1,546 through 1,560 (of 5,590 total)