Have you looked them up on the Books Online? If so, what did...

To really get an answer, post what Gail says.

For another guess... You're moving so much data that SQL Server is just ignoring the indexes.

BTW, looking at the execution plan, to...

Probably, in this line of code:

addcount = m + 1

"m" is being treated as a string, not as an integer. That would explain how you would get "11" when you...

You are going to have to be able to identify the partitioning mechanism, the column or columns that identify where the data is stored. While your post says it doesn't...

Oopsie. Thanks Noel!

I'm sure you can use a stored procedure. Just pass the parameters to one.

dave (1/6/2009)

---

Thanks for the response!

I gave it a shot but unfortunately that didn't seem to work. The application and tracking tables are 1-to-1, so selecting the top renewal date for...

Something along these lines will work just fine. You may need to adjust your indexes to get optimal performance.

SELECT a.application_id,

d.brandname,

...

Show what kind of SQL you've tried that hasn't worked. Lots of us will be glad to help, but we're not doing your homework for you.

RBarryYoung (1/6/2009)

---

GilaMonster (1/6/2009)

---

Which edition was that?...

You can't set variables within a statement like that. You could set the variable prior to the insert statement or, just do this:

INSERT INTO tblProject

...

Based on what I heard, this?

UPDATE TABLE

SET str_val = x.str_val

FROM TABLE x

WHERE x.prop_id = 131

and TABLE.prop_id = 130

I mean building queries as strings and running them. I'd suggest using sp_executesql, but it amounts to the same thing as exec. Although, you can get some parameterization, and therefore...

Itzik Ben-Gan's books, Inside SQL Server 2005 T-SQL Querying and T-SQL Programming. Also the performance tuning one by Kalen Delaney. Joseph Sack's books are fantastic too.

Sure, you can have two fields on the clustered index. I'm assuming the cluster is not the primary key, but you can have two fields on the key too.