Do you have a query window open in SSMS pointing to that database? If so, just change the current db.

Evil Kraig F (1/5/2012)

---

Martin Schoombee (1/5/2012)

---

That would be better, yes. Flashing text seems a much better idea in theory than it actually works in practice. It usually turns out to...

And even if you could get it to flash in the webviewer you wouldn't be able to keep that when the user saves it, or not at all if they...

Right after I finish THINKING IN THE WOODS. 😀

You're welcome. Let us know which one ends up performing the best of the three. I would be interested to know which one wins that race. 😀

OK I have a fakenames table that I keep around for various times I need this type of thing. I included the first 100 rows from that as a starting...

Just need to reverse it.

RIGHT( REPLICATE( (DT_STR,30,1252)"0", 18) + (DT_STR,30,1252) [Col1], 18)

becomes

LEFT((DT_STR,30,1252) [Col1] + REPLICATE( (DT_STR,30,1252)"0", 18), 18)

That is actually what I posted. I assumed that was what you were after. Notice in the subquery that the specific values are commented out.

Seems that you should figure out the reason you are getting deadlocks instead of kludging around them. There is an issue if you have to code something to try the...

Your english was fine and you did a great job posting details so we can answer your question.

If I understand your issue, something like this should work:

update @spotCM_cc46311AREP

set man_Hours_en =...

You're welcome. thanks for letting us know that worked for you.

And there is no need for a subquery as your main table. You are pulling back a lot of information you don't need. You used select * when you only...

Are you just trying to randomize the first names and the last names? Your performance is because of the cursor. You could create a temp table, then insert firstname order...

Shree-903371 (1/4/2012)

---

Ok, the current date is 2012/01/04. So for previous week will be 2011/12/25.

When we use datepart for 2011/12/25, it gives 53. But it must 52 as we have 52...

Can you post some ddl (create table scripts), sample data (insert statements)? I pretty much understand what you want out of it. Hopefully you have some consistency in your formatting...