Could a second parameter be added to ISNUMERIC to determine a specific numeric type?

I'd love a wildcard REPLACE as well.

SQLRNNR (7/9/2014)

Koen Verbeeck (7/9/2014)

Imo there is not necessarily something wrong with the group by.

The coalesce on the other hand is for...

That's one select statement 🙂

Do you mean something like this?

SELECT 'ClassSize' = CASE

WHEN COUNT(studentid) < 10

...

Hardy21 (7/9/2014)

+1

Please share if you have already done something.

There are options like CTE, Self -...

What where they thinking? They need to use ISNULL to preserve the data type from the column. :hehe:

I'm Batman shhh.... No, really, I'm a billionaire and philanthropist called Bruce Wayne. 😀

I just found that helping in here keeps me learning and practicing to become better each day....

It seems that you need joins or semi-joins (EXISTS).

I can't see the complexity and you didn't even provide sample data and expected results. You've been here for some time and...

Are we supposed to do your work? Or do you have something done already?

I assume that you didn't read the article proposed by Craig. Read it and find out a way to improve the performance.

I came up with 2 solutions, but I changed the pivot to a cross tabs approach. I prefer cross tabs because they give more flexibility and with more than one...

How does the different name for Server, instance or database affect you? Do you make reference to them in your code/object definitions?

And what do you need?

This seems to give the same results as your query. The problem is that you need a single row number, instead of having to calculate a different row number for...

The reason might be the DISTINCT which has to sort all the values to eliminate duplicates. Another reason might be the OR you have in there which might be causing...

I might be wrong, but this is a shot in the dark. Aggregate functions (including MAX) exclude null values. If you're using MAX() and replacing it with '1900-01-01' the most...