precision

Precision is the number of digits in a number. Scale is the number of digits
to the right of the decimal point in a number. For example, the number
123.45 has a precision of 5 and a scale of 2.
Is the above statement true? or Is the precision 3 and the scale is 2?
Thank you in advance.In your example 123.45 the precision (p) is 5 and scale (s) is 2.
For more information:
http://msdn.microsoft.com/library/en-us/tsqlref/ts_de-dz_3grn.asp
--
Rohtash Kapoor
http://www.sqlmantra.com
"Praetorian Guard" <praetorian@.gatekeeper.com> wrote in message
news:O7cosLP1DHA.832@.TK2MSFTNGP09.phx.gbl...
> Precision is the number of digits in a number. Scale is the number of
digits
> to the right of the decimal point in a number. For example, the number
> 123.45 has a precision of 5 and a scale of 2.
> Is the above statement true? or Is the precision 3 and the scale is 2?
> Thank you in advance.
>|||So on this one 1234567890.1234 the precision is 14 and the scale is 4 same
as (14,4)?
"Rohtash Kapoor" <rohtash_nospam@.sqlmantra.com> wrote in message
news:%230BQSWP1DHA.540@.tk2msftngp13.phx.gbl...
> In your example 123.45 the precision (p) is 5 and scale (s) is 2.
> For more information:
> http://msdn.microsoft.com/library/en-us/tsqlref/ts_de-dz_3grn.asp
> --
> Rohtash Kapoor
> http://www.sqlmantra.com
> "Praetorian Guard" <praetorian@.gatekeeper.com> wrote in message
> news:O7cosLP1DHA.832@.TK2MSFTNGP09.phx.gbl...
> > Precision is the number of digits in a number. Scale is the number of
> digits
> > to the right of the decimal point in a number. For example, the number
> > 123.45 has a precision of 5 and a scale of 2.
> >
> > Is the above statement true? or Is the precision 3 and the scale is 2?
> >
> > Thank you in advance.
> >
> >
>|||Yes
>--Original Message--
>So on this one 1234567890.1234 the precision is 14 and
the scale is 4 same
>as (14,4)?
>"Rohtash Kapoor" <rohtash_nospam@.sqlmantra.com> wrote in
message
>news:%230BQSWP1DHA.540@.tk2msftngp13.phx.gbl...
>> In your example 123.45 the precision (p) is 5 and scale
(s) is 2.
>> For more information:
>> http://msdn.microsoft.com/library/en-us/tsqlref/ts_de-
dz_3grn.asp
>> --
>> Rohtash Kapoor
>> http://www.sqlmantra.com
>> "Praetorian Guard" <praetorian@.gatekeeper.com> wrote in
message
>> news:O7cosLP1DHA.832@.TK2MSFTNGP09.phx.gbl...
>> > Precision is the number of digits in a number. Scale
is the number of
>> digits
>> > to the right of the decimal point in a number. For
example, the number
>> > 123.45 has a precision of 5 and a scale of 2.
>> >
>> > Is the above statement true? or Is the precision 3
and the scale is 2?
>> >
>> > Thank you in advance.
>> >
>> >
>>
>
>.
>

PowerPoint format possible?

Hello,

we plan to use Reporting Services in the company in the near future. However, management prefers power point reports, a format which reporting services does not support (please correct me if I am wrong here).

Is there a third party extenstion tool for RS available which can produce PPT reports?

Best regards,

Michael Fuchs

Hello,

I'm not aware of any third-party PowerPoint renderer.

Can you explain your scenario that calls for PowerPoint rendering? Any insight you can offer will help to justify the possibility of providing this functionality in the future.

Thanks,
Chris

|||

Hello,

