Hi John
Oh sorry I thoght that was a sample of the web site.
I played around for 5 minutes and came up with the following:
It seems like the decimal...
3347
Noman Aftab
noman17pk
Jan 23, 2008 12:22 pm
I have a simple web application with list and add/edit pages. The requirement is that there are two types of users; maker and checker, and for every table...
3348
John Warner
john@...
Jan 23, 2008 1:30 pm
Boy, do I like your solution far far better than mine! I just hope I can make myself remember this sometime in the future. I wonder why SQL Server incorrectly...
3349
John Warner
john@...
Jan 23, 2008 1:35 pm
Travis check this out. Based on Damhuis's wonderful suggestion. Note plug this into QA I was rather surprised. DECLARE @v1 DECIMAL(19, 9), @v2 DECIMAL(19, 9), ...
3350
John Warner
john@...
Jan 23, 2008 1:37 pm
How does one know when a Checker approves? John Warner ... requirement ... table ... PK) ... table. ... and...
3351
Travis Truax
truaxt2000
Jan 23, 2008 3:20 pm
Thanks guys, This is actually the same solution from the sqlmag article. They included a small table of how SQL Server calculates result precision & scale: ...
3352
John Warner
john@...
Jan 23, 2008 3:28 pm
Zero instead of Null may have to do with the 'object' having to be completely recreated for Null where zero is just another assignment operation. This is just...
3353
Paul Anca
paul_anca
Jan 23, 2008 4:29 pm
If you are using SQL Server, here is your query: update SERVICE set SERVICE_NAME = B.SERVICE_NAME, SERVICE_DISPLAY_NAME = B.SERVICE_DISPLAY_NAME, SERVICE_CODE...
3354
Travis Truax
truaxt2000
Jan 23, 2008 5:13 pm
On the topic of UPDATE statements with the non-standard FROM clause in them: I have found this syntax to be much easier to use than standard sql syntax, to the...
3355
Paul Anca
paul_anca
Jan 23, 2008 5:51 pm
Standard SQL (without FROM clause) will be something like this, don't take the follow as actual working code, just some directions: UPDATE SERVICE SET ...
3356
lcg_ribeiro
Jan 23, 2008 10:19 pm
Hi friends. I'm converting the columns of the datatype Long Raw for Blob. I have an application that basically what it makes is: SelectBlob xxx... Generates...
3357
John Warner
john@...
Jan 23, 2008 10:34 pm
You will have to tell us the DBMS. John Warner...
3358
Noman Aftab
noman17pk
Jan 23, 2008 10:37 pm
Travis, You can use a miltiplier.Lets say for a precision of 9 digits, multiply each value by 10^9 (1000000000) to get a whole number, then multiply themself...
3359
Travis Truax
truaxt2000
Jan 24, 2008 12:17 am
That's an interesting suggestion, Noman Thanks- ... From: Noman Aftab [mailto:noman17pk@...] Sent: Monday, January 21, 2008 11:09 PM To:...
3360
Luiz Ribeiro
luiz.ribeiro@...
Jan 24, 2008 11:01 am
Oracle 9.2.0.1.0 ________________________________ From: SQLQueriesNoCode@yahoogroups.com [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of John Warner ...
3361
Noman Aftab
noman17pk
Jan 25, 2008 3:34 pm
Thanks Anca. Paul Anca <paul@...> wrote: If you are using SQL Server, here is your query: update SERVICE set SERVICE_NAME = B.SERVICE_NAME, ...
3362
corinnel_64
Jan 28, 2008 2:17 pm
Hello, I have been asked "What or How do you use joins to make them more efficient in terms of database usage?" "How do you make a join more efficient?" ...
3363
John Warner
john@...
Jan 28, 2008 2:23 pm
What does your textbook say on the subject? Has Google suggested any reading? John Warner...
3364
Charles Carroll
charlesmarkc...
Jan 28, 2008 3:25 pm
I am not a big fan of "look at Google" or "look at your textbook" answers here. In my experience thanks to SEO (Search Engine Optimization) many of the Google...
3365
Charles Carroll
charlesmarkc...
Jan 28, 2008 3:52 pm
Well on a basic level all fields that are primary keys and foreign keys should be indexed (and where possible clustered indexing may be a good idea if the DB...
3366
Michael Weiss
mweiss@...
Jan 28, 2008 5:09 pm
If you can afford to do so, pick up a copy of Ken Henderson's The Guru's Guide to Transact-SQL. It is packed with good tips on questions like these and lots of...
3367
Travis Truax
truaxt2000
Jan 28, 2008 6:20 pm
I second that. I have a massive pile of technical books, and good ones are few and far between. On a 1 to 10 scale, the 10 usually means "tolerable" for...
3368
John Warner
john@...
Jan 28, 2008 6:27 pm
Hoping he will update when 2008 is released and include some coverage of the new data types and new varchar non-limits. The XML book clearly needs an update....
3369
corinnel_64
Jan 28, 2008 7:10 pm
Thanks all for your answers, I really appreciate. This question was asked during an interview. I know what are the different types of joins and what they do...
3370
Charles Carroll
charlesmarkc...
Jan 28, 2008 7:18 pm
I was not asking you what types of joins to see if you knew. Each type of join may require a variation on the strategy. Any answer is good but the best answer...
3371
Michael Gooch
goochmi
Jan 29, 2008 10:24 pm
I have one table (tblparts) where I'm in need of a query that would update certain records based on PartNum, but only in order to append to the Condition...
3372
Tim Mitchell
tdmitch
Jan 29, 2008 10:34 pm
Something like this should do it: UPDATE tblparts SET condition = ISNULL(condition, '') + CASE WHEN LEN(ISNULL(condition, '')) > 0 THEN ';repaired' ELSE...
3373
ilcon4
Jan 30, 2008 5:51 am
I have a question about file format , to be transferred between Clien Server and IBM AS400. What kind of file can be prodused on Client Server, so it can be...
3374
Charles Carroll
charlesmarkc...
Jan 30, 2008 9:02 am
OFF-TOPIC here since it is not really a SQL query syntax question. http://tech.groups.yahoo.com/group/AS400-Lovers/ is probably great place to ask that. If...
3375
John Warner
john@...
Jan 30, 2008 9:47 am
Thos would be covered in the client software for the PCs on the network that are attached to the AS400. IBM supplies this sort of driver. I would visit the IBM...
