Viewing 6 posts - 1 through 7 (of 7 total)
I can see that already, besides I am a glutton for punishing my 'lil brain!
September 28, 2005 at 1:31 pm
Ah, ok, sorry about that...
Here is the script that was generated with the "Script Object to New Window > Create" command:
CREATE TABLE [pdb_records] (
[EntryID] [int] IDENTITY (1, 1) NOT NULL...
September 28, 2005 at 1:18 pm
Sample data is posted above:
ReceiveDate | ReceiveTime | ResolveDate | ResolveTime |
September 28, 2005 at 12:37 pm
ok, another newbie question:
This will be added after the "SELECT * FROM TableName" right?
There are over 100k records in this DB, my first query is:
SELECT PROGRAM, COUNT(PROGRAM) AS #Call
FROM pdb_records
GROUP...
September 28, 2005 at 11:10 am
ReceiveDate | ReceiveTime | ResolveDate | ResolveTime |
1/15/2003 |
September 28, 2005 at 10:59 am
Unfortunatley this is a 'live' DB and I can't merge them. The data has been gathered over the last 4-5 years.
The Date columns are datetime (8) and the Time columns...
September 28, 2005 at 9:55 am
Viewing 6 posts - 1 through 7 (of 7 total)