Found a space between tablename and the . in the following case statement:

WHEN (SUM (CASE WHEN [p21_view_inv_loc] .stockable = 'N' THEN [p21_inventory_usage_all_view].actual_usage ELSE 0 END)) THEN 'Non-Stockable'

Check out the code...

Do not shrink tempdb, you risk corrupting the database and requiring a start of SQL Server to correct.

Haven't had to do it, but it should be a matter of just adding the witness.

forsqlserver (7/9/2012)

---

I have the transactional replication running on my database,and to release some space i need to delete the 10000000 rows on 3 tables.The data can't be partitioned.

I need to...

Looks like the execution plan is the estimated plan. What is needed is the actual execution plan when the query is...

First of all, are you talking about the maintenance plans you build using SSMS using SSIS? I don't. I use custom scripts that berform the necessary index maintenance...

In a syncronous mirror environment with NO witness, if the mirror goes down or network connectivity between the two databases is lost, as Gail said, the log file continues to...

Jeff Moden (7/6/2012)

---

sivag (7/6/2012)

---

i used this way

Create table #temptable2 (firstlevel varchar(200),ThirdLevel varchar(8000) ) ;

insert into #temptable2 (firstlevel,ThirdLevel ) VALUES ('count1','serv,dan,ton');

insert into #temptable2 (firstlevel,ThirdLevel ) VALUES ('count2','wers,tdan,tondrer,fhhgj,tern') ;

WITH Cte AS...

There is one advantage of my date calc routine, if the fiscal year ends at the end of February...

I found a copy/paste error with my code. Fixed it above, but it didn't really change much.

dan-572483 (7/6/2012)

---

In Estimated Execution Plan I'm showing 0 cost for both methods, and Client Statistics shows both methods with virtually the same Client Execution Time.

How do you determine which is...

dan-572483 (7/6/2012)

---

Not sure if this is what you need or not but this prodedure assumes that your fiscal year begins on October 1 and will provide the last date of...

I just reran my code, and I am really confused. Based on your sample data, my code returns exactly what you asked for in your original post:

firstlevel ...

Sean Lange (7/6/2012)

---

Lynn Pettis (7/6/2012)

---

I'll have to defer on modifying this to work on SQL Server 2000 to someone who still works with SQL Server 2000. I haven't touched...

I'll have to defer on modifying this to work on SQL Server 2000 to someone who still works with SQL Server 2000. I haven't touched a SQL Server 2000...