Simple set variable, what am I missing 
Author Message
 Simple set variable, what am I missing

Sorry, braindead today, what is wrong with the statement below?



or



Both do not work

*** Sent via Developersdex http://www.***.com/ ***
Don't just participate in USENET...get rewarded for it!



Wed, 17 Mar 2004 00:59:32 GMT
 Simple set variable, what am I missing

try:

dwhtime.weekid = 1)
it's only the parenthesis you're missing.
Alternativeley, T-SQL support this syntax:

dwhtime.weekid = 1
But this is not ANSI compliant

Quote:
>-----Original Message-----

>Sorry, braindead today, what is wrong with the statement
below?



dwhtime.weekid = 1

>or



= 1

>Both do not work

>*** Sent via Developersdex http://www.developersdex.com
***
>Don't just participate in USENET...get rewarded for it!
>.



Wed, 17 Mar 2004 01:27:57 GMT
 Simple set variable, what am I missing
Tim:

From another posting replying to your question:



Ed Harper
Microsoft SQL Support

========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
? 2001 Microsoft Corporation. All rights reserved.
========================================================



Fri, 19 Mar 2004 06:45:32 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Embarassingly simple SQL question - what am I missing?!

2. Simple query fails - what am I missing?

3. Am I missing [ ] somewhere on this variable?

4. FTP file missing when SourceFileName is set with a Global Variable

5. Missing variable message - Nothing missing?

6. SQLPLUS and variables : how to have it not wait for input when a variable is missing

7. Simple Set statement this is very simple question

8. INITIALIZE DEVICE- -What am I missing???

9. What am I missing....?

10. Integrated Security: What am I missing here?

11. HELP: Am I missing the point or something ?

12. Help with SQL Query - what am I missing?


 
Powered by phpBB® Forum Software