ZZartin: Okay, I like that. Very Interesting.

Drew: I agree but the data I'm actually working with can contain NULL values. I didn't create this schema but it's what I'm working with.

Actually, that's not going to work because if the TotalSalesAmt contains a NULL it's not going to be counted; and I need it to be counted. In the DENSE_RANK it'll...

Luis: That's a viable option. Do you see any harm in doing it the way that I have it? or do you think using Count DISTINCT is better for readability?

Thanks for the post. Yeah, I noticed that I was using UNION instead of UNION ALL as well.

Great article; however, I can't really think of need to use Synonyms for my line of business at this moment. However, I do have 1 question. Is there a way...

Thanks a bunch. I greatly appreciate the advice. By the way, you did a great presentation at this past SQL Saturday in Raleigh. Good stuff. Take care.

Mr. Solomon, I really enjoyed your article in regards to External and Unsafe security framework for SQLCLR. I've really been interested in utilizing the power that this piece of technology...

Thank you Mr. Watson for your query. That's what I needed.

Thanks for the solution. However, I was wondering is there a way that I can get the data to where the SOURCE shows up as a column and have their...

Thanks for the reply. But what if the dll is a .net dll? You know in .net one assembly can have reference to another .net assembly; can the same functionality...

Is it possible in SQL2012 to reference other dll's within the SQLCLR assembly?

Thanks

Thanks Greg, greatly appreciate it.

Thanks, dwainc your post really helped.

Thanks everyone for their help. That last solution really helped out a lot. I'm gratefully appreciated.

🙂