Microsoft DST Webcast Starting in 30 Minutes

There is a free Microsoft Webcast on Daylight Saving Time starting at 2:00pm
today PST (30 minutes from now). Please see the information below if you
would like to attend.
Click the meeting URL:
https://www.livemeeting.com/cc/lmevents/join?d=msft092407sa&role=attend&pw=ATN783
or
If you can't click the above meeting URL, click the following link:
https://www.livemeeting.com/cc/lmevents.
When you click on either URL, the Join Meeting page appears. In the
following fields, verify or enter this information:
Name: (Enter your first and last name)
Meeting ID: msft092407sa
Meeting Key: ATN783
More information on DST Webcasts:
http://support.microsoft.com/gp/dst_webcasts.
--
Regards,
Scott Schnoll
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no
rights. Please do not send email directly to this alias. This alias is for
newsgroup purposes only.Sorry for the spam, but I should be 2:00pm PDT, not PST.
"Scott Schnoll [MSFT]" <scschnol@.online.microsoft.com> wrote in message
news:OPs1Vou$HHA.2268@.TK2MSFTNGP02.phx.gbl...
> There is a free Microsoft Webcast on Daylight Saving Time starting at
> 2:00pm today PST (30 minutes from now). Please see the information below
> if you would like to attend.
> Click the meeting URL:
> https://www.livemeeting.com/cc/lmevents/join?d=msft092407sa&role=attend&pw=ATN783
> or
> If you can't click the above meeting URL, click the following link:
> https://www.livemeeting.com/cc/lmevents.
> When you click on either URL, the Join Meeting page appears. In the
> following fields, verify or enter this information:
> Name: (Enter your first and last name)
> Meeting ID: msft092407sa
> Meeting Key: ATN783
> More information on DST Webcasts:
> http://support.microsoft.com/gp/dst_webcasts.
> --
> Regards,
> Scott Schnoll
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
> rights. Please do not send email directly to this alias. This alias is for
> newsgroup purposes only.
>sql

Microsoft decision tree

I have an example case below :

Customer Id

Debt Level

Income Level

Employment Type

Credit Risk

1

High

High

Self-Employed

Bad

2

High

High

Salaried

Bad

3

High

Low

Salaried

Bad

4

Low

Low

Salaried

Good

5

Low

Low

Self-Emplyed

Bad

6

Low

High

Self-Employed

Good

7

Low

High

Salaried

Good

My question is how to make a tree from the case above I mean what method we should use to split the tree. (Mannually counting)

I hope anyone could help me by explaining i details.Because i want to make some analysis how microsoft decision tree works exactly.So Please explain me the process to build the tree completely with the method.

Thanks a lot.

Please clarify your question. I'm not sure what you are asking for- you want the equations used to determine a split?|||I'm so sorry because of confusing question. Yes what i mean is equations used to determine a split. Would you explain it detail for me? Because i 've made a thesis about microsoft decision tree analysis so i need to know how microsoft decision tree work exactly.
thank you so much|||

This article explains how the Microsoft Decision Tree algorithm works at a high level and also points to the relevant research papers that the implementation is based on: http://msdn2.microsoft.com/en-us/library/ms175312(SQL.90,d=ide).aspx

Microsoft decision tree

Hi again ....i'm trying to understand the works of microsoft decision tree algorithm

I have an example case below :

Customer Id

Debt Level

Income Level

Employment Type

Credit Risk

1

High

High

Self-Employed

Bad

2

High

High

Salaried

Bad

3

High

Low

Salaried

Bad

4

Low

Low

Salaried

Good

5

Low

Low

Self-Emplyed

Bad

6

Low

High

Self-Employed

Good

7

Low

High

Salaried

Good

My question is how about the equations used to determine a split?

Please explain me detailed.

Thanks a lot.

This article explains how the Microsoft Decision Tree algorithm works at a high level and also points to the relevant research papers that the implementation is based on:http://msdn2.microsoft.com/en-us/library/ms175312(SQL.90,d=ide).aspx

Method EnumDatabaseMapping on Login SMO object takes 3 minutes

Hi,

The EnumDatabaseMapping call below takes upto 3 minutes on some SQL Servers whereas it takes hardly any time at all on others. What may cause such a long delay?

Regards,
Joginder Nahil
www.starprint2000.com

Private Sub OutputUserMapping(ByVal oLogin As Microsoft.SqlServer.Management.Smo.Login)

