Viewing 15 posts - 1,696 through 1,710 (of 3,060 total)
Old-n-good Lenovo T60 - very reliable.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 21, 2010 at 8:16 am
Tara-1044200 (7/21/2010)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 21, 2010 at 8:10 am
Novicejatt (7/20/2010)
Ill try to be more clear in my future posts. Still Learning.
Don't worry about Joe, some people drinks too much coffee 😀
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 21, 2010 at 8:05 am
sdownen05 (7/20/2010)
update TempTotal
set ...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 21, 2010 at 6:07 am
Michael Valentine Jones (7/20/2010)
PaulB-TheOneAndOnly (7/20/2010)
Michael Valentine Jones (7/20/2010)
Wouldn't this be a simpler calculation?
COST = [Total Pageviews] * 0.000005
Yes indeed but - always a "but" huh? - the other "more...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2010 at 3:46 pm
Michael Valentine Jones (7/20/2010)
Wouldn't this be a simpler calculation?
COST = [Total Pageviews] * 0.000005
Yes indeed but - always a "but" huh? - the other "more complex" way is better...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2010 at 3:27 pm
Novicejatt (7/20/2010)
Thankyou very much.
Glad to help 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2010 at 3:24 pm
Why don't just add a "computed column" to the original table?
Just put your math in the computed column definition.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2010 at 3:01 pm
sdownen05 (7/20/2010)
The LotNumber column is already populated; I just need to add total ShipQty...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2010 at 2:35 pm
Merge statement can be used alongside SSIS, check here for details... http://technet.microsoft.com/en-us/library/cc280522.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2010 at 2:26 pm
Chris Morris-439714 (7/20/2010)
If you're looking to assign ID's to the rows of Table 2 then do it properly with an identity column.
:pinch: Just wondering why an identity column...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2010 at 2:16 pm
Marv-1058651 (7/20/2010)
How do I add indexes to already established views?
create index command? 🙂
Please check here for details... http://msdn.microsoft.com/en-us/library/aa258260(SQL.80).aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2010 at 2:09 pm
Novicejatt (7/20/2010)
I want to Add every 7 column values.
Here is my Table:
CP CodeTimeTotal Pageviews
510146/20/20101863092
510146/21/20101858354
510146/22/20101740963
510146/23/20101573342
510146/24/20101626228
510146/25/20101637978
510146/26/20101853239
530376/20/20103511
530376/21/20103530
530376/22/20103715
530376/23/20104081
530376/24/20105548
530376/25/20105728
530376/26/20105913
Here is what I want:
CP Code Total Pageviews
51014 ...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2010 at 2:03 pm
cmbrooks08 (7/20/2010)
Thanks for the reply Paul. I've queried both for a specific ID, and the fields do come back the same. Any other suggestions?
I would build a test...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2010 at 10:06 am
mpradeesh (7/20/2010)
There is no primary/foreign key relationships and so no joins please.
:blink: What is this supposed to mean?
Are you trying to say that there is no way to know which...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2010 at 9:57 am
Viewing 15 posts - 1,696 through 1,710 (of 3,060 total)