PCFormat Forum Archive

GrimStoner

I still have DDR2-800 memory... so it might be a step up.

GrimStoner

ok options... Mobo Asus P5Q3 Deluxe/WiFi-AP http://www.asus.com/products.aspx?modelmenu=2&model=2273&l1=3&l2=11&l3=709&l4=0 Pros : WiFi onboard Cons : CrossFire, Most expensive Intel DP45SG http://www.intel.com/products/desktop/motherboards/DP45SG/DP45SG-overview.htm Pros : Cheap...

GrimStoner

Hmm... most of the suppliers only have DDR3-1333, can't find any DDR3-1600... There are some 1800's, but they are mucho expensivo.

GrimStoner

I stil wanna use my 6420 processor though... don't wanna buy another processor as well. So LGA775.

GrimStoner

Lightning + Mobo = Upgrade.

Is doshing out the extra cash worth it for a mobo that supports DDR3 and some DDR3 memory?

GrimStoner

Hi

My Peugeot 206 Gti was driven into a wall by a car wash dude... I need to fix it. Anyone know of a silver PUG being stripped? Need bonnet, l&r fenders, grille, bumper...

GrimStoner

Yes it does.

GrimStoner

Um... *cough*... well that settles that.

thanks

GrimStoner

Hi I've never used relationships at database level (FK's). Most of the time I've handled all relationships in the application logic level of my apps. We started using a new ORM tool, which requires relationships to be declared in the db. Which should have been a simple thing is now a headache... In ...

GrimStoner

The DB structure was developed by a moron; I can't change it without making too many UI changes as well. I'll try both approaches, thanks.

GrimStoner

Hi... I have three (well, potentially infinite tables (10 more likely)) tables that stores data captured by a user for different test result sets. Each table contains a TestAddedByUser column. I also have a table containing the users, with the users login id stored in UserName . I need a query that ...

GrimStoner

This is becoming a habit... I have 3 tables in SQL Server 2005... (excuse the ascii) Table1 Table2 Table3 -------- -------- -------- ID ID2 ID3 SomeField FKID FKID2 otherstuff SomeField2 Table3 is in a one-to-many relationship with Table2, and Table2 with Table1. How can I set the value of SomeField...

GrimStoner

I liked the diesel due to the claimed fuel consumption (about 7.5l/100km). Apparantly the turbos suck.

GrimStoner

1. SQL Server 2005.
2. True.
3. Don't think the date/time format would change.
4. I insert the data into the DB with an app I wrote. No 3rd party.

GrimStoner

Apparantly not...

Code: Select all

Msg 286, Level 16, State 1, Procedure UpdateDateWithTime, Line 12
The logical tables INSERTED and DELETED cannot be updated.

Any ideas?

GrimStoner

That's the way it is given to us by our supplier. Btw... what I did was : UPDATE Transactions SET DateField = DateField + convert(char(8), TimeField, 108) There are still two columns, but we'll just do reports on the DateField column. Need to keep the TimeField there, so future imports still work. I...

GrimStoner

capanno wrote:We also have a local representing SA there, in the form of Tanya van Graan. cough cough.

She does a nude scene in it.

GrimStoner

Looking at 2004-2007 ish.

GrimStoner

Also, the both columns have either AM or PM at the end... Should I just SUBSTRING ftw?

GrimStoner

Hi I have a table with about 3.5mil rows. 2 of the columns contain the date and time respectively. Because SQL combines time and dates in datetime, the dates are represented as 5/6/2007 00:00:00 and the times as 1899/01/01 15:16:17. Is there a query that I can run to combine the date and time column...

GrimStoner

So I gotta decide between a E90 (or E46) 320d, a S40 T5 or a V50 T5. All are pretty much in the same price range (R140k - R190k), and the same year (around 2004-2007). The Beemer gets awesome mileage to the gallon, but I don't think it'll match up to the (230 odd hp?) of the Volvo T5's. And I've alw...

GrimStoner

Even safer would be linear actuators. Might be expensive though.

GrimStoner

Nvm...

Code: Select all

SELECT     
     CellNumber,	  
     SUM(ISNULL(CASE Description WHEN 'Data Usage' THEN CAST(TotalBytes AS bigint) ELSE NULL END,0)) AS TotalUsage
                      
FROM
     Transactions
GROUP BY 
     CellNumber

GrimStoner

Ok... the problem is that the TotalUsage calculated column is too small for the value... How do you specify that the calculated column should be of a specific type? (i.e. bigint)

GrimStoner

When I try this... SELECT CellNumber, SUM(CASE Description WHEN 'Data Usage' THEN TotalBytes ELSE 0 END) AS TotalUsage FROM Transactions GROUP BY CellNumber I get this error : Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int. Don't understand... I'...

PCFormat Forum Archive

Search found 716 matches

Re: Is DDR3 worth it?

Re: Is DDR3 worth it?

Re: Is DDR3 worth it?

Re: Is DDR3 worth it?

Is DDR3 worth it?

PUG parts

Re: Database Design Q

Re: Database Design Q

Database Design Q

Re: SQL Query v5

SQL Query v5

SQL Query v4

Re: 320d vs S40T5 vs V50T5

Re: SQL Query v3

Re: SQL Query v3

Re: SQL Query v3

Re:

Re: 320d vs S40T5 vs V50T5

Re: SQL Query v3

SQL Query v3

320d vs S40T5 vs V50T5

Re: project............... (unknown)