I have three tables:
Products Table
PID
PName

I have the following table
idProcessMember(PK) idProcessMemberGroup
     0001                0002
----------------------------------------

I'm running SQL Reporting Services and my question is:
Can I connect the datasource of my reports to a business logic object that
returns a dataset instead of using a direct connection to a SQL Server?
Anyone that knows if and how this can be done?

Hi..
I have a row in a table with 4 fields, for arguments sake, "FIELD1",
"FIELD2", "FIELD3", and "FIELD4"
I am working on a stored procedure and what I have so far is something like

i'm using relational decision tree data mining model, i've
used DSO to create the model and train it
now i need to browse it at client, i've tried to use pivot
table but each time i pass to it connection, it raises an

Can anyone help with how to query a mining model?
SELECT * FROM MiningModel.Content
this query returns the schema not the columns inside the
model, so how can i select a statement for the columns in

SET pRS = Connect.Execute("Select * FROM Product WHERE
ItemNr in(Select ItemNr FROM Relation WHERE FuncID
= "&Request.QueryString("funk")&" AND CatID
= "&Request.QueryString("cat")&")")

can anybody help me with a code sample for retriving
output from mining model!
i need to determine what type of search categories is the
output about? will you please help

I need to know how to install arabic language in SQl 4.2
or how to migrate arabic data stored in SQL 4.2 to SQL
2000 or did any one have the following files :
Common.loc & Server.loc

I am defining a new dimension. When I select a table as
the source of the dimension and try to choose a columns
of the table as dimension levels, any text based column
of the source table dissappears from the list when I go

I need to know how to install arabic language in SQl 4.2
or how to migrate arabic data stored in SQL 4.2 to SQL
2000 or did any one have the following files :
Common.loc & Server.loc

data in single cell / field of record has multiple rows.
We are exporting data to text, however, there is a row
delimeter within cell and it carries into the text.
This of course is messing up the text file which needs to

I have a bunch of pictures that i would like to link to corresponding
people. The pictures are located on a different drive and i am not sure how
to tell my MS SQL 7 server how to locate the picters and tie them into the
record.  I would also like to have the pics displayed on the ...

I have a table in which I have a date field and an identity field.  I want to create values in an indexed bigint field consisting of the date in the form yyyyMMdd with the value of the identity column tacked on the end so that I can quickly identify the last record entered on any ...

The OLE DB for DM Sample Provider source code have been updated to be used
with newer Platform SDK. The source code have been uploaded to
http://download.microsoft.com/download/2/4/1/241c5e74-2275-470b-97c8-d3f4a210b9d
3/DMSampleProvider.zip.
Please read ReadMe.htm in the zip file ...