Do I need to change my name to post here? (Should cause some amusement!)

On 22/12 I made a couple of posts to this group. On topic, with a couple of
helpful replies from Hilary C/ Paul I.
Now they appear to be gone!
Now I've noticed this before and didn't really think much of it, but now I'm
suspicious I may be being silenced for my surname. If so who is responsible?
Their zeal in keeping this group drug free is commendable but if I'm to be
forever labelled as spam, it would be nice to know.
Tony Toker
(who has never touched the stuff)
In Outlook Express, go to View, Current View, and make sure that Show All
Messages is selected. This might be your problem.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Tony Toker" <xyzzy@.identic.co.uk> wrote in message
news:cqs5fn$sk2$1$830fa7a5@.news.demon.co.uk...
> On 22/12 I made a couple of posts to this group. On topic, with a couple
of
> helpful replies from Hilary C/ Paul I.
> Now they appear to be gone!
> Now I've noticed this before and didn't really think much of it, but now
I'm
> suspicious I may be being silenced for my surname. If so who is
responsible?
> Their zeal in keeping this group drug free is commendable but if I'm to be
> forever labelled as spam, it would be nice to know.
> Tony Toker
> (who has never touched the stuff)
>
>
|||Tony,
just to confirm they're still there, these are your replication posts:
http://groups-beta.google.com/group/...art=0&filter=0
Rgds,
Paul Ibison
|||Thanks guys, found the problem after trying another news client.
in Outlook Express Tools-Options-Maintenance
'Delete new messages 5 days after being downloaded'
This was making me paranoid!
TT
"Tony Toker" <xyzzy@.identic.co.uk> wrote in message
news:cqs5fn$sk2$1$830fa7a5@.news.demon.co.uk...
> On 22/12 I made a couple of posts to this group. On topic, with a couple
of
> helpful replies from Hilary C/ Paul I.
> Now they appear to be gone!
> Now I've noticed this before and didn't really think much of it, but now
I'm
> suspicious I may be being silenced for my surname. If so who is
responsible?
> Their zeal in keeping this group drug free is commendable but if I'm to be
> forever labelled as spam, it would be nice to know.
> Tony Toker
> (who has never touched the stuff)
>
>
|||Tony, just because you are paranoid doesn't mean they are not out to get
you. <g>
"Tony Toker" <xyzzy@.identic.co.uk> wrote in message
news:cqu7lr$2id$1$830fa79d@.news.demon.co.uk...[vbcol=seagreen]
> Thanks guys, found the problem after trying another news client.
> in Outlook Express Tools-Options-Maintenance
> 'Delete new messages 5 days after being downloaded'
> This was making me paranoid!
> TT
>
>
> "Tony Toker" <xyzzy@.identic.co.uk> wrote in message
> news:cqs5fn$sk2$1$830fa7a5@.news.demon.co.uk...
couple[vbcol=seagreen]
> of
> I'm
> responsible?
be
>

DMX Query, Group by

I'm having some problem with this DMX prediction query. This is the first time I'm trying out the GROUP BY statement in the DMX query and I keep getting "Parse: the statement dialect could not be resolved due to ambiguity." message.

Is Group By supported by the DMX? What am I missing? If not supported, could I insert the result into a temporary table using SELECT ... INTO.. FROM and run a group by on a temporary table?

This is what the DMX query looks like...

