i have a column with Contacts to use as a Paramter.
The display-name is the main and the internal value is of type uniqueidentifier.
It should additionally appear a value named 'all' which means that all Contacts should be selected.
I tried it like that:
Select '*' as accountid, '[Alle]' as [name]
Select accountid, name from dbo.FilteredAccount
order by name
but it gives an error; String cannot be converted to uniqueidentifier.
How can it be solved?
View Complete Post