Viewing 15 posts - 1 through 15 (of 19 total)
ZZartin: Okay, I like that. Very Interesting.
May 13, 2016 at 2:44 pm
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.
May 13, 2016 at 2:34 pm
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...
May 13, 2016 at 2:10 pm
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?
May 13, 2016 at 2:01 pm
Thanks for the post. Yeah, I noticed that I was using UNION instead of UNION ALL as well.
December 29, 2014 at 4:43 pm
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...
September 11, 2014 at 11:20 am
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.
September 10, 2014 at 1:18 pm
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...
September 10, 2014 at 12:06 pm
Thank you Mr. Watson for your query. That's what I needed.
March 18, 2014 at 8:53 am
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...
March 13, 2014 at 10:23 am
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...
January 10, 2014 at 3:42 pm
Is it possible in SQL2012 to reference other dll's within the SQLCLR assembly?
January 10, 2014 at 6:28 am
Thanks Greg, greatly appreciate it.
August 16, 2013 at 5:40 pm
Thanks, dwainc your post really helped.
August 15, 2013 at 6:14 am
Thanks everyone for their help. That last solution really helped out a lot. I'm gratefully appreciated.
August 15, 2013 at 6:13 am