Viewing 15 posts - 1,801 through 1,815 (of 3,957 total)
ChrisM@Work (6/3/2013)
TheSQLGuru (6/3/2013)
It's quicker to write FROM x a, x b than it is to track down the inline tally table code.
That's what Snippets are for silly! 😀 ...
June 3, 2013 at 6:39 pm
wolfkillj (6/3/2013)
dwain.c (6/2/2013)
I just wanted you to know that I am not trying to be rude by not letting you know if your suggestion worked.
I sent some...
June 3, 2013 at 6:30 pm
Hi again Wolf Kill.
I just wanted you to know that I am not trying to be rude by not letting you know if your suggestion worked.
I sent some suggested steps...
June 2, 2013 at 6:45 pm
Steve Jones - SSC Editor (5/29/2013)
How many peppers did Peter Piper pick when he picked pickled peppers while partaking of peas and parsnips while picking peppercorns?
My favorite: Strc prst skrz...
May 29, 2013 at 10:10 pm
wolfkillj (5/24/2013)
May 28, 2013 at 2:27 am
Thanks Wolf Kill!
This sounds promising and I'll look into it on Monday.
May 24, 2013 at 7:26 pm
lianvh 89542 (5/23/2013)
On our SQL Server 2008R2 we identified an inefficient query . We ran it through the Database Tuning Adviser and advised us to add 2 indexes...
May 23, 2013 at 12:42 am
I don't like using magic numbers in my date arithmetic, so I'd probably opt for something like this:
WITH TestData ([Year], [Month]) AS (
SELECT '2008', '2'UNION ALL
SELECT '2000', '12'UNION ALL
SELECT '2011',...
May 22, 2013 at 6:59 pm
ChrisM@Work (4/30/2013)
todd.ayers (4/30/2013)
May 22, 2013 at 6:47 pm
tacy.highland (5/17/2013)
DECLARE @Route INT
, @StarttimeVARCHAR(5)
, @EndTimeVARCHAR(5)
SELECT @sql = 'UPDATE #Summary
SET [' + @StartTime + '] = 0
, [' + @EndTime + '] = 0
WHERE route = ['...
May 19, 2013 at 7:55 pm
You most certainly do not need a CURSOR for this. In fact, as a beginning SQL person it may not be too late to unlearn what will become a...
May 19, 2013 at 7:34 pm
This should give you the UNPIVOT/PIVOT you need but perhaps you'll need to adjust the percentages.
DECLARE @data TABLE ([Year] INT, caucasian INT, Black INT, Asian INT)
INSERT INTO @data
SELECT 2012,3000,1000,100
UNION ALL...
May 17, 2013 at 12:43 am
ChrisM@Work (5/16/2013)
... the source table is read something like 8 times 😉
Only 8 times? I'd be surprised if my contribution is less than that.
May 16, 2013 at 3:03 am
Cadavre (5/15/2013)
Thanks for taking a look Dwain, be nice to see where your efforts took you.
Very well. For what it's worth:
DECLARE @pairs TABLE (dropped_id INT, retained_id INT)
INSERT INTO...
May 15, 2013 at 6:16 pm
Viewing 15 posts - 1,801 through 1,815 (of 3,957 total)