Yep, i probably should have...

Think it would be advantageous if we could preview our...

Just wondering here, what was your reasoning for using a WHILE loop here? Personally I would see that you would get better performance by using a Tally Table and/or Calendar...

You need to change the data type too (to varchar), as the date datatype doesn't have a format attached to it; it's stored...

You probably have to hold the Fn button down while you press another key, what I have to...

Could be a lot of reasons. How much slower is it on the report server? How complex is the display of the report (lots of objects, formatting?)? Are you simply...

You do have to wonder if someone is maybe a little out of their depth trying to use SQL Server, when they post photos (not screenshots) of computer's screen. One...

/Facepalm

Please; screenshots, not photos. ??

Got to love a photograph of a screen. As an FYI there is a Screenshot button on your keyboard, it's normally located on the right hand side, above the Insert...

Then change it to a DISTINCT count and return the value of W.id instead of 1:

SELECT C.prefix,
       COUNT(DISTINCT CASE WHEN CONVERT(char(6),...

Yeah, it's time. We've debated about the thread name taking you there, but that's not what many people want. Plenty see something and want to read through the thread....

This may be an unpopular opinion, but I feel that this is more of a user training issue than a forum software issue. If the end user uses the...

Just in case Price could have the value NULL , you may need to do therefore do:

SELECT * --You should probably list the columns you actually need...

You can't database permissions at server level, no. sysadmin is the only real "exception" to that rule, but they still end up effectively being mapped the to db owner.

Do these...

Unfortunately SSC, and the use of tabs, has made your expected results an unreable mess. Guessing you need a conditional aggregation?