Search results for query: *

I have just installed the latest patch to VEA 2002 version(10.0.5110). I have two ORM source models that are used together in a DB Model and everytime I build the progect the changes to the column order for the logical model are lost. I have tried saving the changes back to the source but it...

Thanks for the help.....both solutions work like a charm! Judie

I am having the same issue with the Update/Insert triggers. I have double checked my code and I have two different triggers one for Insert and one for Update. This is the insert trigger.... create trigger tr_ins_Contact on DskContact for Insert as Begin Begin UPDATE DskContact...

If I am understanding this correctly these dates and times are not stored in a standard sql datetime field. In the past when I have worked with data such as this I rebuild the data in a format that I can then set a predefined datetime variable equal to. You can then use the DATEADD function to...

You could use Select sum(amount) from tbl_a where employee# = employee_Specified. You can include a test for the year if there is more than this years data in the database. I you needed the totals for all you can add a group by. hope this helps.... judie

The easiest way to handle fixing the dates is to fix them on insert so that you don't need to decide which records need to be fixed....everything gets fixed before it becomes part of your data. You can use the DATEADD function to alter the date time. You can do the fix either in the routine...

I am currently rebuilding our antiquated batch process using the SQL job scheduler and have run into a small issue. When a Stored procedure is executed as a job step and any message is sent back other than "Number of rows affected" the job does not terminate. I can get the procedures...