Try this. I'm sure there's a ton of ways to do it. Not feeling very clever right now.

declare

@Seconds int

Set

@Seconds =

You do not have to cross post.

Since you are in somewhat of an emergency situation

do a sp_who2, and see if there are any "RUNNABLE" Connections where CPU Time or DISKIO is high.

then next do a...

As RGR stated Getting Levels is altogether another Monster

Google "Trees in SQL" and you will get a Miriad of Articles and information discussing this.

For Example.

http://www.dbazine.com/oracle/or-articles/tropashko4

Its not just a simple...

You have to do it by creating subscriptions.

Give this a read, it may be the ticket.

http://www.databasejournal.com/features/mssql/article.php/3370191

Actually,

Your probably getting the issue due to the PurDate Not knowing what datatype it is.

Try

SELECT CustID, PurchaseType, Store, COUNT(*) AS TotalCt

         DATEPART(mm,PurDate) AS Month, datepart(qq,PurDate) AS Qtrr

         FROM dbo.HomeImprovement

        ...

Then you'll need to return the first Name, and Last name individually and exclude the "FullName" value. and then Concantenate on the presentation Layer.

you can still use a collate function in your where clause without Changing your table definitions.

SELECT    mycolumn

FROM      mytable

WHERE     mycolumn COLLATE Latin1_General_CS_AS like  'a%'

that is about the cleanest way to do...

Zip codes are 5 chars long. So you want to prefix any zip codes < 5 chars with zeros? That would be better.

If not, and it needs to be more...

Please read my post on the same subject.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=360261#bm360292

Well

the error message indicates the error is bubbling up from

Server: Msg 512, Level 16, State 1, Procedure ATEC_PriceStatus_UPSERT, Line 5

Can you post the entire procedure.

your code does not show a subquery.

typically this happens when a query is constructed this way.

Select *

From Mytable

Where MyCol = (select SomeCol

                      from ATable

                      Where Value = 'This')

If the subquery...