To prevent loss of speed with your queries without the WITH (NOLOCK) option, you must keep all exclusive locks (INSERTs, UPDATEs) to a minimum. That means optimizing the code to...

swapshines9 (9/24/2008)

Now I need to create sp that insert values in to the third table and save, but the EmpDeptName should not be visible in the backend. Actually I had...

I quess a UPDATE-trigger would be fired multiple times, but I'm not sure. You can test this by letting the trigger add a row with the updated values to a...

Your environment is working at this moment, so you could leave it as is. But invalid...

If you have to change several columns, try to split up the changes in portions you can handle. Begin with adding 1 (empty) column. Fill this column with converted datetime...

Primary Key can only contain unique values. You second insert tries to add value 1, 2, 3, 4 and 5 to the primary key but these values allready exist, thus...

b_boy (9/24/2008)

(100.*

sum(case datepart(yy,t.orderdate) when 2008 then 1. else 0. end) /

sum(case datepart(yy,t.orderdate) when 2007 then 1. else 0. end)) - 100. as 'Percent Change'

from t_orderline tl inner join t_items...

Please use capitals, punctuation and linefeeds for readability!!!

Can't you just leave the EmpDeptName out of the third query??

juliane26 (9/24/2008)

So I follow that in table B I have more than one entry for each value in c1. (I will check on this)

If so - why does...

A LEFT OUTER JOIN never returns less rows then the left table (table A in your sample). But if table B is joined to table A in a one-to-many relation,...

You can add a column of type DateTime to the table. Try to convert the dates from the varchar column to dates in the datetime column. You can do this...

can you specify what they tried to modify? And are you sure it was in the correct database where you assigned them the ddl_admin rights to?

from BOL:

Members of the db_ddladmin...

You can use the following SP sp_send_dbmail inside your job/query to send a mail. If you wrap this inside an IF statement the mail is sent when a condition is...

On the Microsoft download site you have links to the setup documentation and a readme file.

http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en

But it basically comes down to:

- backup your server

- backup your databases

- install SP2

bitbucket (9/23/2008)

---

I would like to thank all who have commented. I have learned a little more to apply to any additional QOD that I may submit. Please note...