Viewing 15 posts - 25,036 through 25,050 (of 26,490 total)
I have to agree. Just handing someone the answer to a homework problem isn't really helping them. While attending UCCS in the early 80's I worked as a...
March 18, 2008 at 6:59 am
That is interesting, but I'm not going to guess at the table structer or generate test data based on the excel spreadsheet. Please take the time to read the...
March 17, 2008 at 4:17 pm
Jeff Moden (3/17/2008)
kaiitong (3/17/2008)
I'm really appreciate your concern about me. Not to make an excuse. I've really tried on many way. I looked up in the books, searched on...
March 17, 2008 at 4:10 pm
Since all that was involved was division, addition, and multiplication; I was able to identify the correct answer without testing or reading, the order of precedence for /,*.+,- is a...
March 17, 2008 at 4:04 pm
The table DDL, some sample data (in the form of UNIONed INSERT statements), and expected output based on the sample data will help us help you figure out what you...
March 17, 2008 at 3:49 pm
In my query, I assumed that those are variables, so I replaced them with proper variable names even though I left out the declarations for them.
😎
March 17, 2008 at 2:46 pm
This is what I came up with. Please note, that if there is detail, you don't have a date to do any comparisions.
select
m.Client,
...
March 17, 2008 at 2:10 pm
J (3/17/2008)
My thoghts exactly.FOURTH normal form? I know what it is but is it REALLY used in the real world (performance issues).
The same can also be said about a truely...
March 17, 2008 at 12:45 pm
J (3/17/2008)
You could also calculate ONCE the "10 +" dates -- when crreating the record.
True, you would need an additional column (AARG! Thrid Normal Form Violation ! do NOT...
March 17, 2008 at 8:18 am
I have looked at the two files with CREATE Table statements, and I'm not going to do anything with those as it is too hard to see what's what. ...
March 17, 2008 at 8:00 am
To give a more correct answer, I think we need more information about the tables and the data. We have just about enough info to give a swap, but...
March 15, 2008 at 10:59 am
Short answer, no. You can not attach a database from SQL Server 2005 to SQL Server 2000.
😎
March 15, 2008 at 10:53 am
I also don't think it would matter in an index if the 1.5+ million rows of null in column4 were set to a default of 0 either. It would...
March 15, 2008 at 10:49 am
Mohan Kumar (3/14/2008)
Query that performs slow:select * from Table1
where column4 IS NULL
Sample Data in Table:
1124100065.16
1156101101.11
11781015NULL
118991015NULL
11989102834NULL
This query will be slow, you are only checking column4 to see if it is null,...
March 14, 2008 at 9:15 pm
It would help if we could see the query (or queries). Also, are there only 4 columns, or are you you telling us about 4 columns. The DDL...
March 14, 2008 at 8:36 pm
Viewing 15 posts - 25,036 through 25,050 (of 26,490 total)