I can't tell if you want "High/Low" returned as a literal or a boolean... this will do the boolean thing... let us know what you really need.

DECLARE @MyCase INT

... do...

Yep... use OSQL to run the query from a CMD prompt (or using xp_CmdShell w/ trusted connection) with a redirect (the -o option) to a text file.

See "Books Online" for...

Mark,

Remi and I got a bit carried away on a sidebar... are you all set or do you need additional help?

Roger that... thanks.

Alright... I've been looking for a while, now... how the heck do you submit a QOD on this forum?

p.s.  Forgot to mention that the 812006 in the file names can change...   I just assumed that the "Watch" prefix could change, as...

Outstanding, Ray... that was the next thing I was going to ask... who changed what?  You beat me to it.  And, thank you very much for the feedback... you'd be...

First, you must realize that SQL is NOT SQL... most books on SQL I've seen rely on supposed advanced techniques using ANSI SQL.  Others are based more on what Oracle...

Was it ever able to see D?

Vladimir,

The best way to do this is to collect all the data from the user first even if it's for 4 or 5 levels, as you claim.  Then, do a...

Might as well bite the bullet while you're small...

Lock down the production database.  Remove SA, DBO, and DDL ADMIN privs from all developers and users.  Insist on code reviews and unit/itegration...

I think you may want to look into the reason for the backoffice DB starting up twice... that should not happen...

I concur with Remi... a simple polling job is not going to be any load on the server at all.  We have a couple that run using the undocumented but...

If the tables already exist, there should be foreign keys in the child tables (the "many") that point to the parent tables (the "one").

If not, then, as Sreejith suggested, you...

You can fool around with user names, if you want, but those can always be tricked especially when users make the mistake of sharing logins...

If your Windows network is setup...