So much code for a simple pivot.

--Create sample data
CREATE TABLE #Table 
(
City VARCHAR(50)
)

INSERT INTO #Table (City) 
VALUES ('A'), ('B'), ('C'), ('D'), ('E'), ('F'), ('G'), ('H');


--Solution starts here....

Here's an article addressing your problem when using AddWithValue.

https://blogs.msmvps.com/jcoehoorn/blog/2014/05/12/can-we-stop-using-addwithvalue-already/

Now I see the problem and the reason behind the image that I can see now.

Here's the image of the example.

Is there something special I need to do to be able to save some Hebrew text in my table?    I have the column set as nvarchar(max) yet when i...

As mentioned by Drew, NULLIF can work, but I'd suggest to go further and use TRY_CONVERT this will return NULL on all invalid dates instead of generating errors. If servicedatekey...

@luis Cazares thanks! There was a third table 'Billing' though. I have tried to follow the same logic to include that in your code, but it is displaying more...

You're throwing 500 rows of code into a forum without understanding where's the problem and expect people to solve it without giving sample data, execution plans or data definitions? You...

Hello keneangbu,

My first piece of advice would be remove the cursor.  Cursors are inherently slow.  In your sample piece of code, I do not see a nice way to...

For starters, you can optimize your query by reducing the number of calls to your Visits table. It could be done like this:

SELECT DISTINCT userr_id 
FROM Approvals...

Slow and steady-ish, I'm getting to the top of my division, and hoping to stay there at least one more week considering John's record.

Isn’t it a kinda shame to have such queries exposed on a specialised site of SQL Server professionals?

Could we form a group of volunteers who could fix...

Realise that the site is disliked by many (I agree that the community isn't as robust as it is here, or as well knit with many of you having ...

Last week was dominated by the Mexicans in the league. I hope that it continues like that.

Don't worry, at least the steelers have a chance to win this week.

Oh for crying out loud!!!  None of my RBs or WRs even bothered showing up yesterday!!!  (And the one who did was on my bench!)  @#$%^&*!!!!!!!!!!!!

So it's going to...

For your question about not the comment on not helping with performance, it's because EXISTS doesn't evaluate the columns from the subquery. An interesting way to test this is by...