Thanks for the early Reply & it is working with the collation mentioned by you.

I had one doubt here. How it is working with default collation for non unicode...

Hi,

u can do this in a single query using case statement.

select top 5* from mytable1 where CASE when @offer = 'USA' THEN status

ELSE status_country END  = 'A'

Hi Remi ,

          The above query will work fine with the above data .If a record exists with 'New Claim' and Valid EndDate Value.Then it will fail. I think following...

SELECT  ROUND(0.4799608993157, 3, 1) will return result as

.4790000000000

SELECT  CONVERT(DECIMAL(10, 3),ROUND(0.4799608993157, 3, 1)) will return result as

.479

Thanks,

Murthy

Hi,

    The same is possible with simple Set RowCount

Set rowcount 10

UPDATE table_info

    SET q_active = '1'

    WHERE table_info.pkfield in (select top 10 pkField from table_info where table_Info.q_active = 0)

Thanks,

Murthy.

SELECT  CONVERT(DECIMAL(10, 3),ROUND(0.4799608993157, 3, 1))

This will give result as .479

Hi Sergiy,

The following method will return all the Sheet Names as a Collection.U need to pass the Excel File Name as param to this method.

Public

Hi,

   This is other way of getting all the DataBase Names ,that has permissions for the current User. 

that has permissions for the current user.

Select CATALOG_NAME,SCHEMA_OWNER from INFORMATION_SCHEMA.SCHEMATA

Thanks,

Murthy.

Hi,

This is for ruturnin TOP 10

select top 10 customerid  from Customers order by customerid

This is for returning Bottom 10

select top 10 customerid  from Customers order by customerid desc

Hai,

           Please check that The columns Datatype in tje the table   you are trying to view in Access may be Bigint. I had similar problem prev. After changing it to int ...

Hai,

           Please check that The columns Datatype in tje the table   you are trying to view in Access may be Bigint. I had similar problem prev. After changing it to int ...

Hai,

    I wrote One procedure for this.

The Required Input Parameters are

 TableName

 ColumnValue

OutPutParamters are

  IsReferenseExists Returns

 1- for depency Records Exists

 0- for no depency Records Exists

Create