Profiler and set fmtonly On issue

Hi,
why do I have a lot of
set fmtonly On, the sql phrase and then set fmtonly Off
example :
SET FMTONLY ON Select PROD_VAT_CODE From Product Where PROD_MANF_SKU =
'Q2477A#401'
SET FMTONLY OFF
I know that turning it on means retuns columns info with no data back. So it
is called when c alling A SP that has a simple T-SQL phrase as the example
in my trace in profilee and how can I disable so it will not be included in
the trace results
set fmtonly off%
Most probably your API (probably ADO) that wants to retrieve meta-data for the query before the
actual data is returned. I.e., a matter of how you are using ADO. I suggest you post to an ADO
group, including a small comment or slimmed-down-code-sample showing your current coding technique.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:FCE31D96-46D0-4659-B4C0-DF95EEA53EE2@.microsoft.com...
> Hi,
> why do I have a lot of
> set fmtonly On, the sql phrase and then set fmtonly Off
> example :
> SET FMTONLY ON Select PROD_VAT_CODE From Product Where PROD_MANF_SKU =
> 'Q2477A#401'
> SET FMTONLY OFF
> I know that turning it on means retuns columns info with no data back. So it
> is called when c alling A SP that has a simple T-SQL phrase as the example
> in my trace in profilee and how can I disable so it will not be included in
> the trace results
> set fmtonly off%
>
|||SalamElias wrote:
> Hi,
> why do I have a lot of
> set fmtonly On, the sql phrase and then set fmtonly Off
> example :
> SET FMTONLY ON Select PROD_VAT_CODE From Product Where PROD_MANF_SKU =
> 'Q2477A#401'
> SET FMTONLY OFF
> I know that turning it on means retuns columns info with no data
> back. So it is called when c alling A SP that has a simple T-SQL
> phrase as the example
> in my trace in profilee and how can I disable so it will not be
> included in the trace results
> set fmtonly off%
I've seen the problem in Delphi client applications that use ADO. When
you discover how to turn it off in your code (regardless of what you
wrote it in), please post the solution here so I can inform my
colleagues.
Thanks.
David Gugick
|||I never do any manipulation using the set fmtonly. It is a straight forward
asp ADO code
(open conn, give it a T-SQL or a stored procedure, populate parameters and
get back the result using a dataset or call execute methode.
For the T-SQL I gave as an example, her is the relevant piece of code :
objConn.Open "Provider=SQLOLEDB;Password=user;Persist Security Info=True; _
User ID=user;Initial Catalog=PETC;Data Source=myserver"
cmdSQL.ActiveConnection = objConn
Then I have a record set which I loop through, in the loopi Execute the
following
sstrsql = "Select PROD_VAT_CODE From Product Where PROD_MANF_SKU = '" &
OrderForm.items(i)("SKU") & "'"
cmdSQL.CommandText = sstrsql
Set rsSKUVat = cmdSQL.Execute
"Tibor Karaszi" wrote:

> Most probably your API (probably ADO) that wants to retrieve meta-data for the query before the
> actual data is returned. I.e., a matter of how you are using ADO. I suggest you post to an ADO
> group, including a small comment or slimmed-down-code-sample showing your current coding technique.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "SalamElias" <eliassal@.online.nospam> wrote in message
> news:FCE31D96-46D0-4659-B4C0-DF95EEA53EE2@.microsoft.com...
>
>
|||Just out of curiousity, why are you persisting security info? Also,
there are a number of properties that you can set on the resultset and
command objects. Can you provide that information as well?
David Gugick
Imceda Software
www.imceda.com
SalamElias wrote:[vbcol=seagreen]
> I never do any manipulation using the set fmtonly. It is a straight
> forward asp ADO code
> (open conn, give it a T-SQL or a stored procedure, populate
> parameters and get back the result using a dataset or call execute
> methode.
> For the T-SQL I gave as an example, her is the relevant piece of code
> : ---
> objConn.Open "Provider=SQLOLEDB;Password=user;Persist Security
> Info=True; _ User ID=user;Initial Catalog=PETC;Data Source=myserver"
> cmdSQL.ActiveConnection = objConn
> Then I have a record set which I loop through, in the loopi Execute
> the following
> sstrsql = "Select PROD_VAT_CODE From Product Where PROD_MANF_SKU = '"
> & OrderForm.items(i)("SKU") & "'"
> cmdSQL.CommandText = sstrsql
> Set rsSKUVat = cmdSQL.Execute
> "Tibor Karaszi" wrote:
|||What do you mean by persisiting scurity info?Secondly, can you you indicate
the different parameters that are usefull to use in commands or datasets
Thanks a lot
"David Gugick" wrote:

> Just out of curiousity, why are you persisting security info? Also,
> there are a number of properties that you can set on the resultset and
> command objects. Can you provide that information as well?
> --
> David Gugick
> Imceda Software
> www.imceda.com
> SalamElias wrote:
>
>
|||Profiler and set fmtonly On issue|||Thanks for the info, but would you please can you you
indicate the different parameters that are usefull to use in commands
or datasets Thanks a lot
"David Gugick" wrote:

> SalamElias wrote:
>
> What parameters are you setting for the recordset object. Ther are
> settings for cursor location and type in particular.
> The persist is in your connect string as you posted it:
> objConn.Open "Provider=SQLOLEDB;Password=user; Persist Security
> Info=True; _
> User ID=user;Initial Catalog=PETC;Data Source=myserver"
> You should read about that option if you're not sure why it's there.
> From MSDN:
> "Remarks
> If Persist Security Info is set to False at the time the data source is
> initialized, the data source cannot persist sensitive authentication
> information. Furthermore, a call to a property that contains sensitive
> authentication information, such as a password, returns a default value
> instead of the actual password.
> After the data source has been uninitialized, sensitive information that
> was set when the data source was initialized with the Persist Security
> Info property set to False still cannot be obtained from the Properties
> collection or by persisting the uninitialized data source object.
> However, new properties set after the data source object has been
> uninitialized can be persisted or obtained if Persist Security Info is
> set to True.
> Before the data source is initialized for the first time, sensitive
> information can be obtained from the Properties collection, and can be
> persisted, regardless of the setting of the Persist Security Info
> property. Therefore, sensitive applications should avoid passing
> uninitialized data source objects.
>
> Note The recommended method for connecting to an instance of Microsoft?
> SQL Server? 2000 is to use Windows Authentication mode."
>
>
> --
> David Gugick
> Imceda Software
> www.imceda
|||SalamElias wrote:
> Thanks for the info, but would you please can you you
> indicate the different parameters that are usefull to use in commands
> or datasets Thanks a lot
>
Can you post what you are using please.
Generally, with ADO, I like to use forward-only, read-only, server-side
cursors. They are the fastest when minimal row processing on the client
is required. If you need to perform a lot of processing on each row in
the results, then I might move over to a client-side cursor just to get
the rows off the server more quickly.
David Gugick
Imceda Software
www.imceda.com

Product Version query

I've just downloaded SQL Server Express (with advanced services) from both the main SQL Server Express website and from MSDN. When I right click on the exe I downloaded and go into properties the Product Version says SQLEVALVER. To me this implies it is an evaluation.

Can I confirm this is just a mistake and if we start to redistribute the product it won't timeout in the future? I am sure it is not an evaluation but just want to make absolutely sure.

hi,

, yep... it's true ...

but as long as you downloaded the correct binaries there's no problem, and it will install the appropriate SQLExpress version..

and this are not Eval binaries... they are just "free"..

regards

Product Sub-Typing

Hi,

I am interested in opinions on the following,

main(product_id, short_text, price, type)
productTypes(type_id, type)
productTables(type_id, tableName)
productA(product_id, field1, field2)
productB(product_id, field1, field2)

To retrieve all products of type 'A', one must know the table name, in this case 'productA'.

Here is one method.

Create a table that contains the table name that corresponds to each product type, thus the stored procedure only needs to recieve the type_id which can be used to obtain the name of the respective table....and the result of all this would be dynamic SQL, right? I would not recommend it.sql

Product Search question

I have a search box on my website which is used to search the products database.

I will be using the search text in an SQL stored procedure that uses LIKE statements. The search string could realistically contain any character.

How do I prevent SQL injection when any search string is reasonably feasible? .

supergriff:

How do I prevent SQL injection when any search string is reasonably feasible?

I recommend that you read the weblog entry by Microsoft's Bertrand Le Roy,Please, please, please, learn about injection attacks!|||

Great, so if i'm using stored procedures, rather than string concatenation, this inherently prevents SQL injection? My search function is below:

' Select all ProductsPublicFunction GetAllVisibleProductsBySearchString(ByVal SearchStringAsString)As DataTable

Dim connAs SqlConnection =New SqlConnection(_connectionString)Dim cmdStoredProcedureAsNew SqlCommand("dis_GetAllVisibleProductsBySearchString", conn)

cmdStoredProcedure.CommandType = CommandType.StoredProcedure

cmdStoredProcedure.Parameters.Add(

"@.SearchString", SqlDbType.VarChar, 250).Value = SearchStringDim daAs SqlDataAdapter =New SqlDataAdapter(cmdStoredProcedure)Dim dsAs DataSet =New DataSet()Try

conn.Open()

da.Fill(ds,

"Products")

Catch eAs SqlException

' Handle exception.Finally

conn.Close()

EndTryReturn ds.Tables("Products")EndFunction

Product Sales Forecasting.

Hi,

We are trying to forcast product sales for next three months based on their sales for previous 12 months. In this case, Microsoft Time Series algorithm requires the sales data to be present for each product for past 12 months (?). However, our products have typical life span of 6 months and obviously the new products will not have sales before they were added. Any help will be very much appreciated.

Thanks

Riju

Riju -

A few pointers that have been very successful for us in forecasting sales and inventory:

1. Can you build store clustering models to increase the data set size?
2. For new products you can also try correlating sales from similar existing products. We have utilized attributes from existing products and mapped their sales as a predictor for new product sales.

Here is a whitepaper that provides a detailed inventory forecasting example from Project REAL http://apollodatatech.com/company/shell.html?projreal

Hope this helps,

Jeff

Please visit Apollo Data Technologies http://apollodatatech.com/|||

Hi Jeff,

Thanks for the response.

It seems that the Out-of-stock predictive model in REAL project is based in the Decision Tree algorithm which does not require the data to be present for each period. I am having problem to use Time Series algorithm becuase my products typically have sales for about six month and i am trying to use the last 12 months data to predict the sales of next 3 months.

Thanks

Riju

|||

This must be a common problem in forcasting. Isn't there any way to handle this?

Thanks

Riju

|||You should read the paper referenced by apollo. In these circumstances you likely need to build a tree model to predict based on similar products, not use time series as there's not enough historical data.|||

Hi Jamie,

Thanks for the response.

I read the paper referenced by Apollow which gave the detail information on how to predict the product sales using the Decision Tree algorithm. However, i was trying to get some help on how to use the Time Series algorithm in my situation. Thanks to your response which stated that the Time Series algorithm is not applicable in my situation.

Riju

Product qty in a given branch

Hi,
I'm new to queries and I'm stuck with joins...
I have the following tables, and would like to get the total of the
products, given a BranchId:
table Product
ProductId: PK
ProductName
table Branch
BranchId
table Inventory
InventoryId: PK
BranchId: FK to Branch.BranchId
table InventoryDetail
InventoryDetailId: PK
InventoryId: FK to Inventory.InventoryId
ProductId: FK to Product.ProductId
Quantity
Here is what I started:
CREATE PROCEDURE SelectProductByName(@.BranchId INT, @.ProductName
NVARCHAR(100))
AS
SELECT P.ProductId, P.ProductName, Sum(ID.Quantity) AS Qty
FROM Product AS P
LEFT JOIN InventoryDetail AS ID ON ID.ProductId = P.ProductId
/*And waht now with*/
RETURNHello, Michael
I guess you want something like this:
SELECT P.ProductId, P.ProductName, X.Qty
FROM Product AS P LEFT JOIN (
SELECT ID.ProductId, Sum(ID.Quantity) AS Qty
FROM InventoryDetail ID
INNER JOIN Inventory I ON ID.InventoryId = I.InventoryId
WHERE I.BranchId = @.BranchId
GROUP BY ID.ProductId
) X ON P.Product = X.ProductId
WHERE P.ProductName = @.ProductName
This query may also work, but the first query is better:
SELECT P.ProductId, P.ProductName, Sum(ID.Quantity) AS Qty
FROM Product AS P
LEFT JOIN InventoryDetail ID ON P.ProductId = ID.ProductId
LEFT JOIN Inventory I ON ID.InventoryId = I.InventoryId
AND I.BranchId = @.BranchId
WHERE P.ProductName = @.ProductName
GROUP BY P.ProductId, P.ProductName
Razvan|||Hi Razvan,
Thank you very much for the help.
Why is the first first query better than the second one?
Also, I've come up with the following query. Is it correct?
SELECT P.ProductId, P.ProductName,
(SELECT SUM(ID.Quantity) FROM InventoryDetail AS ID
JOIN Inventory AS I ON I.InventoryId = ID.InventoryId
WHERE (I.BranchId = @.BranchId) AND (ID.ProductId = P.ProductId))
AS Qty
FROM Product AS P
WHERE (P.ProductName = @.ProductName)
Regards
Razvan Socol wrote:
> Hello, Michael
> I guess you want something like this:
> SELECT P.ProductId, P.ProductName, X.Qty
> FROM Product AS P LEFT JOIN (
> SELECT ID.ProductId, Sum(ID.Quantity) AS Qty
> FROM InventoryDetail ID
> INNER JOIN Inventory I ON ID.InventoryId = I.InventoryId
> WHERE I.BranchId = @.BranchId
> GROUP BY ID.ProductId
> ) X ON P.Product = X.ProductId
> WHERE P.ProductName = @.ProductName
> This query may also work, but the first query is better:
> SELECT P.ProductId, P.ProductName, Sum(ID.Quantity) AS Qty
> FROM Product AS P
> LEFT JOIN InventoryDetail ID ON P.ProductId = ID.ProductId
> LEFT JOIN Inventory I ON ID.InventoryId = I.InventoryId
> AND I.BranchId = @.BranchId
> WHERE P.ProductName = @.ProductName
> GROUP BY P.ProductId, P.ProductName
> Razvan
>|||Hello, Michael

> Why is the first first query better than the second one?
Before testing the queries (because I had no DDL and sample data, see:
http://www.aspfaq.com/etiquette.asp?id=5006), I wrote that the first
query is better, because the second query seemed unsafe to me. Now that
I've tested it (by translating it for one of my own schemas), I can say
that the second query is plain wrong: it doesn't return the expected
results. I intended to write the second query this way:
SELECT P.ProductId, P.ProductName, Sum(ID.Quantity) AS Qty
FROM Product AS P
LEFT JOIN InventoryDetail ID
INNER JOIN Inventory I ON ID.InventoryId = I.InventoryId
ON P.ProductId = ID.ProductId AND I.BranchId = @.BranchId
WHERE P.ProductName = @.ProductName
GROUP BY P.ProductId, P.ProductName
Regarding the weird placement of the ON clause, see:
http://groups.google.com/group/micr...br />
2579509b

> Also, I've come up with the following query. Is it correct?
Yes, it is correct. Actually, I think it's identical (in terms of
performance) with my first query, but your query is better because is
more readable. The corrected second query (although it produces an
execution plan with the same cost as the other two), seems to me a bit
slower, because the "Stream Aggregate" step (the GROUP BY clause) is
done on a wider row. Also, it's a lot harder to understand, so that's
why I still think it's the worse among the three queries.
Razvan|||Hi Razvan,
Sorry, I didn't provide the DDL. Now that I know how to do it, I'll
provide it next time.
I'll go on with my query as I already understood it, keeping a copy of
yours if needed.
Thanks a lot
Razvan Socol wrote:
> Hello, Michael
>
>
> Before testing the queries (because I had no DDL and sample data, see:
> http://www.aspfaq.com/etiquette.asp?id=5006), I wrote that the first
> query is better, because the second query seemed unsafe to me. Now that
> I've tested it (by translating it for one of my own schemas), I can say
> that the second query is plain wrong: it doesn't return the expected
> results. I intended to write the second query this way:
> SELECT P.ProductId, P.ProductName, Sum(ID.Quantity) AS Qty
> FROM Product AS P
> LEFT JOIN InventoryDetail ID
> INNER JOIN Inventory I ON ID.InventoryId = I.InventoryId
> ON P.ProductId = ID.ProductId AND I.BranchId = @.BranchId
> WHERE P.ProductName = @.ProductName
> GROUP BY P.ProductId, P.ProductName
> Regarding the weird placement of the ON clause, see:
> http://groups.google.com/group/micr... />
492579509b
>
>
> Yes, it is correct. Actually, I think it's identical (in terms of
> performance) with my first query, but your query is better because is
> more readable. The corrected second query (although it produces an
> execution plan with the same cost as the other two), seems to me a bit
> slower, because the "Stream Aggregate" step (the GROUP BY clause) is
> done on a wider row. Also, it's a lot harder to understand, so that's
> why I still think it's the worse among the three queries.
> Razvan
>|||Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. Sample data is also a good idea, along with clear
specifications. It is very hard to debug code when you do not let us
see it.
Since you also did not give any specs, can I assume that inventory is
spread over branches? Can I assume the product is identified by some
industry standard code, such as a UPC? And why did you create that
useless inventory details table? An inventory is not like an invoice.
CREATE TABLE Products
(upc CHAR(13) NOT NULL PRIMARY KEY, --upc?
product_name CHAR(20) NOT NULL,
.);
CREATE TABLE Branches
(branch_id INTEGER NOT NULL PRIMARY KEY,
.);
CREATE TABLE Inventory
(branch_id INTEGER NOT NULL
REFERENCES Branches(branch_id),
upc CHAR(13) NOT NULL
REFERENCES Products(upc),
PRIMARY KEY (branch_id, upc),
qty_on_hand INTEGER DEFAULT 0 NOT NULL
CHECK (qty_on_hand >= 0)
The right design makes it easy:
SELECT P.upc, SUM(I.qty_on_hand)
FROM Products AS P
LEFT OUTER JOIN
Inventory AS I
ON P.upc= I.upc
GROUP BY P.upc;|||Hi Celko,
I already got an answer from Razvan.
I needed the inventory detail table to hold the different quantities
with their respective notes, such as bin location, qty of damaged items
included in the inventory,...
Now that I know how to post DDL, I'll do it next time. As for the sample
data, I don't have any yet. I'm starting to design the database from
scratch.
Thanks for the help
--CELKO-- wrote:
> Please post DDL, so that people do not have to guess what the keys,
> constraints, Declarative Referential Integrity, data types, etc. in
> your schema are. Sample data is also a good idea, along with clear
> specifications. It is very hard to debug code when you do not let us
> see it.
> Since you also did not give any specs, can I assume that inventory is
> spread over branches? Can I assume the product is identified by some
> industry standard code, such as a UPC? And why did you create that
> useless inventory details table? An inventory is not like an invoice.
> CREATE TABLE Products
> (upc CHAR(13) NOT NULL PRIMARY KEY, --upc?
> product_name CHAR(20) NOT NULL,
> ..);
> CREATE TABLE Branches
> (branch_id INTEGER NOT NULL PRIMARY KEY,
> ..);
> CREATE TABLE Inventory
> (branch_id INTEGER NOT NULL
> REFERENCES Branches(branch_id),
> upc CHAR(13) NOT NULL
> REFERENCES Products(upc),
> PRIMARY KEY (branch_id, upc),
> qty_on_hand INTEGER DEFAULT 0 NOT NULL
> CHECK (qty_on_hand >= 0)
>
>
> The right design makes it easy:
> SELECT P.upc, SUM(I.qty_on_hand)
> FROM Products AS P
> LEFT OUTER JOIN
> Inventory AS I
> ON P.upc= I.upc
> GROUP BY P.upc;
>|||>> I needed the inventory detail table to hold the different quantities with
their respective notes, such as bin location, qty of damaged items included
in the inventory,...<<
That is the usual inventory design; several different quantity
attributes (on-hand, on order, on hold, damaged, expired, etc. Since
these are all distinct attributes of an inventory held at a p[articular
branch, you simply extend the table. That data and the needed check
constraints were not shown in your specs (or lack of specs, really).
There is no need to create a separate inventory_id., which is a poor
attempt at a surrogate for a branch_id. You are splitting the actual
primary key (branch_id, upc) across tables. Ask yourself what meaning
an inventory has apart from the goods it holds. Look at your
pseudo-code; what maps yhour magical "InventoryDetailId" to one and
only one product, and assures that it is the RIGHT product? Nothing.
The split key invites disaster.
Please consider a correct design instead.|||Designing a database is not so simple...
I've already changed my design several times. At first because of a lack
of knowledge in database design (this is actually my first database with
SqlServer, before this was 2 simple databases with MS Access)
If you don't mind I'll really need a help. I'll try to make it as simple
as I can.
Our company has 2 branches (I'll generalise this to several branches).
Products can be stocked in either of these branches.
When counting a product, we need the date of the counting, and the
details (quantity + comments, such as damaged, carton no, bin
location,... which are "free-hand" text note). Note that branches count
their products independently of each other.
So, I came up with these tables:
CREATE TABLE Product (
ProductId BIGINT IDENTITY PRIMARY KEY,
ProductName NVARCHAR(50) NOT NULL,
..
)
CREATE TABLE Branch (
BranchId INT IDENTITY PRIMARY KEY,
BranchName NVARCHAR(50) NOT NULL,
..
)
CREATE TABLE Inventory (
InventoryId BIGINT IDENTITY PRIMARY KEY,
InventoryDate DATETIME NOT NULL,
BranchId INT NOT NULL REFERENCES Branch(BranchId),
..
)
CREATE TABLE InventoryDetail (
InventoryDetailId BIGINT IDENTITY PRIMARY KEY,
InventoryId BIG INT NOT NULL REFERENCES Inventory(InventoryId),
ProductId BIG INT NOT NULL REFERENCES Product(ProductId),
Quantity INT NOT NULL,
Comments NVARCHAR(100) NULL
)
As for sample data, I don't have any yet, but here is what we want:
Lady coat no 634:
Main branch: counted on 14/02/06
- 60 pcs, ctn 123
- 6 pcs, on the shelf (in the shop)
Second branch: counted on 16/02/06
- 3 pcs, on the shelf
Lady pant no 132:
Main branch: counted on 21/02/06
- 2 pcs, a customer has specially ordered these for himself
Lady shoes no 852:
Main branch: counted on 22/02/06
- 12 pcs, in stock shelf no 3
- 12 pcs, waiting to be sent to branch 2
- 2 pcs, in the shop
Second branch: counted on 20/02/06
- 0 pcs, placed the order from Main branch already
--CELKO-- wrote:
>
> That is the usual inventory design; several different quantity
> attributes (on-hand, on order, on hold, damaged, expired, etc. Since
> these are all distinct attributes of an inventory held at a p[articular
> branch, you simply extend the table. That data and the needed check
> constraints were not shown in your specs (or lack of specs, really).
> There is no need to create a separate inventory_id., which is a poor
> attempt at a surrogate for a branch_id. You are splitting the actual
> primary key (branch_id, upc) across tables. Ask yourself what meaning
> an inventory has apart from the goods it holds. Look at your
> pseudo-code; what maps yhour magical "InventoryDetailId" to one and
> only one product, and assures that it is the RIGHT product? Nothing.
> The split key invites disaster.
> Please consider a correct design instead.
>

Product Price Range Query

I've noticed that some search queries on e-commerce sites return "item
price range hyperlinks" as filters for matched items.
So you would have something like:
Under $50 $75-$100 $150-$250
in a row with only the applicable price ranges to the queried products
showing. So, with the above example, if there weren't any products
between $101 and $149, that price range wouldn't show.
I'm wondering about the structure of the SQL for this type of query.
On the surface, I could do multiple queries for each of the price
ranges I needed and union them together, but I'm wondering if there is
a more efficient way to do it in one pass.
Ian<dontspammenow@.yahoo.com> wrote in message
news:1132866827.910562.120930@.g43g2000cwa.googlegroups.com...
> I've noticed that some search queries on e-commerce sites return "item
> price range hyperlinks" as filters for matched items.
> So you would have something like:
> Under $50 $75-$100 $150-$250
> in a row with only the applicable price ranges to the queried products
> showing. So, with the above example, if there weren't any products
> between $101 and $149, that price range wouldn't show.
> I'm wondering about the structure of the SQL for this type of query.
> On the surface, I could do multiple queries for each of the price
> ranges I needed and union them together, but I'm wondering if there is
> a more efficient way to do it in one pass.
> Ian
>
Put your possible price ranges in a table:
CREATE TABLE price_ranges (low_price DECIMAL(10,2) NOT NULL, high_price
DECIMAL (10,2) NOT NULL, CHECK (low_price < high_price), PRIMARY KEY
(low_price, high_price));
INSERT INTO price_ranges (low_price, high_price)
SELECT 1, 50 UNION ALL
SELECT 50, 75 UNION ALL
SELECT 75, 100 UNION ALL
SELECT 100, 150 UNION ALL
SELECT 150, 250 UNION ALL
SELECT 250, 99999999 ;
Now try one of these queries:
SELECT R.low_price, R.high_price
FROM northwind.dbo.products AS P,
price_ranges AS R
WHERE P.unitprice >= R.low_price
AND P.unitprice < R.high_price
/* AND ... ? */
GROUP BY R.low_price, R.high_price ;
SELECT R.low_price, R.high_price
FROM price_ranges AS R
WHERE EXISTS
(SELECT *
FROM northwind.dbo.products AS P
WHERE P.unitprice >= R.low_price
AND P.unitprice < R.high_price
/* AND ... ? */) ;
David Portas
SQL Server MVP
--

Product of a Field

Hi All,

I have a field with numbers (double datatype) as values and I want a aggregate function that gives me the product of all the values in that field. Is there a way to do that in SSRS?

Check this post where I have suggestes a solution.

Shyam

|||

Check this post where I have suggestes a solution.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1384503&SiteID=1

Shyam

sql

Product of a Field

Hi All,

I have a field with numbers (double datatype) as values and I want a aggregate function that gives me the product of all the values in that field. Is there a way to do that in SSRS?

Check this post where I have suggestes a solution.

Shyam

|||

Check this post where I have suggestes a solution.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1384503&SiteID=1

Shyam

Product level is insufficient error

Configuration: Windows XP Pro with SQL 2005 Workgroup Sp2

Hi, we have a package that runs fine in BI Studio but fails with the following error when executing it using DTExec.

Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Derived Column" (10660).

The package imports a CSV into a table mapping some columns. The MSDN article at http://msdn2.microsoft.com/en-us/library/ms143761.aspx describes features supported by different versions.

The article says OLE DB source/destination adapters are supported in WG edition but a couple of lines later seems to imply that all source/destination adapters are not supported in WG.

Could you clarify whether stuff like import of a csv into a table with some column mappings should work in WG edition? Also if we have a legacy SQL 2K package doing the same thing, will that work in WG edition? Thx.

Features/Integration Services Enhancements EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit) SE (32-bit) WG (32-bit) SSE (32-bit) SSEA (32-bit) SE (64-bit)

SQL Server Import and Export Wizard and supporting connections, source and destination adapters, and tasks

Yes

Yes

Yes

No

Yes

Execute SQL Task

Yes

Yes

Yes

No

Yes

OLE DB Source and Destination Adapters

Yes

Yes

Yes

No

Yes

SSIS command prompt tools

Yes

Yes

Yes

No

Yes

SSIS Package Designer

Yes

Yes

Yes

No

Yes

Legacy support for DTS packages

Yes

Yes

Yes

Yes

Yes

SSIS Service

Yes

Yes

No

No

Yes

All other source and destination adapters, tasks, and transformations, except for those listed below

Yes

Yes

No

No

Yes

You might want to be sure that you have actually installed the full SSIS client.|||

As Phil wrote, most likely you've only Workstation components installed and need to install full SSIS.

See Books Online and my blog for details:

http://msdn2.microsoft.com/en-US/library/aa337371.aspx

http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

Product Level is Insufficient

I am receiving the following error when I try to execute an SSIS package that is saved to a structured file. I am using DTExec to execute the package.

Description: The task "Initialize Variables" cannot run on this edition of Integration Services. It requires a higher level edition.

After some research, I was able to find a supporting article in SQL Server 2005 BOL at http://msdn2.microsoft.com/en-us/library/aa337371.aspx

The issue was resolved by installing the Enterprise Edition of SQL Server Integration Services (Windows Service) on the local server (server where the package is saved and executed from). However, this goes against my original anticipation that the SSIS Windows Service would only need to be installed on a machine where I needed to store packages and/or monitor package execution. Not if I wanted to execute packages.

Unfortunately, my package is using advanced options (as identified in the BOL article previously referenced).

Am I missing something?

Sincerely,

Sean Fitzgerald

You are trying to execute these packages from a remote machine (such as your desktop and not the SQL Server), correct? You need to have a matching edition of the SSIS client tools loaded on your desktop to be able to run those packages remotely.|||You do need the SSIS installed where the packages runs.
It does not matter where the package is stored.

See my blog entries about this:
http://blogs.msdn.com/michen/archive/2006/08/11/package-exec-location.aspx
http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

Product Level Insufficient

I am trying to run dtexec on some DTSC packages I created using SSIS. I keep getting the error "The product level is insufficient for the component". Anybody know what this means?

Thanks,

Michael D. Fox

If you do a search of this forum you will find many threads that discuss the usual cause and the usual solution to this problem.

Thanks,

Matt

|||

I did look through the other replies. But I DO have SSIS installed. I am using the evaluation version of SQL Server 2005. Does this have any bearing on it?

Thanks,

Michael D. Fox

|||

Did you actually install SSIS or just the tools (i.e. do you have the SSIS service installed on the box you are trying to run the package on)? If the service is not installed then you will get this message. Which edition is the evaluation version (std, enterprise, etc) and which component is giving you the message (different components are available in different editions)?

Thanks,

Matt

|||

Thanks Matt,

I just went back and reinstalled, checking everything in sight, and it works now.

Thanks again,

Michael D. Fox

sql

Product Key for MSDN - SQL Reporting

We have MSDN CD with SQL Reporting services 2000 on it. However, we do not
have any CD key with it. Also, there is no file in the CD which states the
product key. Where can we get it from?
Thanks in advanceI'm trying to remember but I don't think it has a key with it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Deepti Hait" <Deepti Hait@.discussions.microsoft.com> wrote in message
news:B0619563-472E-467A-B70A-0C31A3A68219@.microsoft.com...
> We have MSDN CD with SQL Reporting services 2000 on it. However, we do not
> have any CD key with it. Also, there is no file in the CD which states the
> product key. Where can we get it from?
> Thanks in advance

Product for Creating Data Dictionary

We have a large SQL Server database that has poorly documented tables and
field names. Is there a product that will create a Word document in table
format from the actual database that can be used to add documentation about
the meaning of each field?
Will
Will
SQL Server 2000 has an option called column description
create table dbo.customer (
customer_id integer not null identity (1, 1)
, trade_name varchar (0255) not null
)
go
alter table dbo.customer add
constraint pk_customer primary key nonclustered (customer_id)
go
/* column description meta info */
execute sp_addextendedproperty N'boolean_property_01', '1', N'user', N'dbo',
N'table', N'customer', N'column', N'trade_name'
execute sp_addextendedproperty N'column_description', 'Customer trading
name', N'user', N'dbo', N'table', N'customer', N'column', N'trade_name'
go
select * from :: fn_listextendedproperty (NULL, 'user', 'dbo', 'table',
'customer', 'column', default)
go
drop table dbo.customer
go
"Will" <DELETE_westes@.earthbroadcast.com> wrote in message
news:OOrsHkGUFHA.3636@.TK2MSFTNGP14.phx.gbl...
> We have a large SQL Server database that has poorly documented tables and
> field names. Is there a product that will create a Word document in
table
> format from the actual database that can be used to add documentation
about
> the meaning of each field?
> --
> Will
>
>

Product for Creating Data Dictionary

We have a large SQL Server database that has poorly documented tables and
field names. Is there a product that will create a Word document in table
format from the actual database that can be used to add documentation about
the meaning of each field?
--
WillWill
SQL Server 2000 has an option called column description
create table dbo.customer (
customer_id integer not null identity (1, 1)
, trade_name varchar (0255) not null
)
go
alter table dbo.customer add
constraint pk_customer primary key nonclustered (customer_id)
go
/* column description meta info */
execute sp_addextendedproperty N'boolean_property_01', '1', N'user', N'dbo',
N'table', N'customer', N'column', N'trade_name'
execute sp_addextendedproperty N'column_description', 'Customer trading
name', N'user', N'dbo', N'table', N'customer', N'column', N'trade_name'
go
select * from :: fn_listextendedproperty (NULL, 'user', 'dbo', 'table',
'customer', 'column', default)
go
drop table dbo.customer
go
"Will" <DELETE_westes@.earthbroadcast.com> wrote in message
news:OOrsHkGUFHA.3636@.TK2MSFTNGP14.phx.gbl...
> We have a large SQL Server database that has poorly documented tables and
> field names. Is there a product that will create a Word document in
table
> format from the actual database that can be used to add documentation
about
> the meaning of each field?
> --
> Will
>
>

Product error installs

I have a couple third part applications that I'm trying to install that
install SQL databases. However I get similar errors during both for the
install.
I'll end up w/ an Error 11001 in the app event log and the contents of the
error common to both is: Error 1001.Setup failed. --> Windows NT user or
group 'NT AUTHORITY\domain users' not found. Check the name again.
Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
name again.
User or role 'NT AUTHORITY\domain users' does not exist in this database.
User or role 'NT AUTHORITY\domain users' does not exist in this database.,
(NULL), (NULL), (NULL).
I've talked to a couple other users and they haven't experienced the same
issues. My server is set to mixed mode and the SA account does have a
password. I've tried installing using the SA account as well as a domain
admin account and neither worked.
Is the NT account you are using to install a member of the local server
Administrator group?
Brad Feaker
Ex nihilo, nihil fit
"Mike" wrote:

> I have a couple third part applications that I'm trying to install that
> install SQL databases. However I get similar errors during both for the
> install.
> I'll end up w/ an Error 11001 in the app event log and the contents of the
> error common to both is: Error 1001.Setup failed. --> Windows NT user or
> group 'NT AUTHORITY\domain users' not found. Check the name again.
> Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> name again.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> (NULL), (NULL), (NULL).
>
> I've talked to a couple other users and they haven't experienced the same
> issues. My server is set to mixed mode and the SA account does have a
> password. I've tried installing using the SA account as well as a domain
> admin account and neither worked.
|||Yes
"Brad Feaker" wrote:
[vbcol=seagreen]
> Is the NT account you are using to install a member of the local server
> Administrator group?
> Brad Feaker
> Ex nihilo, nihil fit
> "Mike" wrote:
|||Try installing using a local system account and then changing the service
accounts after the install is complete.
Brad
"Mike" wrote:
[vbcol=seagreen]
> Yes
> "Brad Feaker" wrote:
|||Tried using the Administrator account on the local machine. Same problem.
"Brad Feaker" wrote:
[vbcol=seagreen]
> Try installing using a local system account and then changing the service
> accounts after the install is complete.
> Brad
> "Mike" wrote:
|||Instead of using a windows account at all, choose the 'Local System Account'
option during the install.
Brad
"Mike" wrote:
[vbcol=seagreen]
> Tried using the Administrator account on the local machine. Same problem.
> "Brad Feaker" wrote:
|||this is an interactive application that i'm trying to install so I'm not sure
there is a way to do what your asking. i'm assuming it comes to this error
some point where it's creating the db in sql. it's funny though the the db
and tables appear to be created fine.
"Brad Feaker" wrote:
[vbcol=seagreen]
> Instead of using a windows account at all, choose the 'Local System Account'
> option during the install.
> Brad
> "Mike" wrote:
|||At this point you may want to toss the problem back to the vendor....sorry I
could not be of any assistance...
Brad
"Mike" wrote:
[vbcol=seagreen]
> this is an interactive application that i'm trying to install so I'm not sure
> there is a way to do what your asking. i'm assuming it comes to this error
> some point where it's creating the db in sql. it's funny though the the db
> and tables appear to be created fine.
> "Brad Feaker" wrote:
|||Thanks. I did so Monday. I believe they're stumped.
"Brad Feaker" wrote:
[vbcol=seagreen]
> At this point you may want to toss the problem back to the vendor....sorry I
> could not be of any assistance...
> Brad
> "Mike" wrote:

Product error installs

I have a couple third part applications that I'm trying to install that
install SQL databases. However I get similar errors during both for the
install.
I'll end up w/ an Error 11001 in the app event log and the contents of the
error common to both is: Error 1001.Setup failed. --> Windows NT user or
group 'NT AUTHORITY\domain users' not found. Check the name again.
Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
name again.
User or role 'NT AUTHORITY\domain users' does not exist in this database.
User or role 'NT AUTHORITY\domain users' does not exist in this database.,
(NULL), (NULL), (NULL).
I've talked to a couple other users and they haven't experienced the same
issues. My server is set to mixed mode and the SA account does have a
password. I've tried installing using the SA account as well as a domain
admin account and neither worked.Is the NT account you are using to install a member of the local server
Administrator group?
Brad Feaker
Ex nihilo, nihil fit
"Mike" wrote:
> I have a couple third part applications that I'm trying to install that
> install SQL databases. However I get similar errors during both for the
> install.
> I'll end up w/ an Error 11001 in the app event log and the contents of the
> error common to both is: Error 1001.Setup failed. --> Windows NT user or
> group 'NT AUTHORITY\domain users' not found. Check the name again.
> Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> name again.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> (NULL), (NULL), (NULL).
>
> I've talked to a couple other users and they haven't experienced the same
> issues. My server is set to mixed mode and the SA account does have a
> password. I've tried installing using the SA account as well as a domain
> admin account and neither worked.|||Yes
"Brad Feaker" wrote:
> Is the NT account you are using to install a member of the local server
> Administrator group?
> Brad Feaker
> Ex nihilo, nihil fit
> "Mike" wrote:
> > I have a couple third part applications that I'm trying to install that
> > install SQL databases. However I get similar errors during both for the
> > install.
> >
> > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > name again.
> > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > (NULL), (NULL), (NULL).
> >
> >
> > I've talked to a couple other users and they haven't experienced the same
> > issues. My server is set to mixed mode and the SA account does have a
> > password. I've tried installing using the SA account as well as a domain
> > admin account and neither worked.|||Try installing using a local system account and then changing the service
accounts after the install is complete.
Brad
"Mike" wrote:
> Yes
> "Brad Feaker" wrote:
> > Is the NT account you are using to install a member of the local server
> > Administrator group?
> >
> > Brad Feaker
> > Ex nihilo, nihil fit
> >
> > "Mike" wrote:
> >
> > > I have a couple third part applications that I'm trying to install that
> > > install SQL databases. However I get similar errors during both for the
> > > install.
> > >
> > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > name again.
> > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > (NULL), (NULL), (NULL).
> > >
> > >
> > > I've talked to a couple other users and they haven't experienced the same
> > > issues. My server is set to mixed mode and the SA account does have a
> > > password. I've tried installing using the SA account as well as a domain
> > > admin account and neither worked.|||Tried using the Administrator account on the local machine. Same problem.
"Brad Feaker" wrote:
> Try installing using a local system account and then changing the service
> accounts after the install is complete.
> Brad
> "Mike" wrote:
> > Yes
> >
> > "Brad Feaker" wrote:
> >
> > > Is the NT account you are using to install a member of the local server
> > > Administrator group?
> > >
> > > Brad Feaker
> > > Ex nihilo, nihil fit
> > >
> > > "Mike" wrote:
> > >
> > > > I have a couple third part applications that I'm trying to install that
> > > > install SQL databases. However I get similar errors during both for the
> > > > install.
> > > >
> > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > name again.
> > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > (NULL), (NULL), (NULL).
> > > >
> > > >
> > > > I've talked to a couple other users and they haven't experienced the same
> > > > issues. My server is set to mixed mode and the SA account does have a
> > > > password. I've tried installing using the SA account as well as a domain
> > > > admin account and neither worked.|||Instead of using a windows account at all, choose the 'Local System Account'
option during the install.
Brad
"Mike" wrote:
> Tried using the Administrator account on the local machine. Same problem.
> "Brad Feaker" wrote:
> > Try installing using a local system account and then changing the service
> > accounts after the install is complete.
> >
> > Brad
> >
> > "Mike" wrote:
> >
> > > Yes
> > >
> > > "Brad Feaker" wrote:
> > >
> > > > Is the NT account you are using to install a member of the local server
> > > > Administrator group?
> > > >
> > > > Brad Feaker
> > > > Ex nihilo, nihil fit
> > > >
> > > > "Mike" wrote:
> > > >
> > > > > I have a couple third part applications that I'm trying to install that
> > > > > install SQL databases. However I get similar errors during both for the
> > > > > install.
> > > > >
> > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > name again.
> > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > (NULL), (NULL), (NULL).
> > > > >
> > > > >
> > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > password. I've tried installing using the SA account as well as a domain
> > > > > admin account and neither worked.|||this is an interactive application that i'm trying to install so I'm not sure
there is a way to do what your asking. i'm assuming it comes to this error
some point where it's creating the db in sql. it's funny though the the db
and tables appear to be created fine.
"Brad Feaker" wrote:
> Instead of using a windows account at all, choose the 'Local System Account'
> option during the install.
> Brad
> "Mike" wrote:
> > Tried using the Administrator account on the local machine. Same problem.
> >
> > "Brad Feaker" wrote:
> >
> > > Try installing using a local system account and then changing the service
> > > accounts after the install is complete.
> > >
> > > Brad
> > >
> > > "Mike" wrote:
> > >
> > > > Yes
> > > >
> > > > "Brad Feaker" wrote:
> > > >
> > > > > Is the NT account you are using to install a member of the local server
> > > > > Administrator group?
> > > > >
> > > > > Brad Feaker
> > > > > Ex nihilo, nihil fit
> > > > >
> > > > > "Mike" wrote:
> > > > >
> > > > > > I have a couple third part applications that I'm trying to install that
> > > > > > install SQL databases. However I get similar errors during both for the
> > > > > > install.
> > > > > >
> > > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > > name again.
> > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > > (NULL), (NULL), (NULL).
> > > > > >
> > > > > >
> > > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > > password. I've tried installing using the SA account as well as a domain
> > > > > > admin account and neither worked.|||At this point you may want to toss the problem back to the vendor....sorry I
could not be of any assistance...
Brad
"Mike" wrote:
> this is an interactive application that i'm trying to install so I'm not sure
> there is a way to do what your asking. i'm assuming it comes to this error
> some point where it's creating the db in sql. it's funny though the the db
> and tables appear to be created fine.
> "Brad Feaker" wrote:
> > Instead of using a windows account at all, choose the 'Local System Account'
> > option during the install.
> >
> > Brad
> >
> > "Mike" wrote:
> >
> > > Tried using the Administrator account on the local machine. Same problem.
> > >
> > > "Brad Feaker" wrote:
> > >
> > > > Try installing using a local system account and then changing the service
> > > > accounts after the install is complete.
> > > >
> > > > Brad
> > > >
> > > > "Mike" wrote:
> > > >
> > > > > Yes
> > > > >
> > > > > "Brad Feaker" wrote:
> > > > >
> > > > > > Is the NT account you are using to install a member of the local server
> > > > > > Administrator group?
> > > > > >
> > > > > > Brad Feaker
> > > > > > Ex nihilo, nihil fit
> > > > > >
> > > > > > "Mike" wrote:
> > > > > >
> > > > > > > I have a couple third part applications that I'm trying to install that
> > > > > > > install SQL databases. However I get similar errors during both for the
> > > > > > > install.
> > > > > > >
> > > > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > > > name again.
> > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > > > (NULL), (NULL), (NULL).
> > > > > > >
> > > > > > >
> > > > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > > > password. I've tried installing using the SA account as well as a domain
> > > > > > > admin account and neither worked.|||Thanks. I did so Monday. I believe they're stumped.
"Brad Feaker" wrote:
> At this point you may want to toss the problem back to the vendor....sorry I
> could not be of any assistance...
> Brad
> "Mike" wrote:
> > this is an interactive application that i'm trying to install so I'm not sure
> > there is a way to do what your asking. i'm assuming it comes to this error
> > some point where it's creating the db in sql. it's funny though the the db
> > and tables appear to be created fine.
> >
> > "Brad Feaker" wrote:
> >
> > > Instead of using a windows account at all, choose the 'Local System Account'
> > > option during the install.
> > >
> > > Brad
> > >
> > > "Mike" wrote:
> > >
> > > > Tried using the Administrator account on the local machine. Same problem.
> > > >
> > > > "Brad Feaker" wrote:
> > > >
> > > > > Try installing using a local system account and then changing the service
> > > > > accounts after the install is complete.
> > > > >
> > > > > Brad
> > > > >
> > > > > "Mike" wrote:
> > > > >
> > > > > > Yes
> > > > > >
> > > > > > "Brad Feaker" wrote:
> > > > > >
> > > > > > > Is the NT account you are using to install a member of the local server
> > > > > > > Administrator group?
> > > > > > >
> > > > > > > Brad Feaker
> > > > > > > Ex nihilo, nihil fit
> > > > > > >
> > > > > > > "Mike" wrote:
> > > > > > >
> > > > > > > > I have a couple third part applications that I'm trying to install that
> > > > > > > > install SQL databases. However I get similar errors during both for the
> > > > > > > > install.
> > > > > > > >
> > > > > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > > > > name again.
> > > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > > > > (NULL), (NULL), (NULL).
> > > > > > > >
> > > > > > > >
> > > > > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > > > > password. I've tried installing using the SA account as well as a domain
> > > > > > > > admin account and neither worked.sql

Product error installs

I have a couple third part applications that I'm trying to install that
install SQL databases. However I get similar errors during both for the
install.
I'll end up w/ an Error 11001 in the app event log and the contents of the
error common to both is: Error 1001.Setup failed. --> Windows NT user or
group 'NT AUTHORITY\domain users' not found. Check the name again.
Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
name again.
User or role 'NT AUTHORITY\domain users' does not exist in this database.
User or role 'NT AUTHORITY\domain users' does not exist in this database.,
(NULL), (NULL), (NULL).
I've talked to a couple other users and they haven't experienced the same
issues. My server is set to mixed mode and the SA account does have a
password. I've tried installing using the SA account as well as a domain
admin account and neither worked.Is the NT account you are using to install a member of the local server
Administrator group?
Brad Feaker
Ex nihilo, nihil fit
"Mike" wrote:

> I have a couple third part applications that I'm trying to install that
> install SQL databases. However I get similar errors during both for the
> install.
> I'll end up w/ an Error 11001 in the app event log and the contents of the
> error common to both is: Error 1001.Setup failed. --> Windows NT user or
> group 'NT AUTHORITY\domain users' not found. Check the name again.
> Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> name again.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> (NULL), (NULL), (NULL).
>
> I've talked to a couple other users and they haven't experienced the same
> issues. My server is set to mixed mode and the SA account does have a
> password. I've tried installing using the SA account as well as a domain
> admin account and neither worked.|||Yes
"Brad Feaker" wrote:
[vbcol=seagreen]
> Is the NT account you are using to install a member of the local server
> Administrator group?
> Brad Feaker
> Ex nihilo, nihil fit
> "Mike" wrote:
>|||Try installing using a local system account and then changing the service
accounts after the install is complete.
Brad
"Mike" wrote:
[vbcol=seagreen]
> Yes
> "Brad Feaker" wrote:
>|||Tried using the Administrator account on the local machine. Same problem.
"Brad Feaker" wrote:
[vbcol=seagreen]
> Try installing using a local system account and then changing the service
> accounts after the install is complete.
> Brad
> "Mike" wrote:
>|||Instead of using a windows account at all, choose the 'Local System Account'
option during the install.
Brad
"Mike" wrote:
[vbcol=seagreen]
> Tried using the Administrator account on the local machine. Same problem.
> "Brad Feaker" wrote:
>|||this is an interactive application that i'm trying to install so I'm not sur
e
there is a way to do what your asking. i'm assuming it comes to this error
some point where it's creating the db in sql. it's funny though the the db
and tables appear to be created fine.
"Brad Feaker" wrote:
[vbcol=seagreen]
> Instead of using a windows account at all, choose the 'Local System Accoun
t'
> option during the install.
> Brad
> "Mike" wrote:
>|||At this point you may want to toss the problem back to the vendor....sorry
I
could not be of any assistance...
Brad
"Mike" wrote:
[vbcol=seagreen]
> this is an interactive application that i'm trying to install so I'm not s
ure
> there is a way to do what your asking. i'm assuming it comes to this erro
r
> some point where it's creating the db in sql. it's funny though the the d
b
> and tables appear to be created fine.
> "Brad Feaker" wrote:
>|||Thanks. I did so Monday. I believe they're stumped.
"Brad Feaker" wrote:
[vbcol=seagreen]
> At this point you may want to toss the problem back to the vendor....sorr
y I
> could not be of any assistance...
> Brad
> "Mike" wrote:
>

Product Dimensions

I have several items and the business views these items according to a number of attributes linked to the item:
- Product category
- Product source (manufactured, purchased, transferred)
- Brand
- Flavour
- Packing Group

The Packing Group is a combination of attributes which defines the size of a pack (bottle size, cap type, things like that). There is never a set hierarchy as to how these are viewed. I've thought about modelling items as:
1. Create a star-schema dimension which has Product category then Product, and have a bunch of attributes hanging off Product
2. Create virtual dimensions based on these attributes

However, this seems problematic to me as the Packing Group has its own attributes. I then consider I might need a "physical" star-schema dimension for each of the above classifications. Is this the right way to go? Can any body suggest a better way or point me to some examples? I'm running AS 2000.

Upgrade to 2005

The last time I did this in AS 2000, I was representing customer demographics - race, gender, age range, income range, etc), I created a physical dimension table in my star to represent each unique combination of attributes. then I created an AS dimension for each attribute. Performance was pretty poor.

Product Dimension

I have a parent-child product dimension.
It is parent-child because it is unbalanced - some products have more
levels than others.
This dimension has the product members for the entire Group.
However, because different products have different relevant dimensions
I have a number of cubes - i.e. I don't want to put all measures & all
dimensions of all products into just one cube.
If I were to use this product dimension in all cubes I have two
problems:
1. The end user sees numerous 'irrelevant' product members when
exploring the dimension
2. More seriously, because the seperate cubes will only have facts for
the appropriate products the aggregation up to 'All' (Group) will be
misleading.
It would seem that I should have a centrally maintained product table &
from this create a number of subset product dimensions.
Is this the best approach?
Many thanks.Why don't try perspective for your first requirement to show different
product for different user.
I don't think No.2 is a real issue, for fact records are linked to their
product in the star schema tables.
"Statsman" wrote:

> I have a parent-child product dimension.
> It is parent-child because it is unbalanced - some products have more
> levels than others.
> This dimension has the product members for the entire Group.
> However, because different products have different relevant dimensions
> I have a number of cubes - i.e. I don't want to put all measures & all
> dimensions of all products into just one cube.
> If I were to use this product dimension in all cubes I have two
> problems:
> 1. The end user sees numerous 'irrelevant' product members when
> exploring the dimension
> 2. More seriously, because the seperate cubes will only have facts for
> the appropriate products the aggregation up to 'All' (Group) will be
> misleading.
> It would seem that I should have a centrally maintained product table &
> from this create a number of subset product dimensions.
>
> Is this the best approach?
>
> Many thanks.
>|||Why don't try perspective for your first requirement to show different
product for different user.
I don't think No.2 is a real issue, for fact records are linked to their
product in the star schema tables.
"Statsman" wrote:

> I have a parent-child product dimension.
> It is parent-child because it is unbalanced - some products have more
> levels than others.
> This dimension has the product members for the entire Group.
> However, because different products have different relevant dimensions
> I have a number of cubes - i.e. I don't want to put all measures & all
> dimensions of all products into just one cube.
> If I were to use this product dimension in all cubes I have two
> problems:
> 1. The end user sees numerous 'irrelevant' product members when
> exploring the dimension
> 2. More seriously, because the seperate cubes will only have facts for
> the appropriate products the aggregation up to 'All' (Group) will be
> misleading.
> It would seem that I should have a centrally maintained product table &
> from this create a number of subset product dimensions.
>
> Is this the best approach?
>
> Many thanks.
>