I don't remember all of the syntax off the top of my head and I haven't used this in several years. I will do my best but google will likely...

a_ud (3/13/2013)

---

Help needed here!

I'm got a system made out of: Access front-end + SQL Server back-end (typical).

I need to call from Access VBA a function in SQL Server, but I...

Here is your query after running it through a formatter.

SELECT *

FROM (

SELECT users.last_name + ',' + users.first_name AS [User ID]

,workflow_regions.NAME AS Region

,queues.NAME AS [Queue]

,work_item_statuses.NAME AS [Status]

,CASE

WHEN convert(VARCHAR, work_items.creation_date, 110)...

You will have to suffer with performance issues because of the inability to properly use execution plans with this type of thing unless you can use the dynamic sql approach...

RVO (3/13/2013)

---

Thanks all for your response.

Gail's blog recommends using dynamic SQL

but our boss doesn't like it at all.

I have to learn how to handle it either with CASE

or IF. My...

What have you tried so far?

It is a little hard to figure out what you are trying to do here but can you just a new column to your 2 queries? One would be 'YTD...

You need an aggregate function, specifically SUM in this case.

http://msdn.microsoft.com/en-us/library/ms187810.aspx

:w00t: A set based query will out perform a loop any day. We spend a lot of...

I can't for the life me remember the details but there is an issue...

This is a type of catch-all query. Gail's blog has a great way of handling this type of thing.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

Lynn Pettis (3/12/2013)

---

Sean Lange (3/12/2013)

---

You have enough points that I can assume you are not around here. Please post ddl, sample data and desired output. I suspect you want a...

You have enough points that I can assume you are not around here. Please post ddl, sample data and desired output. I suspect you want a cross tab. You can...

You REALLY need to not use the sa account for people or applications. Create logins for your different people and applications so...

A little late to the party but just wanted to share my 2¢. You should leave the formatting to the front end. Have your queries return a datetime datatype and...