You can also use PIVOT operator. Here is the example

select id, USD = ISNull([USD], 0), IND = IsNull([IND], 0)

From

(

Select id, Curr, rate

from Table

) AS Tb

Pivot

(

Sum(Rate)

For Curr in ([USD], [IND])

)...

Also, what if we don't know the credentials. can we dynamically supply the user and its password to the datasource?

You can use Set the Row Number for each component type by using Row_Number function and these use Full Join to arrange them. Here is the solution.

Declare @Emp_Dtl Table (Component...

A very nice article. Because sometimes i have to use Row number and i didn't know how to Generate Rows. previously i use to left joins and complex sub-queries to...