Thanks Sean, that worked!

Looks like you can replace the update above with this

UPDATE p SET Price = m.Price

FROM PriceTest p

INNER JOIN MainMaster m ON p.ID = m.ID AND p.User = m.User

WHERE m.User...

This is the create table queries: CREATE TABLE [dbo].[MainMaster](

[User] [int] NOT NULL,

[ID] [int] NOT NULL,

[Price] [money] NULL,

PRIMARY KEY CLUSTERED

(

[User] ASC,

[ID] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

CREATE TABLE...

Thanks for the response, but I am trying to reference dbo.MainMaster and update dbo.PriceTest with the values from dbo.MainMaster if the user is trying to insert values from the application...

my .rdlc is pointing towards version 9. The report was created in SQL Server 2005, I don't have the rdl's in the project itself.

I tried messing with it a little more, and I got it to stop throwing out an error now. Although on the server the report doesn't show anything. The output...

wrong version as in referencing v8 when it is v9 ? if that's what you mean I highly doubt it, because it wouldn't compile on my local machine then in...

Yeah that doesn't seem to help either 🙂 I am beginning to think this might be something on the SQL side. I just don't understand why it would work with...

I tried that & that didn't help either. Were you using version 8 or v9/v10. Because version 9 works properly for me on my localhost but when I deploy it...

But isn't DataVisualization for Charts?

bkubicek (10/14/2011)

---

I found in my used of VS2010 and the reporting services report viewer that I had to manually add a reference to three dlls. I mark them as...

It gave me a subquery error again, I took out "Select Total" where I have

Select Total - (select statement)

& just ran the select statement with datediff,...

Am I Replacing the IF Statement where it says

IF @RandomCol = 'YES'

or am I relacing the @RandomCol Varaible's SET select statement?

because I tried replacing it with the...

Sample Data:

MS SQL

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

UserID | StartDate | EndDate | RandomColumn |

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

12101 2011-06-16 ...

I solved this by just adding variables & then putting IF ELSE conditions to perform the tasks. So it was something along the lines of:

DECLARE

@user-id int,

@RandomCol...