Viewing 15 posts - 3,436 through 3,450 (of 4,080 total)
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,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 9:49 pm
(Error converting data type nvarchar to numeric.)
UPDATE @tblReportDetail
SET Measure =
CASE
WHEN @MeasureSpecial =...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 9:34 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 7:51 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 6:28 pm
That's an interesting approach, Rob. Mind if I borrow it to run a time trial?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 5:57 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 5:18 pm
Yes, we understood that the first time. He told you how to do it. I am posting this code only because I suspect English...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 5:09 pm
I tried to take the high road for a change. However, I am ready to buy a round for Sergiy 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 4:46 pm
foxjazz (3/13/2009)
--------------------------------------------------------------------------------
Gee lynn are you dense. Do I have to write it in t-sql for you to get it?
I don't like cursors.
wtf
Hey Lynn: Ask him if he likes...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 4:40 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 4:28 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 3:38 pm
I just thought it was a Zen thing... one hand clapping and all that.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 3:23 pm
Way to say, Steve!! (thunderous applause ensues)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 3:17 pm
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/
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 12, 2009 at 2:32 pm
Wait... how will we know which karthikeyan you are? :w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 12, 2009 at 1:59 pm
Viewing 15 posts - 3,436 through 3,450 (of 4,080 total)