Works OK for me. Please will you provide table DDL (in the form of CREATE TABLE statements) and some sample data (in the form of INSERT statements) for table1,...

That's not a view - it's just a SELECT statement. Please will you post the whole view definition and we should be able to help you.

Thanks

John

Thanks for posting back. It's customary in situations like this for you to post some code or a description of how you fixed it, please, in case someone else...

It all depends how many packages you have, and how distributed are the servers that they read or update. Usually, I would want my config information close to my...

Just use bigint instead of int. If you insist on it being a 12-digit number, you can either start at 100000000000, or have your presentation layer pad the number...

To get the date portion, cast your date value as date. To get the seconds, use DATEDIFF to find the seconds between the date value and the date portion...

You're quite right, Phil. In that case, I would go with Koen's suggestion and store the value in a table somewhere. It's much easier to modify a database...

I think it would be simpler if, instead of updating the config file, either you evaluate the variable using an expression, or you output a value at the end of...

That error looks specific to LiteSpeed. If I were you, I'd raise a case with Quest support - they're very helpful. Check out their knowledge base first -...

I'm surprised that more people didn't get it wrong - especially if, like me, they attempt to answer without looking...

Standard Edition can be clustered - we have many instances of it where I work. As for changing the edition, I don't know. Why can't it be done...

Difficult if you are used to programming in a procedural language, maybe, but this is the sort of stuff...

To be honest, I'm surprised you're not getting that message about variable names being unique, since you're declaring it again and again in the same batch. But if it...

dardar4 (8/17/2011)

---

thnx for the help but that didn't work

insert into MyTable (file_desc, is_modified) values ('a.txt',0)

insert into MyTable (file_desc, is_modified) values ('a.txt',1)

insert into MyTable (file_desc, is_modified) values ('b.txt',0)

insert into...

Sounds like a homework question to me. Can you show us what you've tried so far?

John