Dim colDatabaseMapping() As DatabaseMapping
colDatabaseMapping = oLogin.EnumDatabaseMappings

' Rest of the code has been deleted

End sub

Hi Joginder,

EnumDatabaseMappings is an expensive operation. SMO issues queries that iterate over all databases on the server and stores intermediate results in a temporary table. This might take time for a server with many databases and users, especially if under heavy load.

You can find out more by running SQL Server Profiler and inspecting the queries that are being sent to the server.

Arur Laksberg
SQL Server Team
Microsoft

|||

Hi Artur,

I am inclined to say that 3 minutes is a very long time in computer processing time (BTW my SQL Server is on the same computer as running the application and has 1GB memory + 3.6 Pentium 4 Processor+ there is nothing much else running) to enumerate just three databases AdventureWorks, Pubs and Northwind.

Regards,

Joginder Nahil
www.starprint2000.com

message box in reporting services

I have used this code pasted below to show message box in reports in Reporting services 2000.It works and pops up but only in development environment but not in production.I mean to say it works in Preview mode but when I have deployed the report it doesn't work.Doesn't even show any error message.

I don't know what would be the code and which assembly file should i Include. Any Ideas ......

Public Function FixDigits(ByVal s As string)
dim msg1 as string
msg1="Parameter is not a 20 digit number"
dim msg2 as string
msg2= "Parameter is not a number"

Dim title As String
title="Attention"
Dim style As MsgBoxStyle
Dim response As MsgBoxResult

style = MsgBoxStyle.OKONLY
if len(s)<>20 then
response = MsgBox(msg1, style, title)

elseif IsNumeric(s)=false then
response = MsgBox(msg2, style, title)

else
end if

End Function

It depends on the client you use to generate the reports. If it is an IDE (Visual Studio), the message box is displayed as it has VB runtime loaded on it. If it is a browser or a client application thru web services, it cannot be communicated to the client as they dont have VB runtime (it is available only on the report server).

Shyam

|||I guess that this is actually releated to another problem. The Messagebox command is executed on the server not on the client, so if the server and the client is one box (as in local development) you probably see the error message while after deploying the report to the report server you won′t see it.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Thanks a lot .Now it makes sense to me .

Merging two rows

Hi All,
I have question about how to do select on below table.
This table has 3column,
Col1->Account Id[Values 1, 2, 3, 4]
Col2>Code [Values 1,2,3]
Col3>Amount[Values 100,200,300,400]
Each code maps to debit, credit, balance...
I want to do a select which can return me debit, credit and balance for
all the Account in the table.
Something like
select debit, credit, balance from Tab1.
But the diffculty is each debit, credit and balance are in a different
row. How can I merge many rows into a single select statement.
Please advise me how I can do this
Thank YouTry,
select
accountid,
sum(case when code = 1 then amount else 0 end) as debit,
sum(case when code = 2 then amount else 0 end) as credit,
sum(case when code = 3 then amount else 0 end) as balance
from
group by accountid
AMB
"dhani" wrote:

