Hey Sean Lange,

thanks a lot for sharing your experience and thoughts here.

and for the solution as well.

Actually this issue was asked in an interview of mine and my answers were to use Row_Numbers, Cursors , functions etc . but they forced me to provide a...

I am sorry for that , i think i should post in some other forum.

thanks a lot guys for your responses.

thanks a lot for your prompt response

but my requirement is not to use RowNumber or any other builtin function.

IF your are using Datasets this can be possible by using Two Select statments

first statment will fetch all actors

and second statment will fetch all movies

hence returning two data...

If your countryId's are dynamic you can pass them to stored procedure in a comma seperated string manner and then can use any function like fnsplit to transform those CSV...

You can use DateDiff

like this

SELECT DATEDIFF(mi,'2010-05-28 13:58:00.000',GETDATE())

@ColdCofee

thanks a lot for your response

It Worked for me