So you are saying that the update will only happen after all the joins are complete and not before?

Hi, thanks for replying. The mismatched parenthesis is just a copy paste error. I copied and pasted the first query then tried to modify but forgot to remove the parenthesis.

Hi, thank you so much for your reply. I'm still not a hundred percent clear on the differences between the OR and the AND operators.

What if I want to...

I already soved this problems. It turned out, I had to restart SSMS and it now works.

I have unpivot the table and although the result is getting close to what I need, it is still not what I want.

Below is the query I've used, please pointout...

Hi, Thanks for replying. Here are the create and insert statements

CREATE TABLE [dbo].[Sales](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Product] [nvarchar](25) NOT NULL,

[Quarter One Earnings] int NULL,

[Quarter Two Earnings] int NULL,

[Quarter Three Earnings]...

Hi, thanks for replying. The columns I've shown in this post are all of the columns of my current table. I might add more columns to my table in the...

Hi, thanks for replying. I made sure there will be no ties using javascript on the frontend.

Hi, the following are table schema and my sample data

dbo.VacationDestination(ID int not null identity(1,1) primary key, HotelName nvarchar(250),

...

Hi,

Thanks for replying. Suppose the user provides the following data in the web app and clicks the Submit button

@Price = 1350.00

@customerRating = 5

@priceWeight = 1

@ratingWeight = 5

Since the value...