> Hi All,
> I have question about how to do select on below table.
> This table has 3column,
> Col1->Account Id[Values 1, 2, 3, 4]
> Col2>Code [Values 1,2,3]
> Col3>Amount[Values 100,200,300,400]
> Each code maps to debit, credit, balance...
> I want to do a select which can return me debit, credit and balance for
> all the Account in the table.
> Something like
> select debit, credit, balance from Tab1.
> But the diffculty is each debit, credit and balance are in a different
> row. How can I merge many rows into a single select statement.
> Please advise me how I can do this
> Thank You
>|||dhani wrote:
> Hi All,
> I have question about how to do select on below table.
> This table has 3column,
> Col1->Account Id[Values 1, 2, 3, 4]
> Col2>Code [Values 1,2,3]
> Col3>Amount[Values 100,200,300,400]
> Each code maps to debit, credit, balance...
> I want to do a select which can return me debit, credit and balance
> for all the Account in the table.
> Something like
> select debit, credit, balance from Tab1.
> But the diffculty is each debit, credit and balance are in a different
> row. How can I merge many rows into a single select statement.
> Please advise me how I can do this
> Thank You
Your requirements are not clear.
Please read and comply with www.aspfaq.com/5006
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.|||The post by the user provides some information that should be able to help
him out.
Allthough I encourage the use of some 'standard' posting and
recommendations, just replying that the users requirements are not clear
and he should comply with etiquette that is not even requied by the
newsgroup doesn't make sense.
What the user wants is to pivot the table in this case.
Personally I would go for a different table design.
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"Bob Barrows [MVP]" <reb01501@.NOyahoo.SPAMcom> wrote in message
news:%234faQbWuFHA.3224@.TK2MSFTNGP10.phx.gbl...
> dhani wrote:
> Your requirements are not clear.
> Please read and comply with www.aspfaq.com/5006
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>|||> Allthough I encourage the use of some 'standard' posting and
> recommendations, just replying that the users requirements are not clear
> and he should comply with etiquette that is not even requied by the
> newsgroup doesn't make sense.
Sure it does (and "make sense" is very subjective, isn't it? Just because
SELECT * and a 9-page stored procedure makes sense to you, doesn't mean we
all share that opinion). The requirements were not clear, so Bob asked for
further clarification, and showed the user a quite helpful link in providing
requirements in a generally accepted format here.
Nobody said it was required by the newsgroup (what is required by the
newsgroup anyway, I have no idea what you're talking about). But you'll see
this follow-up a lot, and I can only assume from you lack of visibility here
that it's just a fact of life in here that you haven't yet been exposed to
enough to understand.
21 letters. Wow.|||So you are judging my knowlegde?
I don't think we ever met and I would definetely not judge you, knowing that
you are a respected MVP.
Did you use a user defined function to count the letters in my
certification?
So why do you conclude I have a lack of visibility and what fact of life
have I not been exposed to?
Don't you think it would be better to just share knowledge in order to
provide solutions and results?
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ewD9UjXuFHA.2008@.TK2MSFTNGP10.phx.gbl...
> Sure it does (and "make sense" is very subjective, isn't it? Just because
> SELECT * and a 9-page stored procedure makes sense to you, doesn't mean we
> all share that opinion). The requirements were not clear, so Bob asked
> for further clarification, and showed the user a quite helpful link in
> providing requirements in a generally accepted format here.
> Nobody said it was required by the newsgroup (what is required by the
> newsgroup anyway, I have no idea what you're talking about). But you'll
> see this follow-up a lot, and I can only assume from you lack of
> visibility here that it's just a fact of life in here that you haven't yet
> been exposed to enough to understand.
> 21 letters. Wow.
>|||> Don't you think it would be better to just share knowledge in order to
> provide solutions and results?
Yes, and part of that knowledge is learning how to post requirements that
work well, are easily re-create-able and test-able, and are requested.
You judged Bob's post and said it didn't make sense. I disagree. Period.|||Dandy Weyn [Dandyman] wrote:
> The post by the user provides some information that should be able to
> help him out.
I'm not trying to be combative or insulting, but, if the post contained
sufficient information, then why didn't you provide a solution?
Look, Alejandro made an attempt based on his guess as to what the user
needed. It may even be the correct solution. The question is: Who knows? I
could have made a similar attempt, only to have the OP come back and say:
"no that's not what I wanted at all", in which case both my time and the
OP's were wasted.

> Allthough I encourage the use of some 'standard' posting and
> recommendations, just replying that the users requirements are not
> clear and he should comply
Well, maybe "comply" was a poor choice of words: I meant "follow the
recommendations made" but I was a little strapped for time and was trying to
be concise.

> with etiquette that is not even requied by
I think if you use google, you will fiind that a large percentage of posts
to this group, as well as the comp.databases.ms-sqlserver group, receive a
similar initial request to provide DDL and sample data. This is usenet,
there is no way to "require" etiquette. That does not mean we should not
make an effort to help posters get help as efficiently as possible by
showing them the best way to provide the information needed to solve their
problems. Aaron's article does a good job of that. He put it in his
"ettiquette" section, but that does not mean this has anything to do with
"ettiquette".

> the newsgroup doesn't make sense.
Why not? What else should I do when the post contains insufficient
information to provide a solution? Waste my time and the OP's by making a
guess? Ignore the message (how does that help the OP)?
> What the user wants is to pivot the table in this case.
Maybe. In fact, I will even go so far as to say "probably". But, does he
need a dynamic pivot? Or does he have static values on which to base a
non-dynamic pivot?

> Personally I would go for a different table design.
Really? Based on what? You know very little about the OP's requirements ...
And why don't you think a vague statement about a "different table design"
is as bad as a request for clarification?
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.