Yes.  Contrary to popular belief, you CAN call a stored procedure  in a SELECT query using things like...

thank you for the data. Theoretically, it's slower; based on my software development experience, web application does not fetch 1,000,000 or even 10,000 rows to the front end. I...

I wonder why people think that everything that uses SQL uses the same SQL.

Interesting... what constitutes a lower cost provider?  In other words, why would they possibly be a lower cost on one route but not another?  I might see a difference depending...

I have to admit that this is a very interesting exercise but I'm not seeing anything especially practical here, especially if thousands of integers were needed in a collection.

Considering the...

I think it's freakin' hilarious when I see Microsoft Engineers write code like the following...

SELECT  getdate() 'runtime', ...

It doesn't hurt anything but wow...

In the same vein as Jonathan, I like to test these type of things out.  I do like to take an average of 5 runs.  This is on my new...

I know this post is serveral years old now but wanted to say nice post on the following... definitely the right idea.

Igor,

I really think you're overcomplicating it. From my...

Thank you for the feedback... much...

BWAAAA-HAAAA-HAAAAA!!!! THIS coming from the person that says he likes the MySQL "standard" of using YYYY-00-00...

It is an alleged non-problem any more.  I say "alleged" because I trust no one on such things (too many times burnt in the past).  There is a simple test...

I'll be using this data to add entries to our data warehouse tables.  After using this data to fill in our data warehouse tables most of the time it...

Thanks for your response. The purpose of the word document import into SQL server is to parse the data into a table and export into excel. The current framework...

I got hired and then I wrote the job description. 😉

To add to both what I and Jonathan suggested that will help a whole lot, both for the reader and the self-edification of the author, always remember this simple rule...