Thank to everybody....

I'll test your code and find the right one for my problem......

.......because I have to retrieve a record for every row in the table and then re-used in a string to execute a batch command......

waiting your suggestions.........

Thank for your sugestion......and links....

Thank to everybody,

I have found out the problem.....

In the sql statement I have to write:  mm/dd/yyyy

select * from table where DateTest between 01/01/2005 and 02/06/2005,

and everything works

More informations...

in query analyzer if I print gatedate():

print getdate()

the result is:

2005-06-02 10:48:56.623

in Enterprise manager - open table and I see in open table the field dateTest records are shown like:

13/05/2005...

Sorry,

I tried :

select * from table where DateTest between 02/06/2005 and 01/01/2005

but no result in query analyzer....

then I tried :select * from table where DateTest = '13/05/2005'

(I know there...

Thank to everybody.....

yor suggestion have been very usefull.......

Thank

............I forgot to add that my problem is in case of SQL Statement with parameter.....

the name of column change, so I declare a varable named: @Column 

eg

SELECT @MyMin  =  'Max (' +...

sorry....

I wontedto write...........

The master tables are:

 a and d in this case.....

but in a database What are the tools that permit to find that a and d are the first tables in...

Thank to everybody,

I 'll try the sp:

sp_MSdependencies, just to see how is work and what response it gives.

Just to clear better....my job is to find the first table in the gerarchy and...