Why not just use LEFT JOIN?

I agree that Service Broker would allow you to call procs asynchronously from within a proc. However, personally, if I would have the same needs, I would do it from...

google CAST or CONVERT

use CAST or CONVERT function

SUM(CASE WHEN Status = 'RG' THEN 1 ELSE 0 END) AS CountRGStatus

SUM(CASE WHEN Status = 'GS' THEN 1 ELSE 0 END) AS CountGSStatus

Check it here:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

As I don't have a crystal ball or magic mirror, I cannot see what you are doing without you posting complete query and tables DDL. It doesn't matter how good...

kotharibij (4/26/2012)

---

Thank you Eugene.

Both my SQL and yours (very interesting SQL), gives the same result.

Day RegTotal

116

4121

532

636

737

836

933

1046

1145

I thought of a calendar table but...

Which input parameter you want to use to define the order? Which column should it apply to?

You can do something like:

ORDER BY (CASE WHEN SomeColumn = @HigherPriorityValue THEN 1...

Without knowing what your tables are and what your full query is, the maximum what I can come up with:

SELECT t.ApprovalID

,u.UserName ...

Then tell your customer he cannot have the "google-style" search as their IT prohibits it.

select replace(left(val, charindex('^',val)),'^','') as LeftPart

,replace(substring(val, charindex('^',val), len(val)),'^','') as RightPart

from...

The closest to "google-style" search in SQL is...

The best option is to create and use CalendarTable, but you can do it by:

select convert(integer,DATENAME(day,m.MonthDay)) as Day, count(*) as RegTotal

from (SELECT DATEADD(DAY,ROW_NUMBER() OVER (ORDER BY (SELECT NULL))-1,'20120401') as MonthDay

...

The key in using CURSORS (or loops, which are no much difference to cursors), as in...