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.

GilaMonster (1/6/2009)

---

Greg Edwards (1/6/2009)

---

At some point, I have to ask the dumb question to Gail :w00t: - the more sides, the more precise the answer? or the more likely...

Greg Edwards (1/6/2009)

---

Grant Fritchey (1/6/2009)

---

GilaMonster (1/6/2009)

---

Maybe for you. 😉 I play D&D. The 20-sided dice is the most important one.

I have...

GilaMonster (1/6/2009)

---

Which edition was that? I...