Custom Select Statment

Hello,

Why when I make a custom select statment with multiple tables, that when I test my query I'm shown the same rolls multiple times. When I make a custom query with just one table everything works just fine. I don't have any primary keys or restraints or whatever.

SELECT * FROM table1, table2, table3 Does not work(shows each row multiple times)

SELECT * FROM table1 works just fine (shows each row just one time)

Thanks

Steve

By not specifying a Join, you end up with a cross join which will return a tremendous number of duplicates.
see:http://en.wikipedia.org/wiki/Join_%28SQL%29

You need to select which columns to use to join your tables together.

For example:

SELECT table1.*, table2.*, table3.*FROM table1INNERJOIN table2ON table1.SomeKey = table2.SomeKeyINNERJOIN table3ON table1.SomeKey = table3.SomeKey

Custom Security and RS Standard Edition

My report service is Standard Edition and I implement custom security. When
I start the reporting server, the following error are shown in the log.
ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., CryptUnprotectData: Win32 error:-2146893813;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
ReportingServicesService!library!11f0!12/16/2004-14:46:03:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
The encrypted value for configuration setting Dsn cannot be decrypted., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
The encrypted value for configuration setting Dsn cannot be decrypted. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[] data, Int32 dwFlags)
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[] data)
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String data)
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String encryptedData, String element)
-- End of inner exception stack trace --
ReportingServicesService!servicecontroller!11f0!12/16/2004-14:46:03:: e
ERROR: Exception caught starting RPC server:
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
The encrypted value for configuration setting Dsn cannot be decrypted. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[] data, Int32 dwFlags)
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[] data)
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String data)
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String encryptedData, String element)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String encryptedData, String element)
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
ReportingServicesService!configmanager!11f0!12/16/2004-14:46:03:: Error
occured with a config file change. New config file will not be used. Error:
The encrypted value for configuration setting Dsn cannot be decrypted.
ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:30:: i INFO:
RPC Server stopped
ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:31:: Service
shutting down.Custom Security extensions are not supported with RS Standard Edition. They
require Enterprise edition (or developer edition for development).
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:6B887742-D891-45CB-8B42-30A3EBA1E7A4@.microsoft.com...
> My report service is Standard Edition and I implement custom security.
> When
> I start the reporting server, the following error are shown in the log.
> ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details., CryptUnprotectData: Win32 error:-2146893813;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> ReportingServicesService!library!11f0!12/16/2004-14:46:03:: e ERROR:
> Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> The encrypted value for configuration setting Dsn cannot be decrypted., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> The encrypted value for configuration setting Dsn cannot be
> decrypted. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
> data, Int32 dwFlags)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
> data)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
> data)
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> encryptedData, String element)
> -- End of inner exception stack trace --
> ReportingServicesService!servicecontroller!11f0!12/16/2004-14:46:03:: e
> ERROR: Exception caught starting RPC server:
> Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> The encrypted value for configuration setting Dsn cannot be
> decrypted. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
> data, Int32 dwFlags)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
> data)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
> data)
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> encryptedData, String element)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> encryptedData, String element)
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()
> at
> Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
> ReportingServicesService!configmanager!11f0!12/16/2004-14:46:03:: Error
> occured with a config file change. New config file will not be used.
> Error:
> The encrypted value for configuration setting Dsn cannot be decrypted.
> ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:30:: i
> INFO:
> RPC Server stopped
> ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:31::
> Service
> shutting down.|||Actually, we don't need any features of Enterprise version but we need to
spend $20,000 US dollar to buy this product just because of Custom Security
Extensions and Data Driven Subscriptions. I don't think it is worth. How
about SQL server 2005 version ?
"Jeff A. Stucker" wrote:
> Custom Security extensions are not supported with RS Standard Edition. They
> require Enterprise edition (or developer edition for development).
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> news:6B887742-D891-45CB-8B42-30A3EBA1E7A4@.microsoft.com...
> > My report service is Standard Edition and I implement custom security.
> > When
> > I start the reporting server, the following error are shown in the log.
> >
> > ERROR: Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details., CryptUnprotectData: Win32 error:-2146893813;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details.
> > ReportingServicesService!library!11f0!12/16/2004-14:46:03:: e ERROR:
> > Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> > The encrypted value for configuration setting Dsn cannot be decrypted., ;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> > The encrypted value for configuration setting Dsn cannot be
> > decrypted. -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details.
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
> > data, Int32 dwFlags)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
> > data)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
> > data)
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> > encryptedData, String element)
> > -- End of inner exception stack trace --
> > ReportingServicesService!servicecontroller!11f0!12/16/2004-14:46:03:: e
> > ERROR: Exception caught starting RPC server:
> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> > The encrypted value for configuration setting Dsn cannot be
> > decrypted. -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details.
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
> > data, Int32 dwFlags)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
> > data)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
> > data)
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> > encryptedData, String element)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> > encryptedData, String element)
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()
> > at
> > Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
> > ReportingServicesService!configmanager!11f0!12/16/2004-14:46:03:: Error
> > occured with a config file change. New config file will not be used.
> > Error:
> > The encrypted value for configuration setting Dsn cannot be decrypted.
> > ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:30:: i
> > INFO:
> > RPC Server stopped
> > ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:31::
> > Service
> > shutting down.
>
>|||No announcement has been made on features per version (there was a
presentation on improvements with 2005 but no mention of how things will be
packaged and what the costs would be). You say you don't need enterprise but
then you say you do, because data driven subscriptions and custom security
extensions are two major features of enterprise. There are not that many
things different. About the only other major difference other than those two
is support for web farms. I bet if you price versus Crystal that RS will
still come out ahead or at least even.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:73E4DC66-CC5D-4DB2-86BD-C0554280806B@.microsoft.com...
> Actually, we don't need any features of Enterprise version but we need to
> spend $20,000 US dollar to buy this product just because of Custom
> Security
> Extensions and Data Driven Subscriptions. I don't think it is worth. How
> about SQL server 2005 version ?
> "Jeff A. Stucker" wrote:
>> Custom Security extensions are not supported with RS Standard Edition.
>> They
>> require Enterprise edition (or developer edition for development).
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
>> news:6B887742-D891-45CB-8B42-30A3EBA1E7A4@.microsoft.com...
>> > My report service is Standard Edition and I implement custom security.
>> > When
>> > I start the reporting server, the following error are shown in the log.
>> >
>> > ERROR: Throwing
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details., CryptUnprotectData: Win32 error:-2146893813;
>> > Info:
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details.
>> > ReportingServicesService!library!11f0!12/16/2004-14:46:03:: e ERROR:
>> > Throwing
>> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
>> > The encrypted value for configuration setting Dsn cannot be decrypted.,
>> > ;
>> > Info:
>> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
>> > The encrypted value for configuration setting Dsn cannot be
>> > decrypted. -->
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details.
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
>> > data, Int32 dwFlags)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
>> > data)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
>> > data)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
>> > encryptedData, String element)
>> > -- End of inner exception stack trace --
>> > ReportingServicesService!servicecontroller!11f0!12/16/2004-14:46:03:: e
>> > ERROR: Exception caught starting RPC server:
>> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
>> > The encrypted value for configuration setting Dsn cannot be
>> > decrypted. -->
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details.
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
>> > data, Int32 dwFlags)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
>> > data)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
>> > data)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
>> > encryptedData, String element)
>> > -- End of inner exception stack trace --
>> > at
>> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
>> > encryptedData, String element)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()
>> > at
>> > Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
>> > ReportingServicesService!configmanager!11f0!12/16/2004-14:46:03:: Error
>> > occured with a config file change. New config file will not be used.
>> > Error:
>> > The encrypted value for configuration setting Dsn cannot be decrypted.
>> > ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:30:: i
>> > INFO:
>> > RPC Server stopped
>> > ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:31::
>> > Service
>> > shutting down.
>>

