Viewing 15 posts - 136 through 150 (of 328 total)
Lowell's answer is probably more practical. Also for my post, I forgot the procedure declarations!
DECLARE @TABLE_NAME VARCHAR(100)
SET @TABLE_NAME = 'ABC'
SELECT
CASE
WHEN SEQ = 2 OR SEQ = 7 OR SEQ...
June 19, 2012 at 12:36 pm
I like to write code generators from the catalog (view is INFORMATION_SCHEMA.COLUMNS)
(obviously for the sake of discussion, we hope a table called ABC actually exists)
DECLARE @TABLE_NAME VARCHAR(100)
SET @TABLE_NAME = 'ABC'
SELECT...
June 19, 2012 at 11:55 am
pwallis (6/19/2012)
Stewart "Arturius" Campbell (6/19/2012) hinted that it may be posssible to get the information using a join...hopefully...
June 19, 2012 at 10:30 am
GSquared (6/18/2012)
patrickmcginnis59 (6/18/2012)
Matt Miller (#4) (6/18/2012)
patrickmcginnis59 (6/18/2012)
The question isn't whether disparity exists, it's whether the ability to move along the income spectrum exists.
Everybody on the lower income spectrum...
June 18, 2012 at 2:46 pm
From what I can tell by the referenced string splitter routine presented by Jeff Moden, when fed a delimitted string, it returns a table like:
return_table(
itemnumber int,
item varchar(whatever)
)
so to use this...
June 18, 2012 at 11:07 am
Matt Miller (#4) (6/18/2012)
patrickmcginnis59 (6/18/2012)
The question isn't whether disparity exists, it's whether the ability to move along the income spectrum exists.
Everybody on the lower income spectrum would like...
June 18, 2012 at 10:25 am
Matt Miller (#4) (6/15/2012)
chrisn-585491 (6/15/2012)
June 18, 2012 at 8:59 am
jay-h (6/15/2012)
Cade Roux (6/15/2012)
bwillsie-842793 (6/15/2012)
.... This is very much due to the current state of wealth redistribution where wealth is being more and more redistributed to the top (to people...
June 15, 2012 at 11:01 am
rajiv.varma (6/8/2012)
June 8, 2012 at 10:39 am
I remember one student who upon using visual studio said that painting buttons and textboxes were interesting but the typing in the code windows, not so much.
June 7, 2012 at 1:35 pm
Eric M Russell (6/6/2012)
I personally wouldn't consider PowerShell, Perl, or even T-SQL scripting to be "software development". Likewise, I wouldn't consider Entity Framework or LINQ to be "database development".
According to...
June 6, 2012 at 1:58 pm
GSquared (6/4/2012)
June 4, 2012 at 7:36 am
Grant Fritchey (5/31/2012)
patrickmcginnis59 (5/31/2012)
Grant Fritchey (5/31/2012)
I'm with you. Fast enough is fast enough.
But, I remember when a friend of mine (wish I could say I did this) spotted a problematic...
May 31, 2012 at 11:52 am
Grant Fritchey (5/31/2012)
I'm with you. Fast enough is fast enough.
But, I remember when a friend of mine (wish I could say I did this) spotted a problematic query in one...
May 31, 2012 at 11:16 am
Grant Fritchey (5/31/2012)
TravisDBA (5/31/2012)
Sorry about that. I was trying to make the point that "generic" database designs aren't really possible due to the nature of the underlying infrastructure. Clearly failed.
I'm...
May 31, 2012 at 8:58 am
Viewing 15 posts - 136 through 150 (of 328 total)