Viewing 15 posts - 3,436 through 3,450 (of 6,036 total)
Kenneth Wilhelmsson (10/18/2007)
😉Look at the top.
The declaration of @p is inside the while loop.
...unless you're really asking for something else? 😎
No.
It's text editor what allows to put declarations of variables...
_____________
Code for TallyGenerator
October 18, 2007 at 3:55 am
October 18, 2007 at 3:02 am
Rowdy Johnson (10/18/2007)Still this goes back to having a huge table with entries for every second of every day
Who told you it's gonna be a huge table?
There are 86400 seconds...
_____________
Code for TallyGenerator
October 18, 2007 at 2:57 am
I wonder - which programming language will let you declare a variable in loop?
_____________
Code for TallyGenerator
October 18, 2007 at 2:38 am
Max Yasnytskyy (10/18/2007)
Are you trying to say that to solve this sort of problem any additional table is required?
You've got a choice:
either dynamically generate the set of values every time...
_____________
Code for TallyGenerator
October 18, 2007 at 12:56 am
Max Yasnytskyy (10/17/2007)
Jeff Moden (10/17/2007)
Max Yasnytskyy (10/17/2007)
P.S. i'm mainly working with SQL 2005 and assume that everyone else too works on it:)
I'm working on SQL2000 and playing with SQL2005.
Still have...
_____________
Code for TallyGenerator
October 18, 2007 at 12:08 am
Max Yasnytskyy (10/17/2007)
So what if you have an index on the column, would it not just be an index scan, which isn't that bad?
Index contains values from the column.
And it's...
_____________
Code for TallyGenerator
October 17, 2007 at 11:20 pm
SELECT A.some_fields, B.some_fields
FROM A
LEFT OUTER JOIN B ON A.f1=B.f1
WHERE func(A.something)=true
Clause "func(A.something)=true" is big NO-NO in queries.
Results in table scan every time.
Rethink your query to avoid such calls.
_____________
Code for TallyGenerator
October 17, 2007 at 9:42 pm
Lowell (10/17/2007)
IF @TmpString NOT LIKE '[0-9]'
or if it was part of a large string, you'd add percent signs for the wildcard matches:
IF @TmpString NOT...
_____________
Code for TallyGenerator
October 17, 2007 at 9:37 pm
Max Yasnytskyy (10/17/2007)
Fair enough.How would you use LIKE [0-9] without making the query too complicated?
In your script:
IF @TmpString NOT LIKE [0-9]
Not too complicated?
:hehe:
_____________
Code for TallyGenerator
October 17, 2007 at 8:52 pm
Max Yasnytskyy (10/17/2007)
_____________
Code for TallyGenerator
October 17, 2007 at 8:27 pm
Mike C (10/17/2007)
Sergiy (10/17/2007)
It's on top of the page, between "Home" and "T-SQL".
There is no...
_____________
Code for TallyGenerator
October 17, 2007 at 8:19 pm
OK, what about '-', '.', ',', who knows what else?
_____________
Code for TallyGenerator
October 17, 2007 at 8:00 pm
Max Yasnytskyy (10/17/2007)
According to the BOL:
ISNUMERIC returns 1 when the input expression evaluates to a valid integer, floating point number, money or decimal...
_____________
Code for TallyGenerator
October 17, 2007 at 7:19 pm
Mike, it would be nice if you'd pay some attention to the name of the forum.
It's on top of the page, between "Home" and "T-SQL".
There is no point to repeatedly...
_____________
Code for TallyGenerator
October 17, 2007 at 7:11 pm
Viewing 15 posts - 3,436 through 3,450 (of 6,036 total)