100K records is a lot to do anything to in compact edition; it's mostly up to the processor and indexing. are you just searching in compact edition? what exactly are...

Jordon here's a simple SQL to...

i think you should NOT include the user/schema:

this should work instead, unless you are logging in a sys or system:

SELECT * FROM LS20001...user_triggers

also, Oracle can be picky on case sensitivity;

SELECT...

I'm with Elliot; you can assume that the dbID < 4, but, on my SQL 2008, I have 6 db's i'd call system db's:

master

tempdb

model

msdb

ReportServer

ReportServerTempDB

I think you are limited to using...

ok here's my assumption based on what you posted: the plan is to move the "Contact"'s address info into the Contact Table, instead of having it as a seperate reference...

there are views in Oracle named USER_TRIGGERS or even ALL_TRIGGERS

--specific table

select * from user_triggers WHERE TABLE_NAME = 'TBTITLE'

--owned by a specific user(equivilent to database)

select * from user_triggers WHERE TABLE_OWNER =...

great scott!

the structure really helps us understand the relationships of the data.

now to the meat and potatoes of the issue;

you said this:

...take information from one table within the database and...

scott this looks an aweful lot like homework; we volunteer our time here to help you learn and understand concepts, so lets make sure we help you the right way.

inserting...

you can add a WHERE statment to eliminate the days, but which datefield? your sample has three fields that might be datetimes:

new_lastupdatetime, createdon or new_timesupportcallreceived?

select datename(dw,getdate())--Friday

and do something like :

WHERE...

==edit i reread this and have no idea what we are after yet...sorry==

is this a hierarchy? so 1,2 is the parent record, and anything that starts with 2 would be...

--for users who are too lazy to type "SELECT * FROM TABLENAME"

CREATE procedure sp_show ...

shouldn't orderAmt be a money or decimal(19,4) datatype instead of float?

I'm thinking that because it's an approximate value for a float, some value does nto convert well to float,...

Dan it's fairly simple, you just need to use dynamic SQL;

I followed up on a similar thread where the user wanted a database and some specific roles to be created...

there are several script contributions of functions you can grab; look for "Propercase" in the scripts section;

that way you get "Raccoon City" instead of "Raccoon city" for multi-word locations.

here's one...

==edit== nice job hunterwood! you posted right when i did, yours is more elegant.==end edit==

yeah non-standard formats are going to be tough to convert. you have to substring the parts...