Viewing 15 posts - 51,076 through 51,090 (of 59,078 total)
SELECT RateID, CONVERT(CHAR(8),CAST(SUM(CAST(EndTime - StartTime AS FLOAT)) AS DATETIME),108) AS TotalHours
FROM ConsultancyDetails
GROUP BY RateIDYou can't sum the difference between two date times... but...
April 16, 2008 at 2:13 am
Hey Highway! Don't give up, yet... turn this into a learning experience because Sergiy is correct... no matter where you go, you're going to run into steaming piles of...
April 16, 2008 at 1:22 am
Whoa... wait a minute... back the performance pony up! Let's review the facts...
1. escaleraroyal already stated that the vendor tested it in QA and it was slow...
2....
April 15, 2008 at 6:05 pm
Corey,
This looks a bit like homework, and we don't mind helping with that because you tried on question 1.
We need just a bit more information...
In the first...
April 15, 2008 at 5:52 pm
Your co-worker is, well... wrong! Even if you had the best indexing in the world on all the tables, updating 18 million rows with new data for the new...
April 15, 2008 at 5:09 pm
If you do this with a trigger, the INSERT trigger table will have all the rows that changed in it... automatically...
... then , the trigger could insert into the...
April 15, 2008 at 5:01 pm
Sean... take a look at Books Online... most of the examples given are just flat wrong... for example...
[font="Courier New"]SELECT @COL = CASE @Section
...
April 15, 2008 at 4:58 pm
samiam914 (4/15/2008)
April 15, 2008 at 4:45 pm
terrence_daniels (4/15/2008)
thanks I am looking into Books online...but my question is why is the script looping through the tables? 😉
If you're looking at the execution plan and seeing the loop,...
April 15, 2008 at 4:40 pm
Can the data generator code you provided be used to generate that many rows? I'd like to "play" some more because 41 to 45 seconds to produce "36820...
April 15, 2008 at 9:53 am
You're on the right track... you may have to add extra criteria in the WHERE clause to narrow down the correct matches.
Looks like you're using a native tool to write...
April 15, 2008 at 9:44 am
thelabwiz (4/15/2008)
April 15, 2008 at 7:09 am
Heh... nice try... obviously, you didn't try the code you sent me... there are over 12 errors, the columns in Table2 are out of order with the data, and there...
April 15, 2008 at 7:04 am
If it's a "human" client, then there's no way they need 92,000 rows... that's a lot of pages to read. Normal typewritten pages only has 60 rows by 80...
April 15, 2008 at 6:19 am
... perfect... thanks for the feedback.
April 15, 2008 at 6:12 am
Viewing 15 posts - 51,076 through 51,090 (of 59,078 total)