Ninja's_RGR'us (4/16/2010)

---

Thanks for the code. However it seems to be on the slower side of things. I takes about 47 secs to run with 20 while I have...

Did you expand the tally table?

; WITH

E1(N) AS ( --=== Create Ten 1's very quickly

...

I may be way off... but this seems like a simple binary problem to me.

DECLARE @People TABLE (Person VARCHAR(50))

INSERT INTO @People VALUES ('Ted')

INSERT INTO @People VALUES ('Tom')

INSERT INTO @People...

As far as a good blog / post to show why fixing the data at entry is the right way to do it, I am not sure that there is...

Just a thought, but NULL != NULL (unless ANSI_NULLS setting is OFF), therefore if the value in the column is null, this would return false.

Not 100% sure what you are after. What is the aggregation level of each item?

here are some quick thoughts, maybe I got lucky and one of these is what you...

Thanks Lynn. I have always used this method for only small data sets as I have noticed degradation, or at least a lack of improvement, when working with larger data...

I would recommend that you create both versions, and do a side by side to see.

I personal do not like to use views unless for very specific functions, such...

I don't believe that this is possible with reporting services... you can ignore parameters, but you cannot hide / enable one parameter based on another. If you have ever used...

Remove the astrik "*" from your sub query, and replace it with the field names (this is causing your problem).

Check BOL

ROW_NUMBER is a member of the RANKING FUNCTIONS available in 2005 & 2008. I am not 100% on the internals, but because SQL Server is building the rowset,...

Here is what I would recommend, instead:

SELECT *

FROM (SELECT ROW_NUMBER() OVER (PARTITION BY company ORDER BY company) r, *

FROM company) A

WHERE r = 1

If you have a flag that...

Here is a quick trick to get this... I am pretty sure it will work in SQL 7/2000:

DATEADD(yy, YEAR(GETDATE()) - 2000, '2000-02-01')

You can use this trick to get any date...

I would recommend ROW_NUMBER(). How can you determine, if a company has 50 rows, which one row you would like to see? Are they all the same for the columns...

That's probably your issue. It is literally trying to insert the character string "NULL" into the datetime field. You need to add a data conversion task to replace the string...