Hi

Friedns the check sum comparison is a good idea ,

But my problem is diffrent and so it is posted under NOT In SQL Section

See the data is comming through...

I am not looking for a solution using vb.net clent ,

Is there any way to change the display charactor of a parameter promt to '*'

while accessing the report directly through...

any way try this also

declare @integrity varchar(20)

set @integrity = 'all classified'

select * from infosys

where integrity like case when @integrity = 'all classified' then '[1234]' else '0'...

Have a look at Tally/Number Table methods also

The reponse to this was slugish , but I got the problem solved some how

For the use of other dbas and developers I'm just recoding my exp

Windows Version...

MDAC 2.8

HI Sakthivel

You are right i just want to connect to SQL Server 2005

from win98 using odbc and SQL 2000 Query Analyser

Wow!

What a lengthy discussion, It’s the time to close down this forum , normally dimension is s property of the element

Example like

Location ...

Hi friends

Thank you all,for the time you spend over this query ,

these type queries are so common in reporting as well as spread sheet ,but no so common in...

For the sake of :hehe: fun letus re write the query like this ,

CTE is a veryu good option ,but even though ,we have SQL 2005 this particular database...

let me clarify the earlier solution

let your table be tbl_x which is in now in another data base ( if exists in current DB drop it)

now you...

Hi Friends

Thank you so much for yor overwhelming reposne to my query

After a while I realised that we could solve this query using a simple logic

First consider this...

Hi Friends thank you so much for yor overwhelming reposne to my query

after a while i realised that we could solve this query using some simple logic

Thanx Michael ,

You are absolutely right ,but so much of reports are there and it will take much time to conversion

Regards

john