Joe Celko (6/23/2010)

---

I think you want to use ROLLUP and not GROUPING SET.

You mgiht also want to start using ISO-11179 data element names, proper daets and the "VALUES(),...

Mark, you da man!

the 2nd option is exactly what was called for. Now I need to grab some asprin from smacking my head so much.

thank you very much!

Yes, I tried that first and all it did was double up my record count and show the records.

I'm just having a major case of the dums on this 🙁

ummm.... its a tab-delimited flat file... I'm trying to figure out HOW to get it into SQL and the table in the format I want.

I had attached a source file example... its the <magic happens here> part of getting the external mess to the internal hotness that eludes me...

updated my post, I'll check that link out.

thanks 🙂

nice ressurection of one of my more favorite bookmarked discussions. 🙂

thanks all

Ok, so here I was thinking I was giving more information than I needed...

CREATE TABLE #tblCompl

(

IDINTIDENTITY(1,1)

,InvestVARCHAR(75)

,GuideFLOAT

,CPFLOAT

,ExplanationVARCHAR(20)

)

data:

insert #tblCompl

SELECT 'test-a',10,10,'' union

SELECT 'test-b',10,10,'' union

SELECT 'test-c',20,30,'' union

SELECT 'test-d',10,10,'' union

SELECT 'test-e',10,10,'' union

SELECT 'test-f',30,30,'' union

SELECT...

yeah, thanks 🙂 I replaced all the function calls in the procedure with that statement. I've never read before that scalar functions were 'bad' but I guess ya...

any thoughts on it or should I just leave well enough alone?

The function is just a piece of stock code that is used in the system to return the month end date regardless of the date passed in.

ALTER FUNCTION

[dbo].[fnsysMonthEnd]

(

@datDatedatetime

)

RETURNS...

yeah, fnmonthend just makes sure that I get the specific month end regardless of the date I pass in... so if the data happened to be 5/17/2009 it would come...