You're welcome. Have a good weekend.

A "copy" of the table can only exist in a database or a database backup. You can write the data from the table out to a delimited file,...

(Error converting data type nvarchar to numeric.)

UPDATE @tblReportDetail

SET Measure =

CASE

WHEN @MeasureSpecial =...

Not a problem at all, Rob. I have some code that uses a tally table to populate sample tables. It will run a lot quicker...

They are certainly powerful and have a lot of applications.

In this instance, using the GROUP BY/MAX is a lot more efficient on the cpu. From a look...

That's an interesting approach, Rob. Mind if I borrow it to run a time trial?

Thoughts, since you have some logic laid out already.

First, I see you know how to use tally tables, so use them ... over and over again... get rid of all...

Yes, we understood that the first time. He told you how to do it. I am posting this code only because I suspect English...

I tried to take the high road for a change. However, I am ready to buy a round for Sergiy 🙂

Hey Lynn: Ask him if he likes...

Ok here is what I would like to do:

run a query or view that gets a datatable (in t-sql) not c#

Then run through each record in the datatable that I...

There are a lot of flavors of these kinds of tables, and I've seen much debate about them. If you are limited to problems involving workdays then...

I just thought it was a Zen thing... one hand clapping and all that.

Way to say, Steve!! (thunderous applause ensues)

Congratulations, Gail 🙂 And congratulations also for being Geek of the Week.

http://www.simple-talk.com/opinion/geek-of-the-week/gail-shaw-geek-of-the-week/