thanks for your replay...

i was tried as your told that why but it is not working..

when i had selected parameter it is show error..

declare @date datetime=(

select * from policy

where...

Thanks so much.

It is working fine...

Hi

Pls try below code.

declare @test-2 table (id nvarchar(20),name varchar(10),fat int)

insert into @test-2 (id,name,fat) values(1,'aa',10)

insert into @test-2 (id,name,fat) values(1,'aa',10)

insert into @test-2 (id,name,fat)...

From_Date To_Date SM BM

2011-04-01 00:00:00.0000000 2011-04-08 00:00:00.0000000 Muneer Hussain M S Rama

2011-04-09 00:00:00.0000000 2011-06-05 00:00:00.0000000 Anwar Basha M S Rama

2011-06-06 00:00:00.0000000 2011-09-21 00:00:00.0000000 Dayakar V Ramapriyan Mukunthan

2011-09-22 00:00:00.0000000 2011-10-26 00:00:00.0000000...

CREATE TABLE Master_Data

(TO_Date DATE,FROM_SM VARCHAR(100),TO_SM VARCHAR(200),FROM_BM VARCHAR(500),TO_BM VARCHAR(200),CSC_CODE VARCHAR(100))

insert into Master_Data values('2011-04-09 00:00:00.0000000','Muneer Hussain','Anwar Basha','M S Rama','M S Rama','R16001')

insert into Master_Data values('2011-06-06 00:00:00.0000000','NULL','Dayakar V','M S Rama','Ramapriyan Mukunthan','R16001')

insert...

select

a.FILEID,

[FILE_SIZE_MB] =

convert(decimal(12,2),round(a.size/128.000,2)),

[SPACE_USED_MB] =

convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)),

[FREE_SPACE_MB] =

convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,

NAME = left(a.NAME,15),

FILENAME = left(a.FILENAME,30)

from

dbo.sysfiles a

Results:

FILEID FILE_SIZE_MB SPACE_USED_MB FREE_SPACE_MB NAME ...

pls try beloe code

SELECT kingshocks.[Partnumber] AS sku,

'Default' AS store,

FROM kingshocks

declare @Year int

declare @mon int

declare @Main datetime

set @year=2012

set @mon=3

set @Main=convert(datetime,conert(varchar(10),@year)+'-'+convert(varchar(10),@mon)+'-'+'01')

select convert(varchar(10),dateadd(ss,-1,dateadd(mm,1,@Main)),120)

pls try below code

declare @Year int

declare @mon int

declare @Main datetime

set @year=2012

set @mon=3

set @Main=convert(datetime,conert(varchar(10),@year)+convert(varchar(10),@mon)+'01')

select convert(varchar(10),dateadd(ss,-1,dateadd(mm,1,@Main)),120)

declare @table table(immid varchar(10),ppid varchar(10))

insert into @table values('TP1','TC1')

insert into @table values('TP1','TP2')

insert into @table values('TP1','TP3')

insert into @table values('TP2','TC2')

insert into @table values('TP2','TP4')

insert into @table values('TP3','TC3')

insert into @table values('TP4','TC4')

select * from @table;

with...

try below code

SELECT MIN (cc.ClaCaseID),DENSE_RANK() over(ORDER BY rl.YearOfIncident) AS latest_cla_case_no

...

pls try below code

Update T set T.SomeValue=K.TestColumn

FROM @ExampleTable T

INNER JOIN

(SELECT E.ID,

E.Name,

100 - SUM(CASE WHEN ET.SomeValue > 1 THEN ET.SomeValue ELSE 0 END) AS TestColumn

FROM

@ExampleTable ET RIGHT JOIN @Employee...

use ssis package for loading .csv file that time you find out what is excact issue in .csv file.

i was wrote below query

select ISNULL(t.region,t1.region) Region,

ISNULL(t.Lamt,0) Lamt,

ISNULL(t1.lamt,0) lamt

from @t1...

I tired but i was not got currect out .