Viewing 15 posts - 31 through 45 (of 370 total)
I didn't know we could have an identity column in a table variable.
And that it can't be reset. I was expecting it wouldn't be possible to truncate the table though.
I...
August 17, 2012 at 7:18 am
Hi.
What is the exact error message you're receiving?
August 17, 2012 at 5:44 am
Nice. That's almost the same thing without using a derived table.
I tend to use it whenever possible (or even CTEs) to make the code more readable. 🙂
Have a great week!
August 13, 2012 at 8:03 am
Does this work?
SELECT ta.ErrorID, tab.ErrorType, tab.DateLogged,
CASE WHEN total = 1 THEN tab.PolicyNumber ELSE 'MULTIPLE' END
FROM (SELECT tblErrors_ER.ErrorID, tblErrors_ER.ErrorType, tblErrors_ER.DateLogged,
...
August 12, 2012 at 5:04 pm
I'm on a computer that don't SQL Server installed but you could try to use COUNT in an inner SELECT and then in an outer SELECT you could use something...
August 12, 2012 at 4:58 pm
Hugo Kornelis (8/4/2012)
My personal answer is a combination. In the role of answering questions, the value of the QotD to me is a combination of judging my knowledge and learning.
+1
August 4, 2012 at 4:03 pm
Thanks for a straightforward question.
I found it quite easy because it's one of the opened doors for SQL injection.
August 3, 2012 at 9:00 am
The QotD is not also about judging our skills?
July 30, 2012 at 11:18 am
Got it wrong and I'm satisfied because it was a very interesting question.
Microsoft always makes QotD harder than it should be because many things don't work the way we logically...
July 27, 2012 at 5:21 pm
harsh.lapashiya (11/15/2011)
good twisterTo get third highest salary
select MAX(salary) from Employees where salary <(select MAX(salary) from Employees
where salary <(select MAX(salary) from Employees))
I know this is a year old post but I...
July 22, 2012 at 3:57 pm
John.Sansom (7/19/2012)
In my own experience, both as a candidate and a hiring manager, I have found that the additional effort spent on a resume is always a worthwhile investment.
Thank you...
July 19, 2012 at 9:59 pm
I guess there are no default recipes and most of the people will say "it depends". 🙂
July 19, 2012 at 9:26 pm
At some point, I will apply for the three exams required for me to upgrade my MCITP to MCSE. But right now I've been wondering "is it the right decision"....
July 19, 2012 at 9:12 pm
Viewing 15 posts - 31 through 45 (of 370 total)