Certainly not a bother. Glad you figured it out and thanks for letting us know.

spro1210 (2/28/2012)

---

Choose a Job Description and increase by 10% all employees’ salaries that have the selected Job Description (not Job Title).

But it's not coming out right. Any...

Can you post some of your script so we can how you are declaring it and using it?

And probably better to use a join instead of comma separated tables, using tables like that makes it REALLY easy to accidentally get a cross join.

rabisco (2/28/2012)

---

What I'm trying accomplish is this.

The ideal.

For every paragraph , users should enter a value for code1 and code2.

The current situation.

Users have created some documents which have only values...

At some level there has to be at the very least one or two people that have access to the code. It sounds like ultra paranoia to me that you...

Take a look at profiler.

SET PARSEONLY ON

GO

--your t-sql here

GO

SET PARSEONLY OFF

GO

Never tried that in an app to see what happens...I would be interested to see what happens.

How about http://msdn.microsoft.com/en-us/library/ms188776.aspx

No offense but you try googling for this? I am guessing this database was replicated at one point?

http://blog.sqlauthority.com/2009/09/05/sql-server-fix-error-cannot-drop-the-database-because-it-is-being-used-for-replication-microsoft-sql-server-error-3724/%5B/url%5D

Saintmount.Sql (2/27/2012)

---

HI,

Could you please let me know what are factors need to consider for estimating the SQL Server reporting development in order plan the report as simple, medium,...

shew (2/28/2012)

---

Sean Lange (2/28/2012)

---

Because the homework question said to not use them??? Such a strange request and...

The last thing I want to do is to parse all this to strip our your database and schemas so that I can get your data into my test environment....

Because the homework question said to not use them??? Such a strange request and twice on the...

How completely random that this question was asked twice on the same day!?!?!?!?

Here is the other thread. http://www.sqlservercentral.com/Forums/Topic1258889-391-1.aspx

Please realize that NOLOCK is by...