Thanks 🙂

Thanks, Lynn

So it sounds like in using BETWEEN, we are talking about the risk of inaccuracy as opposed to a performance hit, would that be correct?

Hi Jeff. I'm trying to find an article covering the best practices you're referring to with "between" and date ranges but not having much luck. Can you...

I wrote a SQL CLR function to do this but if you can stay in TSQL, you're probably better off.

There can also be a distinction between where the filtering takes place.

A query parameter is going to filter the dataset before it is returned to the report (in...

My two bits:

Lynn, I strongly suspect Joe thrives on getting reactions to his outrageous language and treatment of posters (reminds me of Rush Limbaugh). And it is doubly frustrating...

I think it is important to discover in the interview what kind of work the applicant enjoys doing. Especially if you are not in a position to supervise them...

The interesting experience I'm having is that it is graphing from StartDate to StartDate instead of StartDate to EndDate. I may have to rewrite my query to fool it...

Daniel, thank you very much. This is exactly the kind of advice I was looking. I might even be able to make my boss happy 🙂

@springtowndba

I did learn a few things from your last post and I thank you for that. I was unaware that there were specific methods C# required...

@ Sean

Thanks for your response. As an FYI, I don't require this approach at this point. To get my custom aggregate I would probably do a two-step process...

@springtowndba

READY!

FIRE!

AIM!

Yeah, I’d probably suggest that getting context might be the first step prior to criticizing this BAD DESIGN!

For starters, nothing here suggests any kind of permanent data modification....

Let’s say that I have created and tested an assembly locally on a database named HOME.

Now I want to deploy that assembly on a database called PRODUCTION on another network...

The initial deployment would be from visual studio to a local version of the database and then scripted for the upgrade process for databases across the country.

It is way cool. Do you know if the assembly itself is stored in the system table in the format in which it scripts out or is the dll...