Data SubSet

Is it possible to perform an SQL query on a ReportingServices DataSet... I
would like to write a statement like this:
SELECT COUNT(DISTINCT ServiceID) FROM RS_DataSet WHERE ServiceStatus = "ACTIVE"
I know it would be easy to create a new DataSet with this query... however
RS it getting this table from an application... not directly from a
database...Couldn't you just filter the dataset that you already have?
"MER78" wrote:
> Is it possible to perform an SQL query on a ReportingServices DataSet... I
> would like to write a statement like this:
> SELECT COUNT(DISTINCT ServiceID) FROM RS_DataSet WHERE ServiceStatus => "ACTIVE"
> I know it would be easy to create a new DataSet with this query... however
> RS it getting this table from an application... not directly from a
> database...|||Well that is what I was talking about... but I can't figure out how I would
do that without making invisible tables that filter and count for each
condition... the table I have displaying my DataSet is supposed to show all
the data... but counting say ACTIVE records... would be a subset of that
DataSet.
"B. Mark McKinney" wrote:
> Couldn't you just filter the dataset that you already have?|||I figured out a solution for my problem... with a little help from Google...
for anyone that might b interested...
=CountDistinct(IIF(Fields!ServiceStatus.Value = 1, Fields!ServiceID.Value,
NOTHING))
"MER78" wrote:
> Is it possible to perform an SQL query on a ReportingServices DataSet... I
> would like to write a statement like this:
> SELECT COUNT(DISTINCT ServiceID) FROM RS_DataSet WHERE ServiceStatus => "ACTIVE"
> I know it would be easy to create a new DataSet with this query... however
> RS it getting this table from an application... not directly from a
> database...

Data Normalization - Best approach?

Hi!

I wonder what would be the best (at to be honest - how to do it at all) to perform data normalization with SSIS. The scenario is as follows:

I got plain table with several columns in it.Some of columns can be copied straight into destination tableSome columns (String) should be lookup in another table to get ID
On success just replace string with IDOn fail - create new record in lookup table and return newly created ID

Thanks for any ideas and maybe short samples

Anrijs Vitolins

Yeah you can do all of this. This link will get you started regarding the lookup and putting new records into the lookup table - I recommend method 2: http://www.sqlis.com/default.aspx?311

You'll need a MULTICAST transform in there at some point as well by the sounds of it.

-Jamie

Data mining prediction

Hi again....

I have tree models trained and now how do I perform predictions? I've read that i can use ADO in my vb language so could anyone give me some code lines about prediction using ADO and Vb language? and how to view the prediction in my vb application?

Thank's a lot

Once you have a trained model, you can do perform predictions by querying the model using the DMX language (which is similar to SQL). Take a look at the source code for the DM Sample which uses ADO/VB to send your queries to AS 2000 and displays the result in a hierarchical grid control: http://www.sqlserverdatamining.com/DMCommunity/Downloads/Links_LinkRedirector.aspx?id=85

Data Load

SQL 2K
We have a data-warehouse server which loads data from different databases
which resides in a different server, perform business logic and load into a
FACT table.
I created 4 SQL jobs which does the above same thing from different
databases and writing to same table.
This job is scheduled to run at the same time.
My question
1) What all steps to consider ,since different jobs loading data to same
table and also query same table.
Thanks
ShIf each job has to do a look in the target table, it's probably not a good
thing to process them in parallel. Perhaps, you want to load the data
independently into a staging table for each of your jobs. Then do a final
push/pull of all staging tables.
--
-oj
http://www.rac4sql.net
"MS User" <sqlman@.sql.com> wrote in message
news:OdhPaWXIEHA.4052@.TK2MSFTNGP12.phx.gbl...
> SQL 2K
> We have a data-warehouse server which loads data from different databases
> which resides in a different server, perform business logic and load into
a
> FACT table.
> I created 4 SQL jobs which does the above same thing from different
> databases and writing to same table.
> This job is scheduled to run at the same time.
> My question
> 1) What all steps to consider ,since different jobs loading data to same
> table and also query same table.
> Thanks
> Sh
>

Data Load

SQL 2K
We have a data-warehouse server which loads data from different databases
which resides in a different server, perform business logic and load into a
FACT table.
I created 4 SQL jobs which does the above same thing from different
databases and writing to same table.
This job is scheduled to run at the same time.
My question
1) What all steps to consider ,since different jobs loading data to same
table and also query same table.
Thanks
Sh
If each job has to do a look in the target table, it's probably not a good
thing to process them in parallel. Perhaps, you want to load the data
independently into a staging table for each of your jobs. Then do a final
push/pull of all staging tables.
-oj
http://www.rac4sql.net
"MS User" <sqlman@.sql.com> wrote in message
news:OdhPaWXIEHA.4052@.TK2MSFTNGP12.phx.gbl...
> SQL 2K
> We have a data-warehouse server which loads data from different databases
> which resides in a different server, perform business logic and load into
a
> FACT table.
> I created 4 SQL jobs which does the above same thing from different
> databases and writing to same table.
> This job is scheduled to run at the same time.
> My question
> 1) What all steps to consider ,since different jobs loading data to same
> table and also query same table.
> Thanks
> Sh
>

Data Load

SQL 2K
We have a data-warehouse server which loads data from different databases
which resides in a different server, perform business logic and load into a
FACT table.
I created 4 SQL jobs which does the above same thing from different
databases and writing to same table.
This job is scheduled to run at the same time.
My question
1) What all steps to consider ,since different jobs loading data to same
table and also query same table.
Thanks
Sh
If each job has to do a look in the target table, it's probably not a good
thing to process them in parallel. Perhaps, you want to load the data
independently into a staging table for each of your jobs. Then do a final
push/pull of all staging tables.
-oj
http://www.rac4sql.net
"MS User" <sqlman@.sql.com> wrote in message
news:OdhPaWXIEHA.4052@.TK2MSFTNGP12.phx.gbl...
> SQL 2K
> We have a data-warehouse server which loads data from different databases
> which resides in a different server, perform business logic and load into
a
> FACT table.
> I created 4 SQL jobs which does the above same thing from different
> databases and writing to same table.
> This job is scheduled to run at the same time.
> My question
> 1) What all steps to consider ,since different jobs loading data to same
> table and also query same table.
> Thanks
> Sh
>

Data Load

SQL 2K
We have a data-warehouse server which loads data from different databases
which resides in a different server, perform business logic and load into a
FACT table.
I created 4 SQL jobs which does the above same thing from different
databases and writing to same table.
This job is scheduled to run at the same time.
My question
1) What all steps to consider ,since different jobs loading data to same
table and also query same table.
Thanks
ShIf each job has to do a look in the target table, it's probably not a good
thing to process them in parallel. Perhaps, you want to load the data
independently into a staging table for each of your jobs. Then do a final
push/pull of all staging tables.
-oj
http://www.rac4sql.net
"MS User" <sqlman@.sql.com> wrote in message
news:OdhPaWXIEHA.4052@.TK2MSFTNGP12.phx.gbl...
> SQL 2K
> We have a data-warehouse server which loads data from different databases
> which resides in a different server, perform business logic and load into
a
> FACT table.
> I created 4 SQL jobs which does the above same thing from different
> databases and writing to same table.
> This job is scheduled to run at the same time.
> My question
> 1) What all steps to consider ,since different jobs loading data to same
> table and also query same table.
> Thanks
> Sh
>