Viewing 15 posts - 1,696 through 1,710 (of 3,061 total)
raamaakrishna (7/21/2010)
July 21, 2010 at 11:26 am
Tara-1044200 (7/21/2010)
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 😀
July 21, 2010 at 8:05 am
sdownen05 (7/20/2010)
update TempTotal
set ...
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...
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...
July 20, 2010 at 3:27 pm
Novicejatt (7/20/2010)
Thankyou very much.
Glad to help 😉
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.
July 20, 2010 at 3:01 pm
sdownen05 (7/20/2010)
The LotNumber column is already populated; I just need to add total ShipQty...
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
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...
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
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 ...
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...
July 20, 2010 at 10:06 am
Viewing 15 posts - 1,696 through 1,710 (of 3,061 total)