Please post the actual execution plan for this query.

See the link "Performance Problems" in my signature for how to do this.

Does this work for you?

I'm not sure that I follow what it is you are attempting. Why not just insert all the data in one set?

;WITH CTE AS

(

Select ...

And you shouldn't be going around shrinking the tlog either. It grew for a reason, and unless you eliminate that reason, it will just continue to re-grow. By doing regular...

Replace the entire CTE and UPDATE statement with:

UPDATE b

SET b.Cost = (SELECT TOP 1 Charge

...

Good question Jason!

wrt the log file... I think the give-away here was the wording it "will be a lot smaller".

This implies that it is 100% certain to be so - and in...

Lowell (6/8/2010)

---

Wayne it's been a while, but i had a similar issue;for me, it was my laptop, which traveled between different networks a lot. i thought it was related...

Leo.Miller (6/8/2010)

---

From the timeout error it looks like the problem is load on the database server. It may be worth running some Performance counters. like CPU usage to see if...

What happens if you try this?

DECLARE @command varchar(1000)

SELECT @command = 'IF ''[?]'' NOT IN (''[master]'', ''[model]'', ''[msdb]'', ''[tempdb]'')

SELECT name as...

Steve,

I realize that you're pretty new to this web site. Please realize that we are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

The error message that I get is:

TITLE: Microsoft SQL Server Management Studio

------------------------------

Error connecting to '<my server>'.

------------------------------

ADDITIONAL INFORMATION:

Timeout expired. The timeout period elapsed prior to completion of the operation or...

Please read the best article ever written for running totals on SQL Server[/url] by MVP Jeff Moden.

If you still need assistance, please read the first link in my signature for...

For rows where Field9 contains "User Account Created", there are no "Target Domain" or "Target Account ID" "columns" - they are "New Domain" and "New Account ID". Change those strings...

cute. 😀

Dept is probably a string, and thus needs to be enclosed in quotes.

SQLstr = "Select Distinct TM from PCTTS_TIME_Results where Dept = '" + Me.DropDownListDept.SelectedValue.ToString + "' order by TM"

...