Viewing 15 posts - 2,686 through 2,700 (of 4,080 total)
You might also consider using the char datatype, which is fixed length, instead of padding and using SUBSTRING. It will save you a few CPU cycles.
declare @char...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 3, 2009 at 7:52 pm
Yes, it is normal. Unlike char, the varchar datatype is variable in length and no purpose would be served by storing trailing blanks.
From BOL (books online):
char [ (...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 3, 2009 at 7:40 pm
Are all the columns in common between the 50 stored procedures? Even if you defined a temp table with enough columns to handle any of the stored...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 3, 2009 at 7:32 pm
I'll chime in as well.
IF EXISTS returns TRUE if any row would be returned from the subquery.
It looks like you confused it with...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 3, 2009 at 7:01 pm
Was that thread closed to protect the innocent and unwary? I couldn't peek at it.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 1, 2009 at 2:47 pm
In a nutshell, yes. More rows will fit on a page if you are selecting less columns, which means less memory requirement and possibly less I/O. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 1, 2009 at 9:11 am
I agree about the dynamic cross-tab being an excellent solution to the problem. I also think this is awful database design. Sorry, but while I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 1, 2009 at 8:09 am
Is it including the "EXEC" line as a part of the stored procedure? Or are you highlighting and running the ALTER segment separately?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 1, 2009 at 7:52 am
Some other options if you have from 1-X characters following the year/month/date:
declare @samples table (result varchar(15))
insert into @samples
select '2009080105' union all
select '20090801099' union all
select '200908010111' union all
select '2010010102'
select right(result,len(result)-8) as...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 1, 2009 at 6:34 am
RapMaster Jeff, aka Signifying Tally. 😛
I don't think he
Is gonna be
A Ph.D.
Can he write a que-ry?
Let's wait and see.
P.S. Barry: It's not just...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 31, 2009 at 12:10 pm
Currently I'm more of a mathematical concept than a name.
Good one, Crawfish!! Thunderous laughter ensues.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 30, 2009 at 3:39 pm
Doh!
I am so embarrassed I feel the need to derive to a point again.
However, I have to laugh at the confusion this will engender in people who read this well...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 30, 2009 at 3:04 pm
Bruce: Do you mean I am THE only volunteer here? :w00t:
Lynn: Things are coming around. I no longer feel the need...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 30, 2009 at 2:34 pm
Thanks, Lynn.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 30, 2009 at 2:20 pm
I just got caught up on the last couple of days of The Thread 🙂
Welcome back and nice going, Roy!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 30, 2009 at 1:42 pm
Viewing 15 posts - 2,686 through 2,700 (of 4,080 total)