Viewing 15 posts - 38,896 through 38,910 (of 59,072 total)
korolana (4/13/2010)
From the performance point of view I don't think that calling UDTF on every row of...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 13, 2010 at 1:59 pm
steve-lauzon (4/13/2010)
Thanks a lot guys... you've just saved me a bunch of time - just the solution I was searching for
Can't wait for the day that I'll be...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 13, 2010 at 7:34 am
P.S. I don't believe that FLOAT is the thing to use here. Could be wrong, though.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 11:01 pm
This could probably stand a tweek here and there but here's the code I came up with that I was going to post before you beat me to the punch....
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 11:00 pm
Just convert the Qty from the temp table back to weight and do a final update on the original second table. Don't forget to update the Qty on the...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 10:16 pm
Heh... I was just getting ready to post a nearly identical solution. I'm pretty proud of you guys... you beat me at my own game anymore. 😛 Well...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 9:58 pm
Yes, it helps a lot. Thanks. Just one final question... is there a column in the second table to show what has been consumed and what has not?
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 8:27 pm
Stefan_G (4/12/2010)
Jeff Moden (4/12/2010)
Stefan_G (4/12/2010)
1) Add a nonclustered index on CountryCode, IpNumber on [my].[ipAddresses]
It'll make for a fine nonclustered index. Using it as a clustered index can cause a...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 5:56 pm
I don't believe it can be done without a wee bit more information. Either the Qty column is missing from the second table or we're supposed to guess that...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 4:55 pm
GSquared (4/12/2010)
IsNumeric has a number of flaws, this is just one of them. Check out IsNumeric('1d3')...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 4:41 pm
Stefan_G (4/12/2010)
Jeff Moden (4/12/2010)
Stefan_G (4/12/2010)
1) Add a nonclustered index on CountryCode, IpNumber on [my].[ipAddresses]
Ohhhh... be careful now. Unless that index is applied after all data is present and no...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 4:09 pm
sql_avid_fan (4/12/2010)
--delete from folders_rel
where exists (select b.id
from folders_rel a with(nolock)
...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 1:06 pm
GSquared (4/12/2010)
Jeff Moden (4/12/2010)
Bill Kline-270970 (4/12/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 1:02 pm
Robert Frasca (4/12/2010)
The indexes were rebuilt last night, are not fragmented and the statistics are up to date. Additionally, I've forced a recompile of the proc a couple of times.
Did...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 12:55 pm
Stefan_G (4/12/2010)
1) Add a nonclustered index on CountryCode, IpNumber on [my].[ipAddresses]
Ohhhh... be careful now. Unless that index is applied after all data is present and no new data will...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 12, 2010 at 12:51 pm
Viewing 15 posts - 38,896 through 38,910 (of 59,072 total)