Thank You very much, good idea.

Hi,

Apologies for the late reply as i only returned.

Unfortunately not winning!

Any ideas!

Regards

Thank You all - I used an aspx sever side page to get the windows user id and passed it as a parameter value to my SSRS report.

Regards

Thank You for the help 🙂

Thank You for the functions, the function works: SELECT SUSER_SNAME()

but this returns the SQL user logged in, I'm trying to return the user logged on to the current PC.

search...

I have googled it and suser_name() does not work in SQL2000 it returns null

and the code user_name() only returns dbo

Please Assist

My Apologies, Sql Server 2000 (80)

I assumed that i was using Management Studio, but connecting to a DB on the SQL2000 server

How do i see 90 or 80?

Hi, I tried again.

select stuff((

SELECT ',' + cast(RoleID as varchar(20))

FROM dbo.fcUser

ORDER BY RoleID

FOR XML PATH('')

),1,1,'') as A_Values

error: Msg 170, Level 15, State 1, Line 5

Line 9: Incorrect syntax near...

Hi,

I'm using SQL2005, the query did not like the "FOR'

to remove the last comma: SELECT LEFT(@Str,LEN(@str)-1)

Regards

Thank You, found a solution:

DECLARE @STR varchar(500)

SELECT @STR=COALESCE(@Str,'') + CAST(ID as varchar(10)) + ','

FROM dbo.fcUser

SELECT @STR

Thank You for help & apologies for the spoonfeeding.

The query returns different amount of rows & i think the union all wont tork as i don't know how much rows...

Thank You but unfortunately very complicated, i thought of a case but the values differs for every run & don't know what the values would be.

Any other ideas!

Thank You very much, exactly what i needed.

Really Appreciate it.

Thank You very much!