April 6, 2010 at 6:30 pm
Thanks Paul for this suggested workaround.
I had been fiddling with that for a bit, and wasn't getting it right. I was overlooking a key part of my query being that I had a join on but it was for blocking and thus that view wasn't returning what I wanted. Then I saw your suggestion and re-examined my code. Added another join and now it works.
Now I can resume my regularly scheduled programming.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2010 at 6:33 pm
Trey Staker (4/6/2010)
Alvin Ramard (4/6/2010)
CirquedeSQLeil (4/6/2010)
Alvin Ramard (4/6/2010)
I just ran into a very smart OP. (No, I wasn't driving)I asked him if his assignment was due today and he replied with Yes. Then he PMs me for the code. Like I said, very smart OP.
http://www.sqlservercentral.com/Forums/Topic897834-147-1.aspx
Edit: I hope he responds to my last comment.
I bet somebody somewhere will answer it for him.
I was just looking for a way to make him admit that he's looking for someone to do his homework for him.
Sounds like someone is going to fail.
You should of responded to him in the PM that you'd be happy to do it as you do any contract job at $150/hr with a minimum of 300 hours of work of which you'd need 1/2 the money paid up front to start.
and that would have accomplished what exactly?
That would have been a total waste of my time.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 6, 2010 at 6:36 pm
jcrawf02 (4/6/2010)
speaking of lying, cheating, sob's doing schoolwork, why would you bother to copy my answers to review questions in the first week of a 200 level programming course? And then not even copy/paste some of the answers in their entirety? frustrating. I, being my verbose self, threw in a couple throw-away sentences explaining the answer I chose, and the ignoramus reworded them and included them in their own answers, making some of them sound even dumber than I did.unreal. email winging its way to the prof as we speak.
I don't think I would be too kind in the email either.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2010 at 7:17 pm
CirquedeSQLeil (4/6/2010)
jcrawf02 (4/6/2010)
speaking of lying, cheating, sob's doing schoolwork, why would you bother to copy my answers to review questions in the first week of a 200 level programming course? And then not even copy/paste some of the answers in their entirety? frustrating. I, being my verbose self, threw in a couple throw-away sentences explaining the answer I chose, and the ignoramus reworded them and included them in their own answers, making some of them sound even dumber than I did.unreal. email winging its way to the prof as we speak.
I don't think I would be too kind in the email either.
No worries, I'm not kind by nature, I just play one on tv. 😉
(no, it's a sheep)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 6, 2010 at 7:36 pm
CirquedeSQLeil (4/6/2010)
My next response will be to use 5.25 floppies. Maybe sneakernet will work.
Or 8" floppies for that good old nineteen seventies vibe.
April 6, 2010 at 7:53 pm
john.arnott (4/6/2010)
Or 8" floppies for that good old nineteen seventies vibe.
You know, the first time I played with a computer was in 1966 (it was the Ferranti-Packard Orion II at RHEL) and by the middle of 1970 I had written (amongst rather a lot of other things) software to test varios sorts of disc hardware (including those enormous dual 30MB 10-platter cartridge drives, with which a rapid head-throw test produced physically spectacular results if they were standing on a suspended floor); and I carried on working with machines that all sorts of weird disc and drum drives ever since; but I've never come across an 8 inch floppy. Which machines had those? Were they something released only in the USA?
Tom
April 6, 2010 at 8:04 pm
Tom.Thomson (4/6/2010)
john.arnott (4/6/2010)
Or 8" floppies for that good old nineteen seventies vibe.
You know, the first time I played with a computer was in 1966 (it was the Ferranti-Packard Orion II at RHEL) and by the middle of 1970 I had written (amongst rather a lot of other things) software to test varios sorts of disc hardware (including those enormous dual 30MB 10-platter cartridge drives, with which a rapid head-throw test produced physically spectacular results if they were standing on a suspended floor); and I carried on working with machines that all sorts of weird disc and drum drives ever since; but I've never come across an 8 inch floppy. Which machines had those? Were they something released only in the USA?
I worked on an IBM System 38 that had one of those 8" floppy drives. Not sure of any other systems that had one though. I still remember cleaning 9-track tapes. Put the tape on the machine and let it run through the cleaning cycle and cut/splice around the areas that naturally got bent over time. Lots of fun...;)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 6, 2010 at 8:26 pm
CirquedeSQLeil (4/6/2010)
Thanks Paul for this suggested workaround.
Hey, thanks for mentioning it! 12th March I posted that - seems much longer ago for some reason...?!
April 6, 2010 at 8:34 pm
john.arnott (4/6/2010)
CirquedeSQLeil (4/6/2010)
My next response will be to use 5.25 floppies. Maybe sneakernet will work.Or 8" floppies for that good old nineteen seventies vibe.
Break out the lava lamp
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2010 at 8:37 pm
Paul White NZ (4/6/2010)
CirquedeSQLeil (4/6/2010)
Thanks Paul for this suggested workaround.Hey, thanks for mentioning it! 12th March I posted that - seems much longer ago for some reason...?!
That's not too long ago. I was thinking it was much older.
Now I just need to get the rest of the query fine tuned and then I will post it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2010 at 9:39 pm
Tom.Thompson
You know, the first time I played with a computer
Take me back to the good old days ... first computer was the IBM 709, (used vacuum tubes) later released for general rental as the 7090 ... no hard drives .. used 7 reel to reel tape drives. Talk about set based / cursors .. try reading data from tape ... spin forward ... read ... spin back ... spin forward, but not as far as 1st spin .. than back .. oh it was fun ... then onto a IBM 1401 with a Ramac disc drive .... 6 foot tall ... disk diameter about 3 foot ... 6 discs in the unit ... heads (1 set for entire unit) mounted on what was the steering gear shaft from a car .. shaft would rotate to raise the head to the desired disk ... key to programming that baby was to keep all the data you could on a single disc. Maximum machine memory 16K try writing code to fit ... had to use what was termed segmented programs ... oh joy to the world.
Oh and least I forget ... 70 column punched cards ... card reader .... yea the days of programming fun .... then the IBM 1401 ... only advantage to those days was the company hired the cutest females for the card punching jobs.
Programming using either - Autocoder or Fortran I .... and occasionaly what IBM termed machine language.
But still an improvement over using punched cards and a machine called a tabulator ... program that with jumper wires on a board like a telephone switch board ... yea ..
Enough .... be thankful with what we have to use now
IBM 709
April 6, 2010 at 9:50 pm
I really thought the thread would surpass 14k today.
23 to go.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2010 at 9:54 pm
CirquedeSQLeil (4/6/2010)
I really thought the thread would surpass 14k today.
Probably will - though the definition of 'today' varies...;-)
Eight hours of 7th April 2010 remain (local time).
April 6, 2010 at 9:56 pm
Paul White NZ (4/6/2010)
CirquedeSQLeil (4/6/2010)
I really thought the thread would surpass 14k today.Probably will - though the definition of 'today' varies...;-)
Eight hours of 7th April 2010 remain (local time).
Down to 3 hrs of April 6 remaining here.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2010 at 10:03 pm
CirquedeSQLeil (4/6/2010)
Paul White NZ (4/6/2010)
CirquedeSQLeil (4/6/2010)
I really thought the thread would surpass 14k today.Probably will - though the definition of 'today' varies...;-)
Eight hours of 7th April 2010 remain (local time).
Down to 3 hrs of April 6 remaining here.
Hey Jason - on the west coast here also. 3 hours to midnight...:-P
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 15 posts - 13,966 through 13,980 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply