Wait a sec, the OP mentioned SQL Server 2008 R2.. nevermind 😉

laurie-789651 (7/26/2012)

---

How about this: I haven't tested it myself because there's no test data supplied 🙂

WITH CTE_2010 AS

(

Select [Business Unit],

Count([Business Unit]) [Total No Of Tenders],

Sum(Case When [Submitted Status]...

That won't work for SPs....

http://www.red-gate.com/products/sql-development/sql-search/

What happens if you issue

RESTORE DATABASE model WITH RECOVERY

from another process?

You haven't even tried, have you?

Shouldn't be too hard based on your previous post

http://www.sqlservercentral.com/Forums/Topic1332742-392-1.aspx

tobinare (7/20/2012)

---

Thanks, clayman and vinus! Both solutions worked with the exception of one maybe not so small point. I did not get the symbols in the header. Is...

Hi there,

try

DECLARE @info NVARCHAR(MAX)

DECLARE @InfoPvt NVARCHAR(MAX)

DECLARE @sql NVARCHAR(MAX)

SELECT @info = STUFF(( SELECT ', ' + 'MAX(' + TempSymbol + ')'

...

See if this helps

DECLARE @cols VARCHAR(500)

DECLARE @cmd VARCHAR(5000)

SELECT @cols = STUFF(( SELECT...

Hi,

Looks like the send mail task...

Have you considered using SSIS?

Not sure how the above posts would help at this point..

I would focus on the query that is causing the blocking lock rather then on the one that is blocked....

nitin.lokhande (6/27/2012)

---

Hello Friends

I need to find out excel filet modified date. my task is that based on modification date = todaydate then i have to execute the task.

i...

pistolpete (7/17/2012)

---

First of all, I am fairly new to SQL as you will be able to tell. What kind of things could I possibly do to speed up a...