The desert stretches out in the distance and a lone figure can be seen running deeper into the desert. It appears that this person is screaming wildly while pulling...

No, the data you provided doesn't really help. I have no idea if you need to use an outer join or inner join as this is your data and...

airborn (1/21/2009)

---

Lynn,

Sample data looks like the following. I think thats what makes it more complicated. It's all numeric. As for the join - I thought I was joining it by...

When you say the last 2 months, do you mean the previous 2 months (i.e. in January 2009, you are talking about November and December 2008) or the previous month...

You also realize that your select statement in your function is returning a cartesian product as well, right? You have no join criteria between the two tables dbo.grapes and...

Your function selects data from a table. How do I help you when I don't know anything about that underlying table or have any sample data to put into...

You have only provided part of the information we really need to help you with your problem. Please read the first article below in my signature block regarding asking...

Unfortunately, we have been giving you SQL Server 2005 answers because you posted your question in a SQL Server 2005 forum.

I don't think you will be able to figure out...

Garadin (1/20/2009)

---

Try running this query.

SELECT I.item_no,I.std_cost,I.loc, C.HBG_std_cost

FROM HBG.dbo.IMINVLOC_SQL I

LEFT JOIN FT.dbo.Std_Cost_Compare C ON I.item_no = C.item_no AND I.loc = C.HBG_loc

A bit easier to read than yours. You're getting...

OR, create a table, mytable_new. Copy over just the records you wish to KEEP. Rename the current table (mytable) to mytable_old, then rename mytable_new to mytable.

Saves you moving...

Jeff Moden (1/20/2009)

---

As a sidebar, there isn't really an advantage to having such an indexed view. The underlying indexes on the table are the only advantage. Indexed views...

Joe Celko (1/20/2009)

---

Bad example. Ever read about what New York City was like before automobiles? How many TONS of house shit were carted off the streets every day...

Garadin (1/20/2009)

---

Lynn Pettis (1/20/2009)

---

I thought about this, but the OP's post didn't indicate that the PK (int column) was defined as an identity column. With out that...

I thought about this, but the OP's post didn't indicate that the PK (int column) was defined as an identity column. With out that info, how would...

I have to correct myself. there is another way, using the following function: COLUMNPROPERTY ( id , column , property ).

Check it out in BOL (Books Online).