PCFormat Forum Archive

Thx man...

Resulting query :

Hi I have the following table structure : ParentObjectID ObjectID Status -------------- --------- ------ 1 1 1 1 2 1 1 3 2 1 4 2 1 5 3 2 6 1 I need to a query to get this resultset : ParentObjectID Status1Count Status2Count Status3Count 1 2 2 1 2 1 0 0 The furthest I could get is SELECT ParentObject...

Settled on this...

http://www.sybaritic.co.za/store/produc ... s_id=38323

Oi... I want to watercool a media pc... not for cooling, but just for the noise reduction (as its right below my tv)... which all-in-one, stick-it-in-and-go watercooling kits are there? I've found this... http://www.prophecy.co.za/domino-advanced-liquid-cooling-cpus-p-56365.html ... is it sufficient...

SELECT MAX([Date]), AssetID, Value1, Value2 FROM MyTable GROUP BY AssetID , Value1, Value2 If you don't aggregate (e.g. use MAX, SUM, COUNT, MIN...) a column, it needs to be included in the GROUP BY. which would be pointless as to what he actually wants. SELECT AssetID, (SELECT TOP1 [dbo].[MT].[Val...

Another one... I have a table with 5 columns... * RowID (guid) * [Date] (datetime) * AssetID (guid) * Value1 (int/varchar...) * Value2 (int/varchar...) I need to find the most recent values of Value1 and Value2 for all AssetID's. This query SELECT MAX([Date]), AssetID FROM MyTable GROUP BY AssetID d...

Thanks... Working great. EDIT : Had to tune it a bit to use as a view... was moaning about the 'ID' and 'Latest' text : SELECT dbo.Ingredients.Name, MAX(HIST.PricePerUnit) AS PRICE FROM (SELECT DISTINCT Ingredient AS IDHere, MAX(EffectiveDate) AS LatestDate FROM dbo.IngredientPriceHistory GROUP BY I...

Hi I have two tables in my database... one called Ingredient, and one IngredientPriceHistory. They are fk'd on Ingredient.IngredientID = IngredientPriceHistory.IngredientID. Everytime an ingredient's price is updated, a row gets added to the IngredientPriceHistory table, with the new price and the d...

"Estimated value : Below $100"

Stuart wrote:but how serious are you about getting the .com domain

About 7/10.

It's for a client, so I'll just pass the cost on to them.

Hi I know pricing on domain names are helluva variable, but I need some guidelines as to what to offer the current owner of a domain I'd like to have. I have a .co.za domain registered (http://www.mydomainname.co.za). True to form, some good (good = sneaky) businessman registered the .com equivalent...

Hi We have a Team Foundation Server setup for source control on a server in our network (small, about 10 computers). I've registered at dnslias.net for dynamic DNS for the router (i.e. mycompany.dnsalias.net points to my current router address). I have also opened a port on the router for our TFS Se...

Its probably just a local DNS issue on the windows server.

'Twas...

Why use POP when they have an Exchange
They pay all that money for Exchange and it's features then don't use them....

It's how the previous guy set it up. I kicked him down a well.

It was setup before I got there... I assume its so that people can still get their mail from outside via pop, so they didn't have to get a static (or dynamic dns) ip address.

Edit... do you have to restart the DNS service for the changes to take effect?

Hi Our domain (let's call it mydomain.net) was hosted with an ISP. Recently, we requested that the domain name be transferred to us, and is now being hosted at Hetzner where we can control what happens with it. Internally we have a network domain, also called mydomain.net, hosted by our own SBS2003 ...

Inglourious Basterds http://www.imdb.com/title/tt0361748/ Tarantino & Brad Pitt... don't think they've ever done something together... (actually not... check http://www.imdb.com/title/tt0108399/ ) Surrogates http://www.imdb.com/title/tt0986263/ Bruce Willis Astroboy http://www.imdb.com/title/tt0...

Sojourn wrote:Seems sybaritic is not even a dealer, my bad.
Would Rectron not stock this ?

Rectron deals ZyXel network goodies. Axiz does Intel and HP.

I'll check out Comstor, thx.

Soz... dealers/wholesalers.

Anyone know who the distributors for Linksys are?

basically on the floor near the auction house in stormwind, there are dead bodies arranged to spell a website. Didn't know they were arranged... thought it was just all the gold spammers that were killed. I've been playing for about 3 years. You won't be hacked if you don't buy gold or powerlevelli...

Users += GrimStoner;

Also... I remember last time (when I switched from ATI to NVidia), that it was preferably to format, because of driver conflicts etc. Is it necessary on Windows 7, or can I just uninstall the NVidia drivers?

Got me one 'o these...
http://www.newegg.com/Product/Product.a ... 6814150339

What's your opinion on the "Asus 4870 Dark Knight" http://usa.asus.com/products.aspx?l1=2& ... odelmenu=1

I got more to spend... What about the XFX GTX260 (896Mb)?

EDIT : soz... I was looking at http://www.prophecy.co.za/hd487azdf-hd4 ... 33882.html