Management presents the reports in periodic meetings, currently pdf slides are used (these pdfs don't come from RS but from a self developed program), but this is not desired by management anymore, as pdf is not optimal for a presentation. What we need is nothing too fancy, just a slide with some formatting options (i.e. different templates) and the relevant charts and data presented on the slide.

I heard that ppt output is planned anyway in the next version of reporting services and that it already is in the testing stage. Is that just a rumor or can you confirm that?

Thanks,

Michael

Power Point Presentation

hi Gurus,
I need the resource where I can find the Power point presentation on various
topics of SQL server.
Thanks in advance
Ansari
Use link in my signature, check Technical Resources.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
news:%236r98J9kEHA.3648@.TK2MSFTNGP09.phx.gbl...
> hi Gurus,
> I need the resource where I can find the Power point presentation on
various
> topics of SQL server.
> Thanks in advance
> Ansari
>
>
|||Thanks a lot..
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:uEFAvW9kEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Use link in my signature, check Technical Resources.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
> news:%236r98J9kEHA.3648@.TK2MSFTNGP09.phx.gbl...
> various
>

Power Point Presentation

hi Gurus,
I need the resource where I can find the Power point presentation on various
topics of SQL server.
Thanks in advance
AnsariUse link in my signature, check Technical Resources.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
news:%236r98J9kEHA.3648@.TK2MSFTNGP09.phx.gbl...
> hi Gurus,
> I need the resource where I can find the Power point presentation on
various
> topics of SQL server.
> Thanks in advance
> Ansari
>
>|||Thanks a lot.. :)
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:uEFAvW9kEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Use link in my signature, check Technical Resources.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
> news:%236r98J9kEHA.3648@.TK2MSFTNGP09.phx.gbl...
> > hi Gurus,
> >
> > I need the resource where I can find the Power point presentation on
> various
> > topics of SQL server.
> >
> > Thanks in advance
> >
> > Ansari
> >
> >
> >
> >
>

power point

dear all

i have problem

when i copy presentation from pc to pc the bullets and numbering change

i use power point 2003

shall i found solution

Hello - you are in the SQL Server Documentation forum. You might find more information here:

http://office.microsoft.com/en-us/help/FX100485361033.aspx?pid=CL100605171033

Buck Woody

Post SP3a Rollup

Can someone point me to where I can find the psot SP3a Rollup?
I've been digging forit and can't find it...from what I've seen on here, it
addresses a couple of issues with replication I may be encountering.
Thanks!
I think the following link is what you are looking for...
http://www.microsoft.com/downloads/d...displaylang=en
"A. Robinson" wrote:

> Can someone point me to where I can find the psot SP3a Rollup?
> I've been digging forit and can't find it...from what I've seen on here, it
> addresses a couple of issues with replication I may be encountering.
> Thanks!
|||Is this strictly for security concerns? I though I read somewhere that the
rollup also addresses some known issues with replication...
I've also heard SP4 has a LOT of replication fixes!
Can someone comment?
Thanks!
"Raymond Mak [MSFT]" wrote:
[vbcol=seagreen]
> I think the following link is what you are looking for...
> http://www.microsoft.com/downloads/d...displaylang=en
> "A. Robinson" wrote:
|||If you're interested in SP4 fixes, have a look here:
http://www.replicationanswers.com/sp4.asp and you can cross reference these
to various hotfixes.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||This security patch should contain all SQL2000SP3 QFE fixes (security or
not) up to the latest security issue that the patch intends to address. Of
course, you are more than welcome to try out SP4 as well which should be
released in the very near future.
-Raymond
"A. Robinson" wrote:
[vbcol=seagreen]
> Is this strictly for security concerns? I though I read somewhere that the
> rollup also addresses some known issues with replication...
> I've also heard SP4 has a LOT of replication fixes!
> Can someone comment?
> Thanks!
> "Raymond Mak [MSFT]" wrote:

possible to save up the progress at some point of Decision Tree Training?

Dear All,

If I have a decision tree training work which might last for many days or months. Is it possible to tell the data mining training program to save up the progress at some point? In case the computer hangs or power fail in the middle, the computer can resume the rest of the work at the saving point?

Thanks

Tony Chun Tung Siu

No, SQL Server 2005 Data Mining does not support interactive training for the mining models. A training request is a transactional operation so, if it fails for any reason (including the reasons you mentioned) the transaction is not commited and, when the server is restarted, it is rolled back

possible to save up the progress at some point of Decision Tree Training?

Dear All,

If I have a decision tree training work which might last for many days or months. Is it possible to tell the data mining training program to save up the progress at some point? In case the computer hangs or power fail in the middle, the computer can resume the rest of the work at the saving point?

Thanks

Tony Chun Tung Siu

No, SQL Server 2005 Data Mining does not support interactive training for the mining models. A training request is a transactional operation so, if it fails for any reason (including the reasons you mentioned) the transaction is not commited and, when the server is restarted, it is rolled back