Thanks for the help... Is there anything i should do when post is complete???

one column per date.

Data will be displayed in reporting service. Havent found a way to do it in there yet.

I have seen pivot query examples that do something similiar,...

Yes, so if say date 1/3 had the most amount of records, say 3,, the most amount of rows i would have is 3.

How do i do that??

When i do that it still creates a row for each part, as apposed to only as many rows as exist for that date. i am just trying to get...

I see that the information didnt come over formated well, sorry,,

my question seems simple, i want to display information from select date,partname from table1. I want my columns to...

This is what i am trying to accomplish, i dont think it will work,, but i think the theory of what i am accomplish is here..

this is what i...

ya know what, i figured it out,, i was meaning a update not an insert,, my bad,, thanks though 🙂

I will still need to set up linked servers to be able to let db1 access db2 and db3 thought correct?

Do you know of a good article to read on views?

i have 3 databases. db1 is my primary application. db2 and db3 are 3rd party applications that certain users enter in detailed information about products. These 3 applications are currently...

thanks so much 🙂 . I think this will work perfectly 🙂