Viewing 15 posts - 766 through 780 (of 5,590 total)
Hey Brandie... I noticed your LinkedIn profile has you in a new position - are you moving away from SQL, or is this additional stuff that you're piling on yourself?...
August 20, 2012 at 1:43 pm
Lynn Pettis (8/16/2012)
Here is one for the do not hire list.Or it could be the needs much training list.
I just had to respond.
August 16, 2012 at 3:00 pm
Insufficient information to answer:
1. How many rows are in this TOYS table to begin with?
2. As asked earlier, how do the people "see" the "12" rows?
a....
August 16, 2012 at 2:58 pm
SQLRNNR (8/15/2012)
For the Rhode Island SQLSat, how about we all wear kilts?
Is that for speakers, attendees, or all?
August 15, 2012 at 12:31 pm
Update: the distributed transaction had to be killed (aborted) in the DTC snapin.
Edit: Link for tracking this down and doing this[/url]
August 15, 2012 at 9:35 am
Check out the 2 "There must be 15 ways to lose your cursor" articles by RBarryYoung at http://www.sqlservercentral.com/Authors/Articles/RBarry_Young/659055/[/url]. They walk you through pretty much exactly what you need to do.
August 15, 2012 at 8:40 am
All that shows up in sys.dm_exec_requests are the transactions being blocked by session id "-2".
And then, just seconds later, it has cleared.
Okay, any ideas of what caused it to clear?
August 15, 2012 at 8:33 am
buntyteg (8/14/2012)
in correct answer -1,1 is correctbut how 25 is correct
means to say... in bit datatype how we can store 25 (2 digit) value
??????
If it helps, think of it...
August 14, 2012 at 1:50 pm
Stefan Krzywicki (8/14/2012)
Lynn Pettis (8/14/2012)
Brandie Tarvin (8/14/2012)
August 14, 2012 at 12:16 pm
Hugo Kornelis (8/14/2012)
WayneS (8/14/2012)
August 14, 2012 at 8:11 am
Dana Medley (8/14/2012)
I almost fell prey to the wording of the question, but after reading it twice I realized my original answers were incorrect. Thank you for the great question.
Dana,
I'm...
August 14, 2012 at 7:37 am
Jan.Sundbye (8/14/2012)
Good one. Once again I fell right into the trap. Must remember to RTFQ / RTFS (Read the **** Question / Statement)
Jan,
I was trying to not have a "trap"....
August 14, 2012 at 7:35 am
One of the things that I'm trying to learn is to write better QotD questions. It looks like most that have responded here about missing it have acknowledged not reading...
August 14, 2012 at 7:34 am
If you want to pass in a ProVerCode, then why don't you try something like this?
WITH cteEnrollm AS
(
SELECT Enrol_ID, ProVerCode, Stude_ID
FROM (
Values
('11111', 'AR-216', '65468'),
('77777', 'AR-216', '54564'),
('22222', 'AR-216', '56475'),
('66666', 'PO-216', '87953'),
('33333',...
August 13, 2012 at 11:32 am
'Cause that's too easy???
Seriously, thanks. It was so obvious. I thought I had ran into problems doing this in the past, but it seems to be working okay right now.
August 13, 2012 at 10:29 am
Viewing 15 posts - 766 through 780 (of 5,590 total)