This is really helpful tom. Thanks !!!!

Tom Goltl (11/19/2007)

---

You can also use char(39) as a single quote.

Example.

Select char(39) + name + char(39) from sysobjects

Just build your string using char(39) to...

Bil, Thanks for your inputs. But the query you sent is static, the case statement has only two comparisions, I have more than 20+ tables that I am going to...

Thanks sean, I have given the stored proc to the business, but they are specifically looking for a function instead of stored proc. So Just wanted to know if I...

I wanted to return the business date from the table which i am passing as parameter. Let me know how to correct it ?

Did any one has inputs on this ?

Yes, I managed to getrid of subqueries and joined all my selects in to one and got the result.

Thanks for your Inputs. I did managed to join the tables.

Does any one has inputs on this ?

Yes as Sean Said you have to specify all the columns that you are using in the select statement in your Group By Clause expect the aggregate.

There is no way that you can bypass the usage of T-Log, You can automate to delete the data from the table in chunks on daily or weeks whichever convenient...

Hi Please find the procedure to recreate the built in Administrators Account

First off you need to shut down all the SQL Server related services. This can be done manually...

Deepthy,

Verfiy the owner of the job.If the job is running with the credentials of the developer who was workign with you previously if yes change...

Eugene,

what my criteria is if the table is idle for two hours i,e no activity is done on the table for about two hours the trigger needs to...

jeff,

can explain it bit clear how can we schedule the job please post in detail procedure with the script.

Once aging thanks for your reply.