Search results for query: *

It does, thank you. Is the CASE statement universal to all/most DBMSs?

Hi all. I would appreciate it if you could take a moment to review my SQL code, which is now in the form of 3 statements with temporary views, and point me in the direction of simplifying it into 1 statement. CREATE TEMP VIEW voidedCounts AS (SELECT pibatch AS batch,count(*) AS counted FROM...

Great! Thanks. After some explicit CAST() calls, this worked perfectly.

I have an INSERT statement with an embedded SELECT statement similar to this: INSERT INTO a SELECT nextval('a_ID_seq') AS ID,0 AS status,false AS void,b.val AS value,c.code AS code,'test' AS createUser FROM b,c WHERE b.val=c.val ORDER BY c.val,b.val The issue stems from the ORDER BY statement...

This is a total newbie question, but do any CVS systems work over the Internet like a sourceforge? I know that any of these systems could be exposed with a public IP address, with possibly some SSH, but are there any web-based applications (written maybe in .NET, java, PHP, etc) that can...

I am having a problem with Java Studio Creator because the latest version of the JDBC driver returns a field length of -1 for text fields. My question: Is a text field just a varchar(Integer.MAX_VALUE)? If I want to use the data binding part of the JSC tool I will need to convert my text...

I will try to clear up my description. I want to draw the border around multiple, dynamic cells of the table. In the table below, I would need to put a border around 0, 1, or 2 of these combinations: - ab,ef - cd - gh,kl -or- gh,kl,op ---------------------------------- | a | b | c...

I have a 4x6 data table with 100% width and a rather large (18px) font. I would like to add a colored border around certain cells as that cell's data is "checked off." I have the process down using JSF and CSS. My CSS is pretty basic, but effective: { border-top: 3px solid green; border-left...

Nesting a SELECT in an UPDATE in a SELECT" == "Selecting the updated record from an update with a nested select" I've been searching for most of the morning without any luck on this topic. I'm not sure if it's even entirely possible with SQL, but I would like to be able to SELECT a row of work...

I posted a question last week, but I didn't receive any responses, so I would like to rephrase. Please excuse the repeat. I am looking to provide a financial modeling solution. We have a legacy, vendored appliation TAS from Classic Solutions (16-bit GUI on Windows Only) that parses and...

I have an application that must run on Windows. This application creates data models on the order of ~2 Billion calculations per model. Today a 933Mhz machine can process roughly 50 of these per day. I have been tasked to build a cluster of 20 high end (3.0Ghz) PC's to distribute and share...

Is there a way to query the db for the maximum length of a field for error-checking/truncation before writing? Thanks.