Hi,

I think it is like removing the duplicate rows from the table.

The query you have pasted is correct one. Just use a ranking function in your query.

(I am not...

Hi,

I m not trying to copy to sharepoint. I am just loading a excel file from sharepoint to sql table.

Here in below code i am comparing sharepoint file modified date...

Hi, If I have understood your problem correctly, then the solution is grouping of description and sum of Amount.

In this case the example is like this

DescriptionAmount

ABC10

ABC30

ABC60

Please give me example if...

Hi All,

A file can be of minimum 30000 KB in size. So let say there are around 400 files, ssis is taking around one and half day to load the...

write this formulain the font page of the field in ssrs

Hi,

It seems that you are correct when we know the possible values user can input.

But what if the values change in future or new values are added in future.

Hello,

Try this code

declare @p1 varchar(10)

set @p1 = '1.5'

select 'test' =

case

when ISNULL(@p1, 0.0) <> '0.0' then @p1

else 'does not work'

end

This is working. Very simple fact: You have declared the variable...

Hello,

You have to write cursor here to update your lunchperiod data in class table from student table. First of all insert what ever data you have in class table. Then...

Please check the link given regarding differences between SQL Server 2005 and SQL Server 2008. The link doesnot exist.

ok thanks for quick reply

I have done this one

let me see if any client is coming back with the same problem or not.

Thanks

Rajneesh