below is database schema

--------------------|||------

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RMCPL_REQUISITION]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[RMCPL_REQUISITION]

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SampleDispatchDetails]') and...

having needs a group by clause, thats what iam trying to tell, u.

pls check it again

i never knew this format is ISO Certified hehe

what iam asking you , is in which format should i enter date , to make sure that date problem doesn't occur again..

iam using ASP pages and SQL-SERVER 2000

datatype is datetime 8

i dont think source code will be very useful

but u requested it so take it

-----------------------------------

<%

RMCPL=getvalue

set con=server.createobject("ADODB.connection")

con.Open...

well the problem

is my dates are getting reversed from dd/mm to mm/dd

ADO is changing it i suppose

our date format is dd/mm/yyyy.

and our user types dd/mm/yyyy, previously it was working fine

dates...

you talk very less,

just enough to understand

where exactly and what exactly to type

sql="SET DateFormat dmy"

con.execute sql

?

is it ?

is there any proper solution for this problem,

becoz in most of the pages iam using insert queries

and iam inserting with sql server format

yyyy-mm-dd

now we are using asp pages...

where exactly to set ,?? iam not getting u

yep you are right my technique doesn't work later i tried it out. u r does

just a simple group by name,date will produce the result, why union and all and ofcourse top 2 will , and order by date desc

Easies way to do is write a VB Program which will scan ur database and collect and transfer it to u r required database,

use ADOX catlogs (ADO object) in VB

i...

i understood u r point, and iam using it

thanks a lot dude, that was very useful, even though u talk less u make sense