[SQL Server Reporting] Converting a GUID back to its original contents

Hi,
I have an SQL Server Table in which one of the attributes is stored as
a GUID. The GUID actually represents the name of a SQL Server
Reporting Services report.
Once I retrive the GUID from the DB, I cant figure out how to get the
Report Name back from it.
I was wondering if anyone could point me to where the data for all the
GUIDs are stored in an SQL Server DB. Is it in tables? or are there
specific calls i need to make?
Any help would be great, been trying to figure this out for quite some
time now. :)
Thanks in advance.
Regards, LloydOn Jun 19, 11:25 am, lloyddsi...@.gmail.com wrote:
> Hi,
> I have an SQL Server Table in which one of the attributes is stored as
> a GUID. The GUID actually represents the name of a SQL Server
> Reporting Services report.
> Once I retrive the GUID from the DB, I cant figure out how to get the
> Report Name back from it.
> I was wondering if anyone could point me to where the data for all the
> GUIDs are stored in an SQL Server DB. Is it in tables? or are there
> specific calls i need to make?
> Any help would be great, been trying to figure this out for quite some
> time now. :)
> Thanks in advance.
> Regards, Lloyd
Hi,
I've got the answer from my post in the
microsoft.public.sqlserver.reportingsvcs group.
Thanks everyone.
Cheers, Lloyd|||On Jun 19, 1:24 pm, lloyddsi...@.gmail.com wrote:
> On Jun 19, 11:25 am, lloyddsi...@.gmail.com wrote:
>
> > Hi,
> > I have an SQL Server Table in which one of the attributes is stored as
> > a GUID. The GUID actually represents the name of a SQL Server
> > Reporting Services report.
> > Once I retrive the GUID from the DB, I cant figure out how to get the
> > Report Name back from it.
> > I was wondering if anyone could point me to where the data for all the
> > GUIDs are stored in an SQL Server DB. Is it in tables? or are there
> > specific calls i need to make?
> > Any help would be great, been trying to figure this out for quite some
> > time now. :)
> > Thanks in advance.
> > Regards, Lloyd
> Hi,
> I've got the answer from my post in the
> microsoft.public.sqlserver.reportingsvcs group.
> Thanks everyone.
> Cheers, Lloyd
Oops .. i meant the microsoft.public.sqlserver.programming group above
Cheers.

@original and stored procedures

When using @.original_{0}, how does this work if you are using a stored procedure instead of inline SQL? For example, if my update parameters are like this :

<

UpdateParameters><asp:ParameterType="String"Name="ProductType"/><asp:ParameterType="String"Name="OpportunityType"/><asp:ParameterType="Double"Name="Value"/><asp:ParameterType="String"Name="Probability"/><asp:ParameterType="Int32"Name="OpportunityID"/></UpdateParameters>

And my stored procedure like this :

CREATE procedure dbo.UpdateOpportunity

(
@.ProductType int,
@.OpportunityType int,
@.Value money,
@.Probability int,
@.OpportunityID int
)

as

update Opportunity
set ProductType = @.ProductType, OpportunityType = @.OpportunityType,
[Value] = @.Value, Probability = @.Probability
where OpportunityID = @.OpportunityID

Do I need to change both cases of @.OpportunityID in my stored procedure to @.original_OpportunityID for it to work?

Most likely. It also depends on what you have set for the conflictdetection property. If it's compareallvalues, then you'll need to accept @.original_ for each of the columns that you selected via your select statement.