Jeff Moden (4/26/2012)

Nope... just quote the thread by hitting the quote...

Eugene,

Didn't I see you post a CrystalBall CLR last month?

I gotta locate it because I planned to run a performance test against my new MagicMirror SP using Jeff Moden's million...

No need to reiterate what you've already posted. Most members are capable enough to scroll up and see it.

What I was asking you to confirm is whether the last...

I've always figured it's because blue-collar folk relate better to HH:MM...

This version will probably perform a little better but it doesn't offer quite as fine a degree of control over specifically which description appears.

;WITH a AS (

SELECT Proj, Item, [Desc]

,ROW_NUMBER()...

This solution will sum the Qty by Proj, Item and include the first non-NULL description in the results.

DECLARE @t TABLE

(Proj VARCHAR(3), Item VARCHAR(3), [Desc] VARCHAR(20), Qty INT)

INSERT INTO @t

SELECT '001','AAA','Desc1',22

UNION...

You gotta love the recursive CTE version of this solution, even though it doesn't perform as well as the tally table version.

CREATE TABLE #t (strings VARCHAR(100));

-- Count the unique characters

;WITH...

I was looking at a stock table with the columns Part Number and Part Description. I just found out that we have over 95 tables that contain these two columns,...

jwmott - It is rather annoying but I haven't figured out an easy way to do that either.

You mean I gotta remember who and when?

I'm lucky sometimes if I can remember the day of the week.

Maybe someone at the water cooler can help me with something perplexing. Steve posted the following earlier:

My question...

idyana,

As I promised, I am willing to take another shot at this but before I do, what I'm going to need from you is an exact expected results set based...

Nick - Sorry I just realized you provided the information on your accounting calendar in the prior point. However what I need is DDL and some readily consumable data...

OK then. I'll need information on your Accounting Calendar table to do this right.

For the third question, where you say MTD is BETWEEN start date AND end date. ...

This fiscal year start thing is going to make your life interesting. I've got in mind a way to do what you want, but it depends on some assumptions...