I'm assuming that this is for an SQL 2012 database as its in the 2012 section.

One thing I noticed is that you are passing boundaries in for the result...

Glad you sorted your issue, Id have never thought about the hosts file.

I quite understand about not putting SSMS on the server, bit of a possible security issue, but being...

ajfarroll (12/18/2014)

---

Thanks for prompt response.

I checked the sql server text logs and they are showing no information of the attempted connection. I doubt if there will be any relevant...

No problem I think David's...

Have you asked the DBA to check the SQL server logs on the DB for the login failure, or run a trace when trying to log on, looking to see...

I thought all the NC indexes...

You have to drop the PK anyway, so why not rebuild it as an NC, then when you build the new CIDX it will rebuild all the NC indexes wont...

The key question is How long is the window in which you have to do this and how big is the table?

having done something similar, it was a case of...

As a guess something like this would work and remove all the sub queries

WITH CTE

AS

(

SELECT uompScheduleNumber,status, COUNT(*) TotalCount

FROM OrbeData_KithKitchens.dbo.WIP_master

WHERE (itemtype ='DR' or itemtype ='DDF')

AND status in ('2','3'......,'20')

GROUP BY...

As Kevin suggested you would need to build Dynamic SQL and execute it

Something like this should give you an Idea

DECLARE @Year TABLE

(

CalYear INT

)

INSERT INTO @Year

VALUES (2014),(2015),(2016)

DECLARE @sql VARCHAR(4000)...

Or not enough coffee 😀

Something like this should work as well, its not as neat as the LAG function but

WITH CTE_RN

AS

(

SELECT

fmc_terminal

, fmc_prodlnk

, fmc_cost

, fmc_date

, ROW_NUMBER() OVER(PARTITION BY fmc_terminal

, fmc_prodlnk

ORDER...

Its not surprising if you are rebuilding the clustered index as well which will effectively rebuild the entire table via the TempDB, I'll take a stab in the dark and...

I had a requirement a few years ago to do something similar where the flattened hierarchy where each level was a column, This is the thread http://www.sqlservercentral.com/Forums/Topic1071035-392-1.aspx the end solution...

Over and above...