I agree with most people on avoiding being the single person that knows everything and the ultimate problem solver.

However, I would like to encourage another point of view. You should...

Ed Wagner (6/17/2014)

---

Okay, now that's just plain weird. I've never seen that one before. I wonder...if you get the two windows logged in under a different account, which...

I'm not sure what happened in here :w00t:

Eugene Elutin (6/17/2014)

---

Sorry Luis, help with what?

First of all it is a bit different...

Would a post from Gail's blog help?

To TOP or not to TOP an EXISTS[/url]

You might be looking for something like this:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Read the article and ask any questions that you might have.

Is this a signal to stop...

Nice work Chris,

I would make a small modification because it's losing values from the last day.

;WITH RecordedMsgs (CallDate, Extension, CallerID, CalledID) AS (

SELECT '2011-12-04 01:59:59.999', 'night', 1, 20 UNION ALL

SELECT...

David Burrows (6/16/2014)

---

Except that in one match already, with two different views of the goal line, one clearly showed no...

Maybe something simple as this:

SELECT a.custID,

SUM(CASE WHEN MM BETWEEN 1 AND 3 THEN Amt END) SumQ1 ,

...

Sean Lange (6/13/2014)

---

hehe soccer isn't really a season per se. Especially those of us in the U.S. We have MLS in the summer and all the...

You're using more variables than the ones declared. It should be more like this:

EXEC sp_executesql @SQL, N'@aId nvarchar(50) output, @dId nvarchar(50), @dStatusId nvarchar(50)',@aId output, @dId, @dStatusId;

Thinking again, I might suggest a trigger approach on the case that you can soft-delete contracts with out soft-deleting the organisation. Using the FK approach, you wouldn't be able to...

SQLRNNR (6/13/2014)

---

The Dixie Flatline (6/13/2014)

---

Sean Lange (6/13/2014)

---

I hope I don't have to avoid SSC for the next month so I don't hear scores before I am able to watch the...

Kuzey (6/13/2014)

---

Hello,

I have been using dynamic sql in an inner cursor and I get an error about the fetched variable of the outer cursor. How can I fix it?

And the...