Custom Conflict Viewer

Hi -I would like to create my own conflict viewer for a few reasons:
1. I am using MSDE
2. I would like to have more control over what is shown to the user
3. The application may store attachments in image fields (say they are
Excel spreadsheets), the user would like to view the content of the winning
and losing image fields (and see the spreadsheets) before they make a
decision on which would they want to keep.
Does anyone know what is the best way to go about it?
To get information on conflicts, it seems that I need to use the
following sprocs:
sp_helpmergearticleconflicts
sp_helpmergeconflictrows
sp_helpmergedeleteconflictrows
After I have this information, it seems that I need to get the table at
the publisher (I am using the default conflict resolver so the publisher
always win when I run the Merge agent) and its equivalent conflict table and
display them to the user (after some formatting). Am I on the right track?
Are there stored procedures or views to get the conflict table or do I just
reference it directly? Are there stored procedures to manipulate the
conflict table (so the conflict can be deleted after resolution).
Are there any libraries or controls out there that would accomplish
something similar?
Thank you,
Maer
the SQL 2000 resource kit is a good start. They have a chapter devoted to
this.
You can also examine the Microsoft SQL Replication Conflict Resolver
Library.
"Maer" <maer@.auditleverage.com> wrote in message
news:O1AjILFuEHA.4040@.TK2MSFTNGP09.phx.gbl...
> Hi -I would like to create my own conflict viewer for a few reasons:
> 1. I am using MSDE
> 2. I would like to have more control over what is shown to the user
> 3. The application may store attachments in image fields (say they are
> Excel spreadsheets), the user would like to view the content of the
winning
> and losing image fields (and see the spreadsheets) before they make a
> decision on which would they want to keep.
> Does anyone know what is the best way to go about it?
> To get information on conflicts, it seems that I need to use the
> following sprocs:
> sp_helpmergearticleconflicts
> sp_helpmergeconflictrows
> sp_helpmergedeleteconflictrows
> After I have this information, it seems that I need to get the table
at
> the publisher (I am using the default conflict resolver so the publisher
> always win when I run the Merge agent) and its equivalent conflict table
and
> display them to the user (after some formatting). Am I on the right track?
> Are there stored procedures or views to get the conflict table or do I
just
> reference it directly? Are there stored procedures to manipulate the
> conflict table (so the conflict can be deleted after resolution).
> Are there any libraries or controls out there that would accomplish
> something similar?
> Thank you,
> Maer
>
|||Thank you. However, I don't want to create a custom resolver since the
ones that come with SQL Server are sufficient for us. What I want is to
create a Conflict Viewer so that after merging has taken place and winners
and losers have been chosen, the user can go there and make changes (to
override the decision if necessary).
I took a look at the chapter and it didn't seem to cover the Conflict
Viewer itself. Please let me know if I should have looked elsewhere.
Thank you for your assistance - Maer
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uaQ$h6FuEHA.1296@.TK2MSFTNGP10.phx.gbl...
> the SQL 2000 resource kit is a good start. They have a chapter devoted to
> this.
> You can also examine the Microsoft SQL Replication Conflict Resolver
> Library.
> "Maer" <maer@.auditleverage.com> wrote in message
> news:O1AjILFuEHA.4040@.TK2MSFTNGP09.phx.gbl...
> winning
> at
> and
> just
>
|||Dang it! How did I misread your post so badly and completely?
There is a conflict viewer class as well. I can't locate it at the moment,
when I find it, I'll post it here.
"Maer" <maer@.auditleverage.com> wrote in message
news:%23CtYEyIuEHA.4040@.TK2MSFTNGP09.phx.gbl...
> Thank you. However, I don't want to create a custom resolver since the
> ones that come with SQL Server are sufficient for us. What I want is to
> create a Conflict Viewer so that after merging has taken place and winners
> and losers have been chosen, the user can go there and make changes (to
> override the decision if necessary).
> I took a look at the chapter and it didn't seem to cover the Conflict
> Viewer itself. Please let me know if I should have looked elsewhere.
> Thank you for your assistance - Maer
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uaQ$h6FuEHA.1296@.TK2MSFTNGP10.phx.gbl...
>
|||Library CnfViewer
C:\Program Files\Common Files\Microsoft Shared\Database
Replication\WZCNF.dll
Replication Conflict Viewer
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23uTP0cJuEHA.3460@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Dang it! How did I misread your post so badly and completely?
> There is a conflict viewer class as well. I can't locate it at the moment,
> when I find it, I'll post it here.
> "Maer" <maer@.auditleverage.com> wrote in message
> news:%23CtYEyIuEHA.4040@.TK2MSFTNGP09.phx.gbl...
the[vbcol=seagreen]
winners[vbcol=seagreen]
to[vbcol=seagreen]
reasons:[vbcol=seagreen]
user[vbcol=seagreen]
table[vbcol=seagreen]
publisher[vbcol=seagreen]
table[vbcol=seagreen]
accomplish
>