did you try to execute that stored procedure you like to call so you can check if the stored procedure really executing?...

i'm assuming that the stored proc you like to...

ohh my my..after i read the conversation i really shocked and this is totaly kind of misunderstanding..

I respect all the people in here and more to those give a...

Create store procedure that retrieve data that inserted in violation table and then insert it to the other table. matter of execution sequence..

Yeah ur right you need a front end, i already encounter what you need to do and me i used vb.net. The flow of my application is this , after...

Simple way to compute your age accurately.

A lot of query not exactly compute the age? yes! because sometime they only compute the datediff between DOB and datenow and divide it...

Maybe you can Try this

INSERT INTO DESTINATIONTABLE(TOTALCOUNT)

SELECT COUNT(FIELD) FROM SOURCETABLE

WHERE AGE = 49

Everytime i execute deletion i always delete my rowid(bigint) this is the Primary Key Constraint: Rows don't duplicate.

Set rules for creating table.

Using case statement is the best option in your scenario..you said that you always get more result? you should check your grouping maybe that was the problem.

Hi Jerome!

You don't need to use just to match the year and the month of your parameter. Try this query

SELECT MachineName, ModeName, FileName, UserName, StartDate, StartTime, EndDate, EndTime, RunTime,...

it depends on how the image stored.

if you insert it as byte then you need to retrieve and convert it into bitmap:-)

Yes the result is 24 not 25 because the DOB is Not exactly the currentdate.

but if the DOB is equal to currentdate or after the currentdate the result must be...

Simple way to compute your age accurately.

A lot of query not exactly compute the age? yes! because sometime they only compute the datediff between DOB and datenow and divide it...

Simple way to compute your age accurately.

A lot of query not exactly compute the age? yes! because sometime they only compute the datediff between DOB and datenow and divide it...

Simple way to compute your age accurately.

A lot of query not exactly compute the age? yes! because sometime they only compute the datediff between DOB and datenow and divide it...