Viewing 15 posts - 50,806 through 50,820 (of 59,078 total)
No way to do it in a view in SQL Server 2000 and actually have some performance left. How many rows are you talking about?
May 1, 2008 at 7:35 pm
Adding a computed column takes 0 ms and no extra disk space. If the column is precise and deterministic, adding an index to it will take about half an...
May 1, 2008 at 7:29 pm
Something "like" this should do it...
IF Column1 LIKE '[0-9][0-9]-[A-Z][A-Z]-[0-9][0-9]-[0-9][0-9][0-9][0-9]'
BEGIN
---your code here---
...
May 1, 2008 at 6:34 pm
True NULLs frequently show up as "nothing" and you shouldn't change that. If you want to see the word 'NULL', then write a SELECT that changes null values to...
May 1, 2008 at 6:30 pm
Like this...
SELECT *
FROM (--==== Test data
SELECT '43161234' AS Value UNION ALL
...
May 1, 2008 at 6:24 pm
dfalso (5/1/2008)
May 1, 2008 at 5:40 pm
Understood.
You guys go ahead and call it whatever you want...that's the beauty of programming. I named it after the 2nd definition of "Tally" found here...
http://education.yahoo.com/reference/dictionary/entry/tally
... which says...
2.a. ...
May 1, 2008 at 5:14 pm
I love testing... got any test code you'd like to share? Paging is always one of those PITA's that people (not you) have a hard time getting their arms...
May 1, 2008 at 1:13 pm
Same thing applies, Lynn... let the developers do what they want in Dev... keep them out of QA, UAT, and Prod.
May 1, 2008 at 1:04 pm
Matt Miller (5/1/2008)
speaking of dupes...methinks we've all been duped into continuing to beat up on this topic, since the OP is long gone...:)
Yep... gotta love it when the OP bails...
May 1, 2008 at 1:02 pm
Heh... sorry about the "soapbox" coming up... 😀
The "best" way to do all of this is to not let dupes into production tables to begin with. Unknown data should...
May 1, 2008 at 12:10 pm
John Mitchell (5/1/2008)
Or this one, which uses less string manipulation, but does contain dynamic SQL:
Nicley done but, be careful... get more than 8000 characters (about 16 rows in the example...
May 1, 2008 at 11:59 am
Michael Valentine Jones (5/1/2008)
Jeff Moden (5/1/2008)
Michael Valentine Jones (5/1/2008)
It's probably better to avoid using a reserved word, like INDEX, for a table name.
Or "number" or "sequence" or... that's all part...
May 1, 2008 at 11:50 am
RyanRandall (5/1/2008)
IIt's all much of a muchness really.
'zactly... 🙂
May 1, 2008 at 9:27 am
Viewing 15 posts - 50,806 through 50,820 (of 59,078 total)