SELECT
t.[AgeGroupName],
t.[ChildrenStatusName],
t.[EducationName],
Sum(t.[Profit]) as Profit
From
[Revenue Estimate DT]
PREDICTION JOIN
OPENQUERY([DM Reports DM],
'SELECT
[AgeGroupName],
[ChildrenStatusName],
[EducationName],
[Profit],
[IncomeName],
[HomeOwnerName],
[SexName],
[Country],
[ProductTypeCode],
[ProductName],
[MailCount],
[OrderAmount],
[SalesAmount],
[MailCost]
FROM
(SELECT AgeGroupName, ChildrenStatusName, EducationName, IncomeName, HomeOwnerName, MaritalStatusName, SexName, JobName, JobTypeCode,
CompanyTypeCode, Country, ProductTypeCode, ProductName, SUM(MailCount) AS MailCount, SUM(OrderAmount) AS OrderAmount, SUM(SalesAmount)
AS SalesAmount, SUM(MailCost) AS MailCost, SUM(Profit) AS Profit, MIN(RevenueEstimateID) AS ReKey
FROM [DataMining.RevenueEstimate.Predict]
GROUP BY AgeGroupName, ChildrenStatusName, EducationName, IncomeName, HomeOwnerName, MaritalStatusName, SexName, JobName, JobTypeCode,
CompanyTypeCode, Country, ProductTypeCode, ProductName, ClientID
HAVING (ClientID = 1)) as [Prediction]
') AS t
ON
[Revenue Estimate DT].[Age Group Name] = t.[AgeGroupName] AND
[Revenue Estimate DT].[Education Name] = t.[EducationName] AND
[Revenue Estimate DT].[Income Name] = t.[IncomeName] AND
[Revenue Estimate DT].[Home Owner Name] = t.[HomeOwnerName] AND
[Revenue Estimate DT].[Sex Name] = t.[SexName] AND
[Revenue Estimate DT].[Country] = t.[Country] AND
[Revenue Estimate DT].[Product Type Code] = t.[ProductTypeCode] AND
[Revenue Estimate DT].[Product Name] = t.[ProductName] AND
[Revenue Estimate DT].[Mail Count] = t.[MailCount] AND
[Revenue Estimate DT].[Order Amount] = t.[OrderAmount] AND
[Revenue Estimate DT].[Sales Amount] = t.[SalesAmount] AND
[Revenue Estimate DT].[Mail Cost] = t.[MailCost] AND
[Revenue Estimate DT].[Profit] = t.[Profit] AND
[Revenue Estimate DT].[Children Status Name] = t.[ChildrenStatusName]
GROUP BY t.[AgeGroupName],
t.[ChildrenStatusName],
t.[EducationName]

Hello

GROUP BY is not supported in DMX, and neither are temporary tables. A solution would be to execute the query, store the results inside SQL Server, then execute the group by inside the relational engine.

You can find some details on executing predictions from the relational engine in this article: http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3914.aspx

|||Or you could do as Bogdan suggests without storing the results and performing SQL operations on an OPENROWSET DMX query result

DMO Programming

Hello All,
I'm learning SQL-DMO programming via VBScript and I'm new to VBScript
programming as well. Would anyone know
of a News Group exclusively for DMO programming ?
Thanks,
GopiAFAIK, there are no newsgroups. However, you might find some resources here
at: http://www.sqldev.net/sqldmo.htm
Anith|||You might want to know that DMO is "dead" as of SQL Server 2005. It will be
there, but at the 2000
level (new functionality for 2005 will not be exposed in DMO). The successor
of DMO is called SMO.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"rgn" <gopinathr@.healthasyst.com> wrote in message news:uOqqXX4vFHA.2132@.TK2MSFTNGP15.phx.g
bl...
> Hello All,
> I'm learning SQL-DMO programming via VBScript and I'm new to VBScript prog
ramming as well. Would
> anyone know
> of a News Group exclusively for DMO programming ?
> Thanks,
> Gopi
>|||Hello Tibor,
I saw the SQLServer 2005 CTP CD (DVD ?) in the office today and I will look
at it tomorrow in the office (I'm at home now).
I was going through the following link
"http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx" and I
was wondering :
[1] If the CTP CD contains Express Edition also.
[2] And which of these editions will I be able to install (I mean the
Database engine and not just the Client Side Tools)
in my XP Professional Workstation at the office.
Thanks for your suggestion :)
Gopi
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uwIZLt4vFHA.2556@.TK2MSFTNGP15.phx.gbl...
> You might want to know that DMO is "dead" as of SQL Server 2005. It will
> be there, but at the 2000 level (new functionality for 2005 will not be
> exposed in DMO). The successor of DMO is called SMO.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "rgn" <gopinathr@.healthasyst.com> wrote in message
> news:uOqqXX4vFHA.2132@.TK2MSFTNGP15.phx.gbl...
>|||Tibor,
I think I found what I was looking for with respect to the "System
Requirements" from the following link.
http://download.microsoft.com/downl...sSQLEXP2005.htm
However, I'm not sure if the CD contains the Express Edition as well
Gopi
"gopi" <rgopinath@.hotmail.com> wrote in message
news:%23XJG2f6vFHA.724@.TK2MSFTNGP14.phx.gbl...
> Hello Tibor,
> I saw the SQLServer 2005 CTP CD (DVD ?) in the office today and I will
> look at it tomorrow in the office (I'm at home now).
> I was going through the following link
> "http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx" and I
> was wondering :
> [1] If the CTP CD contains Express Edition also.
> [2] And which of these editions will I be able to install (I mean the
> Database engine and not just the Client Side Tools)
> in my XP Professional Workstation at the office.
> Thanks for your suggestion :)
> Gopi
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:uwIZLt4vFHA.2556@.TK2MSFTNGP15.phx.gbl...
>|||> However, I'm not sure if the CD contains the Express Edition as well
I'm sorry, I don't know that, since I don't have that CD. You might want to
post this on the beta
newsgroups...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"gopi" <rgopinath@.hotmail.com> wrote in message news:eYeK4l6vFHA.3688@.tk2msftngp13.phx.gbl.
.
> Tibor,
> I think I found what I was looking for with respect to the "System Require
ments" from the
> following link.
> http://download.microsoft.com/downl...sSQLEXP2005.htm
> However, I'm not sure if the CD contains the Express Edition as well
> Gopi
> "gopi" <rgopinath@.hotmail.com> wrote in message news:%23XJG2f6vFHA.724@.TK2
MSFTNGP14.phx.gbl...
>

Dividing the group in sections

I have a group with 3 distinct field values. I'm only interested in
seeing the specific details for one of them and lump the rest into the
"Others" category and viewing the same details but for that category as
a whole.
This is done in Crystal Reports in the Change Group Options dialog. Is
there something comparable to that in SSRS?
Thank you in advance for any assistance.I believe you can do such grouping with Reporting Services, but it may
be better to modify your data source so that you have an additional
field returned, one where the value is either the field value that you
are interested in or the word 'Other' for all other values.
In SQL Server you can do this by including a CASE statement for that
field within the overall SELECT statement.
This may run faster on the server side, as well, and it simplifies
report design.
I try to do as much as possible on the server side, so that report
design and layout are as simple as possible.
tantilis wrote:
> I have a group with 3 distinct field values. I'm only interested in
> seeing the specific details for one of them and lump the rest into the
> "Others" category and viewing the same details but for that category as
> a whole.
> This is done in Crystal Reports in the Change Group Options dialog. Is
> there something comparable to that in SSRS?
> Thank you in advance for any assistance.|||Thank you for your reply and your solution is practical however I don't
have that kind of access to the server. It's a constraint of this
project that I must replicate the Crystal report without manipulating
any stored procedures.
Parker wrote:
> I believe you can do such grouping with Reporting Services, but it may
> be better to modify your data source so that you have an additional
> field returned, one where the value is either the field value that you
> are interested in or the word 'Other' for all other values.
> In SQL Server you can do this by including a CASE statement for that
> field within the overall SELECT statement.
> This may run faster on the server side, as well, and it simplifies
> report design.
> I try to do as much as possible on the server side, so that report
> design and layout are as simple as possible.
> tantilis wrote:
> > I have a group with 3 distinct field values. I'm only interested in
> > seeing the specific details for one of them and lump the rest into the
> > "Others" category and viewing the same details but for that category as
> > a whole.
> >
> > This is done in Crystal Reports in the Change Group Options dialog. Is
> > there something comparable to that in SSRS?
> >
> > Thank you in advance for any assistance.|||i remember a report where i had to break up a group each time the last
two digits of a certain field hit either 49 or 99. the way i wound up
doing it was to add a second expression, in addition to the primary
condition, to the group expression. you might play around with this
possibility?|||I think I may have worked it out doing just that. I've changed my
primary grouping expression to look like this:
=iif(Fields!Some_Value.Value ="SomeString",Fields!Some_Value.Value,nothing)
It seems a bit counter-intuitive but in a dozen tests so far I'm seeing
values I'm expecting to see in the "Others" category.
What the report would do under this condition is first, present the
group of everything for which SomeString was true using SomeString in
the group header. The report would then present the rest of the data
in a single group while displaying only the first value of Some_Value
in alphabetic order. Just used an expression at that point to replace
every Some_Value.Value to "Others" where it wasn't SomeString.
kjward wrote:
> i remember a report where i had to break up a group each time the last
> two digits of a certain field hit either 49 or 99. the way i wound up
> doing it was to add a second expression, in addition to the primary
> condition, to the group expression. you might play around with this
> possibility?

Distributed Transaction Over TCP/IP

I don't know to which discussion group this question is relevant, so I'll as
k
here.
I have two SQL Server servers A and B that are not on the same network. They
are both Windows Server 2003 servers. They communicate only using TCP/IP.
Using Query Analyzer, I connect to A and execute the following SQL statement
to add B as a linked server:
sp_addlinkedserver 'MyServerB.MyDomain.com'
This works fine and B is added as a linked server to A. I then execute the
following SQL statement:
select * from [MyServerB.MyDomain.com].[MyDatabase].[Dbo].[MyTable]
This too works fine and I get a list of the rows in the specified table.
Then I execute the following SQL statements:
begin transaction
select * from [MyServerB.MyDomain.com].[MyDatabase].[Dbo].[Mytable]
And after a minute or two I receive the following error:
Server: Msg 7391, Level 16, State 1, Line 1
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction. [OLE/DB provider returned
message: New transaction cannot enlist in the specified transaction
coordinator. ] OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
I have tried executing 'begin distributed transaction' instead of 'begin
transaction'. That doesn't help.
The Distributed Transaction Coordinator is running on both servers.
TurnOffRpcSecurity is set to 1 on both servers. Both servers have SQL Server
SP4 (version 8.00.2039).
I cannot figure out what to do to be able to perform a distributed
transaction between these two machines. Any assistance on this issue would b
e
greatly appreciated!
Corey Young
Software Engineer
LANDesk SoftwareI had this same problem a few months ago, and the following support
article helped me resolve it:
http://support.microsoft.com/defaul...kb;en-us;839279
Stu|||Thanks for the quick response!
I have gone through the steps outlined on that web page with no success. Any
other ideas?
Corey Young
Software Engineer
LANDesk Software
"Stu" wrote:

> I had this same problem a few months ago, and the following support
> article helped me resolve it:
> http://support.microsoft.com/defaul...kb;en-us;839279
> Stu
>|||I found the problem!
I had to go to Local Security Settings, IP Security Policies on Local
Computer, Packet Filter, and uncheck Block All. I suspect this makes the
server much more vulnerable to attacks, but it wasn't working with Block All
checked even if I had a "permit" on port 135.
Anyway, at least now I have something working and can go from there to lock
things down more tightly.
Corey Young
Software Engineer
LANDesk Software
"Stu" wrote:

> I had this same problem a few months ago, and the following support
> article helped me resolve it:
> http://support.microsoft.com/defaul...kb;en-us;839279
> Stu
>|||"Young, Corey" <YoungCorey@.discussions.microsoft.com> wrote in message
news:7603CD79-0C56-4BF4-A301-3BB9CB4F8365@.microsoft.com...
> Thanks for the quick response!
> I have gone through the steps outlined on that web page with no success.
> Any
> other ideas?
> --
> Corey Young
> Software Engineer
> LANDesk Software
>
> "Stu" wrote:
>|||I too have got the same problem. I have run all the steps said in msdn.
microsoft.com. Still i'm getting the same error.Young, Corey, Can u explain
where to change the security settings you have told. Please reply me.Its
urgent.