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...
October 18, 2007 at 3:55 am
Really?
:w00t:
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...
October 18, 2007 at 2:57 am
I wonder - which programming language will let you declare a variable in loop?
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...
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...
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...
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.
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...
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:
October 17, 2007 at 8:52 pm
Max Yasnytskyy (10/17/2007)
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...
October 17, 2007 at 8:19 pm
OK, what about '-', '.', ',', who knows what else?
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...
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...
October 17, 2007 at 7:11 pm
Viewing 15 posts - 3,436 through 3,450 (of 6,036 total)