Thank you so much Lutz!!

can you also pls let me know what differnce I have to make if it is sheet 2 of the same excel sheet?(ie,, retrieve...

Thank u!!

So my requirement is something like this.

I have a no:of excel templates which needs to be stored in sql server 2005.Earlier these templates were stored in excel 2003.But now...

Hi Tom,

Thanks for the reply..But I see that the same is not working in the case of automatically generated XML as it contains namespace .

Do...

This query will give the result

SELECT Path As Report, UserName,RoleName FROM dbo.Catalog

INNER JOIN dbo.PolicyUserRole

ON dbo.PolicyUserRole.PolicyID = dbo.Catalog.PolicyID

INNER JOIN dbo.Users

ON dbo.Users.UserID = dbo.PolicyUserRole.UserID

INNER JOIN dbo.Roles

ON dbo.Roles.RoleID...

Mark,Sanoj..

Thank you!! The O/p is exactly what I wanted..But the problem is in reality, I'm dealing with more than 400,000 records and the query is going on more than...

There is no particular order which has to be followed if both the amounts are made on the same date.It can be taken in any order

To shed some light into...

Mark,Sanoj

Thank you for the response..

Tried out both your queries.But the issue i'm facing with the above queries is that if the date is same, the value calculated is not right

for...

Thanks for the quick response

Thank you so much!!

But I was looking for some way in which I needn't have to write so many case stmts For eg:if the value in the table was 2.443E...

Thank you so much!!

But I was looking for some way in which I needn't have to write so many case stmts For eg:if the value in the table was 2.443E...

Thank you so much!! The code fits in perfectly:-)

Thank you so much!! The code fits in perfectly:-)

Thank you so much!! The code fits in perfectly:-)

Thank you so much!! The code fits in perfectly:-)

Sorry forgot to add the group by clause..

Pls look at the foll query

select bg.[Group ID],

[Status]

...