Viewing 15 posts - 4,396 through 4,410 (of 9,722 total)
I have a question for all the SQL Saturday organizers.
What type of topics do you see a need for that you don't see enough of?
What level of topics do...
May 21, 2012 at 5:33 am
I actually have a real review of one of my stories. A real one, as opposed to a review that doesn't say anything.
<insert happy Snoopy dance>
http://www.goodreads.com/review/show/175988972
Sorry for interrupting SQL-ness, but...
May 21, 2012 at 4:47 am
Steve Jones - SSC Editor (5/18/2012)
Brandie Tarvin (5/18/2012)
Steve, would you approve such an animal if I sent it...
May 18, 2012 at 12:29 pm
BTW, I'm linking people to my happy announcements list for the next two weeks.
http://www.absolutewrite.com/forums/showthread.php?t=245248
And... The Hivemind Collective has a website now for the Latchkeys series with links to Kindle &...
May 18, 2012 at 12:28 pm
I am so tempted to do the Holy Grail joke as a QotD.
Steve, would you approve such an animal if I sent it in?
May 18, 2012 at 12:22 pm
Steve Jones - SSC Editor (5/18/2012)
Gazareth (5/18/2012)
Brandie Tarvin (5/17/2012)
Hey, Steve, can you change the birth year in my profile to read 1776, please?😀
I wonder if he could change it to...
May 18, 2012 at 11:03 am
SQL Kiwi (5/18/2012)
john.p.lantz (5/17/2012)
select * from table1 a
join table2 bon a.id_rssd =...
May 18, 2012 at 6:18 am
I will try the code with the Merge. I've already done the non-Merge method, which required several statements. Maybe Merge can help me compress that a bit.
May 18, 2012 at 4:45 am
John,
Your first post indicates that your real code is much more complicated than the code you posted in this thread. Is that true?
If so, can you post the code so...
May 18, 2012 at 4:42 am
Eugene, I appreciate what you're saying, but please watch how you word it. Your tone in your last post came across very harsh and .. well, there's another poster on...
May 17, 2012 at 12:53 pm
That's what I was wondering. Thank you, Gus. You have saved me some head-banging time.
May 17, 2012 at 11:51 am
When executing your query in SSMS, go to Query -> Include Actual Execution Plan. Alternately, if you don't want to run the query, you can use Query -> Display Actual...
May 17, 2012 at 11:49 am
Books Online has all the details on how to use the transformation tasks that I told you about. If you want to use SSIS, refer to that and the Microsoft...
May 17, 2012 at 11:46 am
drew.allen (5/17/2012)
I prefer this to prevent NULL values.
DECLARE @L_ZERO INT = 0
SELECT @L_ZERO = IdMyTable FROM MyTable WHERE ColumnRef = 1000
Drew
Drew, how does that prevent NULL from overriding your 0?
May 17, 2012 at 11:44 am
If there's no auditing, then the only possible option is to look at Active Directory for those logins that are domain logins. If they're all SQL logins, there is nothing...
May 17, 2012 at 11:42 am
Viewing 15 posts - 4,396 through 4,410 (of 9,722 total)