I'd like to make a substractions between result of year 1 and result of year
2.
I've made a matrix with year in colums?
Can I make his operation easily or have you got an other solution?
Please, help me.
Thanks in advance
NicolasI was able to do a similar calculation. I have a column group by month, and
then columns within the month showing Open and Close values. I was able to
subtract the Open and Close values by inserting a column in that row. Right
click on the column and you should see Add Column (not Column group). There
may be another way that I'm not aware of.
"Nicolas BRESSAN" wrote:
> I'd like to make a substractions between result of year 1 and result of year
> 2.
> I've made a matrix with year in colums?
> Can I make his operation easily or have you got an other solution?
> Please, help me.
> Thanks in advance
> Nicolas|||You could do this in the query ( if you'd like to post it...)
Or you might try the Previous function
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nicolas BRESSAN" <NicolasBRESSAN@.discussions.microsoft.com> wrote in
message news:091A070B-78A2-46A9-8753-D518D353DDF9@.microsoft.com...
> I'd like to make a substractions between result of year 1 and result of
> year
> 2.
> I've made a matrix with year in colums?
> Can I make his operation easily or have you got an other solution?
> Please, help me.
> Thanks in advance
> Nicolas
Showing posts with label operations. Show all posts
Showing posts with label operations. Show all posts
Wednesday, March 7, 2012
operations through stored procedures
i write a following stored procedure
create proc prc_BUSINESS_MASTER
(
@.chByMode Char(1),
@.intLIST_ID int=null,
@.intLISTBUSINESSID int=null,
@.dtmDATE datetime=null,
@.dtmEXPDATE datetime=null,
@.vchSTATUS varchar(10)=null,
@.vchOFFICE varchar(100)=null,
@.numCITY numeric =null,
@.numCOUNTY numeric=null,
@.numSTATE numeric=null,
@.numCOUNTRY numeric=null,
@.vchSICCODE varchar(50)=null,
@.numASKINGPRICE numeric =null,
@.numDOWNPRICE numeric=null,
@.bitOWNERFINANCE bit=null,
@.numOWNERFINANCE numeric=null,
@.numADJ_NETAMOUNT numeric=null,
@.numSALESAMOUNT numeric=null,
@.dtmYOE datetime=null,
@.dtmYRSOWNED datetime=null,
@.bitBITISACTIVE bit=null,
@.vchCREATEDBY varchar(50)=null,
@.dtmCREATEDDATE datetime=null,
@.vchUPDATEDBY varchar(50)=null,
@.dtmUPDATEDDATE datetime=null
)
as
set nocount on
declare @.byIntErrDescOut int
declare @.interrno int
declare @.intdupchk int
begin
IF @.chByMode NOT IN ('I','U')
BEGIN
SET @.byIntErrDescOut = 1
Return -1
END
SET @.byIntErrDescOut = 0
/* *************** Insertion Area *************** */
IF @.chByMode = 'I'
BEGIN
IF @.vchSTATUS IS NULL OR @.vchSTATUS = ''
BEGIN
SET @.byIntErrDescOut = 1
Return -1
END
/***** Duplicate checking ****/
SELECT @.intDupChk = COUNT(1) FROM BUSINESSMASTER WHEREvchLIST_STATUS=@.vchSTATUS AndvchLIST_OFFICE=@.vchOFFICE
IF @.intDupChk <> 0
BEGIN
SET @.byintErrDescOut = 5
Return -1
END
insert into BUSINESSMASTER
(
intLIST_ID,
dtmLIST_DATE,
dtmLIST_EXPDATE,
vchLIST_STATUS,
vchLIST_OFFICE,
numLIST_CITY,
numLIST_COUNTY,
numLIST_STATE,
numLIST_COUNTRY,
vchLIST_SICCODE,
numLIST_ASKINGPRICE,
numLIST_DOWNPRICE,
bitLIST_OWNERFINANCE,
numLIST_OWNERFINACE,
numLIST_ADJ_NETAMOUNT,
numLIST_SALESAMOUNT,
dtmLIST_YOE,
dtmLIST_YRSOWNED,
bitBITISACTIVE,
vchCREATEDBY,
dtmCREATEDDATE,
vchUPDATEDBY,
dtmUPDATEDDATE
)
values
(
@.intLIST_ID,
@.dtmDATE,
@.dtmEXPDATE,
@.vchSTATUS,
@.vchOFFICE,
@.numCITY,
@.numCOUNTY,
@.numSTATE,
@.numCOUNTRY,
@.vchSICCODE,
@.numASKINGPRICE,
@.numDOWNPRICE,
@.numOWNERFINANCE,
@.bitOWNERFINANCE,
@.numADJ_NETAMOUNT,
@.numSALESAMOUNT,
@.dtmYOE,
@.dtmYRSOWNED,
@.bitBITISACTIVE,
@.vchCREATEDBY,
@.dtmCREATEDDATE,
@.vchUPDATEDBY,
@.dtmUPDATEDDATE
)
SET @.intErrNo = @.@.Error
IF (@.intErrNo <> 0)
BEGIN
SET @.byIntErrDescOut = 2
Return -1
END
/*Insertion Area End*/
/*---Updation----*/
/*
IF @.chbyMode = 'U'
BEGIN
--IF @.intBuyerId IS NULL
BEGIN
SET @.byIntErrDescOut = 1
Return -1
END
*/
IF (EXISTS (SELECT * FROM BUSINESSMASTER
WHERE intLISTBUSINESSID = @.intLISTBUSINESSID ))
BEGIN
/***** Duplicate checking ****/
SELECT @.intDupChk = COUNT(1) FROM BUSINESSMASTER
WHERE intLISTBUSINESSID = @.intLISTBUSINESSID andvchLIST_STATUS=@.vchSTATUS
IF @.intDupChk <> 0
BEGIN
SET @.byintErrDescOut = 5
Return -1
END
UPDATE BUSINESSMASTER
SET
intLIST_ID=@.intLIST_ID,
dtmLIST_DATE=@.dtmDATE,
dtmLIST_EXPDATE=@.dtmEXPDATE,
vchLIST_STATUS=@.vchSTATUS,
vchLIST_OFFICE=@.vchOFFICE,
numLIST_CITY=@.numCITY,
numLIST_COUNTY=@.numCOUNTY,
numLIST_STATE=@.numSTATE,
numLIST_COUNTRY=@.numCOUNTRY,
vchLIST_SICCODE=@.vchSICCODE,
numLIST_ASKINGPRICE=@.numASKINGPRICE,
numLIST_DOWNPRICE=@.numDOWNPRICE,
bitLIST_OWNERFINANCE=@.bitOWNERFINANCE,
numLIST_OWNERFINACE=@.numOWNERFINANCE,
numLIST_ADJ_NETAMOUNT=@.numADJ_NETAMOUNT,
numLIST_SALESAMOUNT=@.numSALESAMOUNT,
dtmLIST_YOE=@.dtmYOE,
dtmLIST_YRSOWNED=@.dtmYRSOWNED,
bitBITISACTIVE=@.bitBITISACTIVE,
vchCREATEDBY=@.vchCREATEDBY,
dtmCREATEDDATE=@.dtmCREATEDDATE,
vchUPDATEDBY=@.vchUPDATEDBY,
dtmUPDATEDDATE=@.dtmUPDATEDDATE
WHERE intLISTBUSINESSID = @.intLISTBUSINESSID
-- AND WhenUpdated = @.ptmsUpdated
SET @.intErrNo = @.@.Error
IF (@.intErrNo <> 0)
BEGIN
SET @.byIntErrDescOut = 4
Return -1
END
END
ELSE
BEGIN
SET @.byIntErrDescOut = 4
Return -1
END
END
End
How can i check this procedure by performing insert ,update operations?
ie., how can i passing and updating informations through stored procedures?
Explain me in detail...
If you want to test it from the sql server environment, highlight the procedure name in the sql server query studio/management studio and right click it.
The menu will give you an option to execute the stored procedure. Choose it and it will build a script to execute the procedure for you.
All you have to do is supply sample values.
|||I glanced at your procedure and noticed a few things about it:
The visual indentation of the code is horrible. I hope the copy/paste process lost that, because the logic control flow of the program is much harder to follow than it would be with proper indentation.
Operations Spec Document
I am looking for some of the obvious questions one needs to ask from the
devs,etc. to help Operations be ready to be in a position to understand some
of the new requirements coming in and be prepared from a datbase
perspective.. such as DB size, capacity,etc..
Just naive to this and wanted to see what you have in place
ThanksHmm. Do you have any specific items you want to cover? Operations can
cover a *huge* range of functions depending on your industry. MS and other
vendors print up tons of White Papers that are designed to tell you the
questions you *should be* asking; and of course the answers always tend to
favor their specific products. But that's marketing disguised as
scholarship for you...
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23E5N7wDfGHA.1204@.TK2MSFTNGP02.phx.gbl...
>I am looking for some of the obvious questions one needs to ask from the
>devs,etc. to help Operations be ready to be in a position to understand
>some of the new requirements coming in and be prepared from a datbase
>perspective.. such as DB size, capacity,etc..
> Just naive to this and wanted to see what you have in place
> Thanks
>|||Do you have links to those white papers pertaining to SQL Server.
"Mike C#" <xxx@.yyy.com> wrote in message news:Q1Qbg.1364$%02.733@.fe09.lga...
> Hmm. Do you have any specific items you want to cover? Operations can
> cover a *huge* range of functions depending on your industry. MS and
> other vendors print up tons of White Papers that are designed to tell you
> the questions you *should be* asking; and of course the answers always
> tend to favor their specific products. But that's marketing disguised as
> scholarship for you...
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23E5N7wDfGHA.1204@.TK2MSFTNGP02.phx.gbl...
>|||http://www.microsoft.com, man. Here are a few (pulled by searching
microsoft.com for "sql white paper"):
http://www.microsoft.com/sql/techin...nt.msp
x
http://www.microsoft.com/technet/pr...lan/ssmsam.mspx
http://download.microsoft.com/downl...verInRetail.doc
http://www.microsoft.com/sql/techin...hy-upgrade.mspx
http://www.microsoft.com/technet/pr...5/sqlupgrd.mspx
http://www.microsoft.com/sql/soluti...de/default.mspx (links to other
white papers, benchmarks, etc.)
http://www.microsoft.com/technet/pr...in/sqlydba.mspx
http://www.microsoft.com/technet/pr...te/dwsqlsy.mspx
http://support.microsoft.com/defaul...kb;en-us;323739
http://www.microsoft.com/sql/howtob...rlicensing.mspx
http://www.microsoft.com/sql/howtobuy/default.mspx
http://www.microsoft.com/sql/soluti...emigratewp.mspx
http://download.microsoft.com/downl...oSQL2005TWP.doc
http://www.microsoft.com/sql/techno...ty/default.mspx
(links to white papers, etc.)
http://www.microsoft.com/sql/prodin...bm/default.mspx
http://www.microsoft.com/sql/prodin...le/default.mspx
http://www.microsoft.com/sql/prodin...cle/oracle.mspx (links)
http://www.microsoft.com/sql/solutions/edm/default.mspx (links)
http://www.microsoft.com/technet/it...it/default.mspx (links)
http://www.microsoft.com/sql/prodin...ailability.mspx
http://support.microsoft.com/?id=321518
http://www.microsoft.com/technet/pr...ploy/mysql.mspx
There are about 9,700+ pages on microsoft.com that reference "sql white
paper". These results are from the first 80 pages. You might want to
narrow down your results a bit by deciding exactly what issues are most
important to you and narrowing your searches for information on those
topics.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:O8hVqaJfGHA.1272@.TK2MSFTNGP03.phx.gbl...
> Do you have links to those white papers pertaining to SQL Server.
> "Mike C#" <xxx@.yyy.com> wrote in message
> news:Q1Qbg.1364$%02.733@.fe09.lga...
>
devs,etc. to help Operations be ready to be in a position to understand some
of the new requirements coming in and be prepared from a datbase
perspective.. such as DB size, capacity,etc..
Just naive to this and wanted to see what you have in place
ThanksHmm. Do you have any specific items you want to cover? Operations can
cover a *huge* range of functions depending on your industry. MS and other
vendors print up tons of White Papers that are designed to tell you the
questions you *should be* asking; and of course the answers always tend to
favor their specific products. But that's marketing disguised as
scholarship for you...
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23E5N7wDfGHA.1204@.TK2MSFTNGP02.phx.gbl...
>I am looking for some of the obvious questions one needs to ask from the
>devs,etc. to help Operations be ready to be in a position to understand
>some of the new requirements coming in and be prepared from a datbase
>perspective.. such as DB size, capacity,etc..
> Just naive to this and wanted to see what you have in place
> Thanks
>|||Do you have links to those white papers pertaining to SQL Server.
"Mike C#" <xxx@.yyy.com> wrote in message news:Q1Qbg.1364$%02.733@.fe09.lga...
> Hmm. Do you have any specific items you want to cover? Operations can
> cover a *huge* range of functions depending on your industry. MS and
> other vendors print up tons of White Papers that are designed to tell you
> the questions you *should be* asking; and of course the answers always
> tend to favor their specific products. But that's marketing disguised as
> scholarship for you...
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23E5N7wDfGHA.1204@.TK2MSFTNGP02.phx.gbl...
>|||http://www.microsoft.com, man. Here are a few (pulled by searching
microsoft.com for "sql white paper"):
http://www.microsoft.com/sql/techin...nt.msp
x
http://www.microsoft.com/technet/pr...lan/ssmsam.mspx
http://download.microsoft.com/downl...verInRetail.doc
http://www.microsoft.com/sql/techin...hy-upgrade.mspx
http://www.microsoft.com/technet/pr...5/sqlupgrd.mspx
http://www.microsoft.com/sql/soluti...de/default.mspx (links to other
white papers, benchmarks, etc.)
http://www.microsoft.com/technet/pr...in/sqlydba.mspx
http://www.microsoft.com/technet/pr...te/dwsqlsy.mspx
http://support.microsoft.com/defaul...kb;en-us;323739
http://www.microsoft.com/sql/howtob...rlicensing.mspx
http://www.microsoft.com/sql/howtobuy/default.mspx
http://www.microsoft.com/sql/soluti...emigratewp.mspx
http://download.microsoft.com/downl...oSQL2005TWP.doc
http://www.microsoft.com/sql/techno...ty/default.mspx
(links to white papers, etc.)
http://www.microsoft.com/sql/prodin...bm/default.mspx
http://www.microsoft.com/sql/prodin...le/default.mspx
http://www.microsoft.com/sql/prodin...cle/oracle.mspx (links)
http://www.microsoft.com/sql/solutions/edm/default.mspx (links)
http://www.microsoft.com/technet/it...it/default.mspx (links)
http://www.microsoft.com/sql/prodin...ailability.mspx
http://support.microsoft.com/?id=321518
http://www.microsoft.com/technet/pr...ploy/mysql.mspx
There are about 9,700+ pages on microsoft.com that reference "sql white
paper". These results are from the first 80 pages. You might want to
narrow down your results a bit by deciding exactly what issues are most
important to you and narrowing your searches for information on those
topics.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:O8hVqaJfGHA.1272@.TK2MSFTNGP03.phx.gbl...
> Do you have links to those white papers pertaining to SQL Server.
> "Mike C#" <xxx@.yyy.com> wrote in message
> news:Q1Qbg.1364$%02.733@.fe09.lga...
>
Operations Spec Document
I am looking for some of the obvious questions one needs to ask from the
devs,etc. to help Operations be ready to be in a position to understand some
of the new requirements coming in and be prepared from a datbase
perspective.. such as DB size, capacity,etc..
Just naive to this and wanted to see what you have in place
ThanksHmm. Do you have any specific items you want to cover? Operations can
cover a *huge* range of functions depending on your industry. MS and other
vendors print up tons of White Papers that are designed to tell you the
questions you *should be* asking; and of course the answers always tend to
favor their specific products. But that's marketing disguised as
scholarship for you...
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23E5N7wDfGHA.1204@.TK2MSFTNGP02.phx.gbl...
>I am looking for some of the obvious questions one needs to ask from the
>devs,etc. to help Operations be ready to be in a position to understand
>some of the new requirements coming in and be prepared from a datbase
>perspective.. such as DB size, capacity,etc..
> Just naive to this and wanted to see what you have in place
> Thanks
>|||Do you have links to those white papers pertaining to SQL Server.
"Mike C#" <xxx@.yyy.com> wrote in message news:Q1Qbg.1364$%02.733@.fe09.lga...
> Hmm. Do you have any specific items you want to cover? Operations can
> cover a *huge* range of functions depending on your industry. MS and
> other vendors print up tons of White Papers that are designed to tell you
> the questions you *should be* asking; and of course the answers always
> tend to favor their specific products. But that's marketing disguised as
> scholarship for you...
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23E5N7wDfGHA.1204@.TK2MSFTNGP02.phx.gbl...
>>I am looking for some of the obvious questions one needs to ask from the
>>devs,etc. to help Operations be ready to be in a position to understand
>>some of the new requirements coming in and be prepared from a datbase
>>perspective.. such as DB size, capacity,etc..
>> Just naive to this and wanted to see what you have in place
>> Thanks
>|||http://www.microsoft.com, man. Here are a few (pulled by searching
microsoft.com for "sql white paper"):
http://www.microsoft.com/sql/techinfo/whitepapers/advantages-64bit-environment.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx
http://download.microsoft.com/download/e/2/b/e2b4227d-54a9-4c09-82b8-892f98d73b51/SQLServerInRetail.doc
http://www.microsoft.com/sql/techinfo/whitepapers/why-upgrade.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
http://www.microsoft.com/sql/solutions/upgrade/default.mspx (links to other
white papers, benchmarks, etc.)
http://www.microsoft.com/technet/prodtechnol/sql/2005/maintain/sqlydba.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/evaluate/dwsqlsy.mspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;323739
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
http://www.microsoft.com/sql/howtobuy/default.mspx
http://www.microsoft.com/sql/solutions/ssm/oraclemigratewp.mspx
http://download.microsoft.com/download/1/a/7/1a7a9faa-2f90-4e56-a4b7-977f1ce96dd5/MovingToSQL2005TWP.doc
http://www.microsoft.com/sql/technologies/highavailability/default.mspx
(links to white papers, etc.)
http://www.microsoft.com/sql/prodinfo/compare/ibm/default.mspx
http://www.microsoft.com/sql/prodinfo/compare/oracle/default.mspx
http://www.microsoft.com/sql/prodinfo/compare/oracle/oracle.mspx (links)
http://www.microsoft.com/sql/solutions/edm/default.mspx (links)
http://www.microsoft.com/technet/itsolutions/msit/default.mspx (links)
http://www.microsoft.com/sql/prodinfo/compare/oracle/dbavailability.mspx
http://support.microsoft.com/?id=321518
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx
There are about 9,700+ pages on microsoft.com that reference "sql white
paper". These results are from the first 80 pages. You might want to
narrow down your results a bit by deciding exactly what issues are most
important to you and narrowing your searches for information on those
topics.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:O8hVqaJfGHA.1272@.TK2MSFTNGP03.phx.gbl...
> Do you have links to those white papers pertaining to SQL Server.
> "Mike C#" <xxx@.yyy.com> wrote in message
> news:Q1Qbg.1364$%02.733@.fe09.lga...
>> Hmm. Do you have any specific items you want to cover? Operations can
>> cover a *huge* range of functions depending on your industry. MS and
>> other vendors print up tons of White Papers that are designed to tell you
>> the questions you *should be* asking; and of course the answers always
>> tend to favor their specific products. But that's marketing disguised as
>> scholarship for you...
>> "Hassan" <Hassan@.hotmail.com> wrote in message
>> news:%23E5N7wDfGHA.1204@.TK2MSFTNGP02.phx.gbl...
>>I am looking for some of the obvious questions one needs to ask from the
>>devs,etc. to help Operations be ready to be in a position to understand
>>some of the new requirements coming in and be prepared from a datbase
>>perspective.. such as DB size, capacity,etc..
>> Just naive to this and wanted to see what you have in place
>> Thanks
>>
>
devs,etc. to help Operations be ready to be in a position to understand some
of the new requirements coming in and be prepared from a datbase
perspective.. such as DB size, capacity,etc..
Just naive to this and wanted to see what you have in place
ThanksHmm. Do you have any specific items you want to cover? Operations can
cover a *huge* range of functions depending on your industry. MS and other
vendors print up tons of White Papers that are designed to tell you the
questions you *should be* asking; and of course the answers always tend to
favor their specific products. But that's marketing disguised as
scholarship for you...
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23E5N7wDfGHA.1204@.TK2MSFTNGP02.phx.gbl...
>I am looking for some of the obvious questions one needs to ask from the
>devs,etc. to help Operations be ready to be in a position to understand
>some of the new requirements coming in and be prepared from a datbase
>perspective.. such as DB size, capacity,etc..
> Just naive to this and wanted to see what you have in place
> Thanks
>|||Do you have links to those white papers pertaining to SQL Server.
"Mike C#" <xxx@.yyy.com> wrote in message news:Q1Qbg.1364$%02.733@.fe09.lga...
> Hmm. Do you have any specific items you want to cover? Operations can
> cover a *huge* range of functions depending on your industry. MS and
> other vendors print up tons of White Papers that are designed to tell you
> the questions you *should be* asking; and of course the answers always
> tend to favor their specific products. But that's marketing disguised as
> scholarship for you...
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23E5N7wDfGHA.1204@.TK2MSFTNGP02.phx.gbl...
>>I am looking for some of the obvious questions one needs to ask from the
>>devs,etc. to help Operations be ready to be in a position to understand
>>some of the new requirements coming in and be prepared from a datbase
>>perspective.. such as DB size, capacity,etc..
>> Just naive to this and wanted to see what you have in place
>> Thanks
>|||http://www.microsoft.com, man. Here are a few (pulled by searching
microsoft.com for "sql white paper"):
http://www.microsoft.com/sql/techinfo/whitepapers/advantages-64bit-environment.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx
http://download.microsoft.com/download/e/2/b/e2b4227d-54a9-4c09-82b8-892f98d73b51/SQLServerInRetail.doc
http://www.microsoft.com/sql/techinfo/whitepapers/why-upgrade.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
http://www.microsoft.com/sql/solutions/upgrade/default.mspx (links to other
white papers, benchmarks, etc.)
http://www.microsoft.com/technet/prodtechnol/sql/2005/maintain/sqlydba.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/evaluate/dwsqlsy.mspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;323739
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
http://www.microsoft.com/sql/howtobuy/default.mspx
http://www.microsoft.com/sql/solutions/ssm/oraclemigratewp.mspx
http://download.microsoft.com/download/1/a/7/1a7a9faa-2f90-4e56-a4b7-977f1ce96dd5/MovingToSQL2005TWP.doc
http://www.microsoft.com/sql/technologies/highavailability/default.mspx
(links to white papers, etc.)
http://www.microsoft.com/sql/prodinfo/compare/ibm/default.mspx
http://www.microsoft.com/sql/prodinfo/compare/oracle/default.mspx
http://www.microsoft.com/sql/prodinfo/compare/oracle/oracle.mspx (links)
http://www.microsoft.com/sql/solutions/edm/default.mspx (links)
http://www.microsoft.com/technet/itsolutions/msit/default.mspx (links)
http://www.microsoft.com/sql/prodinfo/compare/oracle/dbavailability.mspx
http://support.microsoft.com/?id=321518
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx
There are about 9,700+ pages on microsoft.com that reference "sql white
paper". These results are from the first 80 pages. You might want to
narrow down your results a bit by deciding exactly what issues are most
important to you and narrowing your searches for information on those
topics.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:O8hVqaJfGHA.1272@.TK2MSFTNGP03.phx.gbl...
> Do you have links to those white papers pertaining to SQL Server.
> "Mike C#" <xxx@.yyy.com> wrote in message
> news:Q1Qbg.1364$%02.733@.fe09.lga...
>> Hmm. Do you have any specific items you want to cover? Operations can
>> cover a *huge* range of functions depending on your industry. MS and
>> other vendors print up tons of White Papers that are designed to tell you
>> the questions you *should be* asking; and of course the answers always
>> tend to favor their specific products. But that's marketing disguised as
>> scholarship for you...
>> "Hassan" <Hassan@.hotmail.com> wrote in message
>> news:%23E5N7wDfGHA.1204@.TK2MSFTNGP02.phx.gbl...
>>I am looking for some of the obvious questions one needs to ask from the
>>devs,etc. to help Operations be ready to be in a position to understand
>>some of the new requirements coming in and be prepared from a datbase
>>perspective.. such as DB size, capacity,etc..
>> Just naive to this and wanted to see what you have in place
>> Thanks
>>
>
Operations on Parameters
Hi
I attempted to perform a simple mathematical operation (like dividing 10 by
4) in a text box of a Table or body of a report and I end up with an integer
result (10\4 gives me 2.0). I used convert method, CDbl method and I still
get the same result. I formated the text box as N5, C2 and other formats but
still the same result.
The original problem is that the same thing happens with a report parameter
when I try to use it in calculations but by troubleshooting the problem I
realized that it happens in any text box.
What am I doing wrong?
Thanks
ShawnInteresting, I was going to suggest trying 10.0/4.0, but after adding
an expression "=10/4" to a text box I see the result is 2.5. Is you
operation in an expression or in custom code?
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Fri, 12 Nov 2004 13:40:08 -0800, "Shawn Kralj"
<ShawnKralj@.discussions.microsoft.com> wrote:
>Hi
>I attempted to perform a simple mathematical operation (like dividing 10 by
>4) in a text box of a Table or body of a report and I end up with an integer
>result (10\4 gives me 2.0). I used convert method, CDbl method and I still
>get the same result. I formated the text box as N5, C2 and other formats but
>still the same result.
>The original problem is that the same thing happens with a report parameter
>when I try to use it in calculations but by troubleshooting the problem I
>realized that it happens in any text box.
>What am I doing wrong?
>Thanks
>Shawn|||>10\4 gives me 2.0
If you are really using \ then you are getting the correct result. The
'backslash' operator returns only the integer portion of the result.
If you're expecting 2.5 as the result, then you have to use / instead.
On Fri, 12 Nov 2004 13:40:08 -0800, "Shawn Kralj"
<ShawnKralj@.discussions.microsoft.com> wrote:
>Hi
>I attempted to perform a simple mathematical operation (like dividing 10 by
>4) in a text box of a Table or body of a report and I end up with an integer
>result (10\4 gives me 2.0). I used convert method, CDbl method and I still
>get the same result. I formated the text box as N5, C2 and other formats but
>still the same result.
>The original problem is that the same thing happens with a report parameter
>when I try to use it in calculations but by troubleshooting the problem I
>realized that it happens in any text box.
>What am I doing wrong?
>Thanks
>Shawn|||Oooh , good catch.
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Sun, 14 Nov 2004 23:17:36 -0500, Dan Knight
<dknight@.REMOVEmullinixpackages.THIScom> wrote:
>>10\4 gives me 2.0
>If you are really using \ then you are getting the correct result. The
>'backslash' operator returns only the integer portion of the result.
>If you're expecting 2.5 as the result, then you have to use / instead.
>On Fri, 12 Nov 2004 13:40:08 -0800, "Shawn Kralj"
><ShawnKralj@.discussions.microsoft.com> wrote:
>>Hi
>>I attempted to perform a simple mathematical operation (like dividing 10 by
>>4) in a text box of a Table or body of a report and I end up with an integer
>>result (10\4 gives me 2.0). I used convert method, CDbl method and I still
>>get the same result. I formated the text box as N5, C2 and other formats but
>>still the same result.
>>The original problem is that the same thing happens with a report parameter
>>when I try to use it in calculations but by troubleshooting the problem I
>>realized that it happens in any text box.
>>What am I doing wrong?
>>Thanks
>>Shawn
I attempted to perform a simple mathematical operation (like dividing 10 by
4) in a text box of a Table or body of a report and I end up with an integer
result (10\4 gives me 2.0). I used convert method, CDbl method and I still
get the same result. I formated the text box as N5, C2 and other formats but
still the same result.
The original problem is that the same thing happens with a report parameter
when I try to use it in calculations but by troubleshooting the problem I
realized that it happens in any text box.
What am I doing wrong?
Thanks
ShawnInteresting, I was going to suggest trying 10.0/4.0, but after adding
an expression "=10/4" to a text box I see the result is 2.5. Is you
operation in an expression or in custom code?
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Fri, 12 Nov 2004 13:40:08 -0800, "Shawn Kralj"
<ShawnKralj@.discussions.microsoft.com> wrote:
>Hi
>I attempted to perform a simple mathematical operation (like dividing 10 by
>4) in a text box of a Table or body of a report and I end up with an integer
>result (10\4 gives me 2.0). I used convert method, CDbl method and I still
>get the same result. I formated the text box as N5, C2 and other formats but
>still the same result.
>The original problem is that the same thing happens with a report parameter
>when I try to use it in calculations but by troubleshooting the problem I
>realized that it happens in any text box.
>What am I doing wrong?
>Thanks
>Shawn|||>10\4 gives me 2.0
If you are really using \ then you are getting the correct result. The
'backslash' operator returns only the integer portion of the result.
If you're expecting 2.5 as the result, then you have to use / instead.
On Fri, 12 Nov 2004 13:40:08 -0800, "Shawn Kralj"
<ShawnKralj@.discussions.microsoft.com> wrote:
>Hi
>I attempted to perform a simple mathematical operation (like dividing 10 by
>4) in a text box of a Table or body of a report and I end up with an integer
>result (10\4 gives me 2.0). I used convert method, CDbl method and I still
>get the same result. I formated the text box as N5, C2 and other formats but
>still the same result.
>The original problem is that the same thing happens with a report parameter
>when I try to use it in calculations but by troubleshooting the problem I
>realized that it happens in any text box.
>What am I doing wrong?
>Thanks
>Shawn|||Oooh , good catch.
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Sun, 14 Nov 2004 23:17:36 -0500, Dan Knight
<dknight@.REMOVEmullinixpackages.THIScom> wrote:
>>10\4 gives me 2.0
>If you are really using \ then you are getting the correct result. The
>'backslash' operator returns only the integer portion of the result.
>If you're expecting 2.5 as the result, then you have to use / instead.
>On Fri, 12 Nov 2004 13:40:08 -0800, "Shawn Kralj"
><ShawnKralj@.discussions.microsoft.com> wrote:
>>Hi
>>I attempted to perform a simple mathematical operation (like dividing 10 by
>>4) in a text box of a Table or body of a report and I end up with an integer
>>result (10\4 gives me 2.0). I used convert method, CDbl method and I still
>>get the same result. I formated the text box as N5, C2 and other formats but
>>still the same result.
>>The original problem is that the same thing happens with a report parameter
>>when I try to use it in calculations but by troubleshooting the problem I
>>realized that it happens in any text box.
>>What am I doing wrong?
>>Thanks
>>Shawn
Operations Master Question
At one of our locations I current have two domain controllers. One of which
serves as the RID and the Infrastructure, the other serves as my PDC. The
first PC also runs WINS and DNS.
Because of some new software that needs to be installed on a Non-DC server I
need to demote PC #2 to a member server.
So here's my question. Does my memory serve me correctly in thinking that I
cannot move the PDC operation to PC #1? I remember something of this sort,
but I can't remember the details.
Thanks.Um, this is a SQL Server newsgroup. You may want to try one of the Windows
newsgroups.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Preacher Man" <nospam> wrote in message
news:%23ltHePZXGHA.1352@.TK2MSFTNGP05.phx.gbl...
At one of our locations I current have two domain controllers. One of which
serves as the RID and the Infrastructure, the other serves as my PDC. The
first PC also runs WINS and DNS.
Because of some new software that needs to be installed on a Non-DC server I
need to demote PC #2 to a member server.
So here's my question. Does my memory serve me correctly in thinking that I
cannot move the PDC operation to PC #1? I remember something of this sort,
but I can't remember the details.
Thanks.|||Oops Sorry.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eVdSMsZXGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Um, this is a SQL Server newsgroup. You may want to try one of the
> Windows
> newsgroups.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Preacher Man" <nospam> wrote in message
> news:%23ltHePZXGHA.1352@.TK2MSFTNGP05.phx.gbl...
> At one of our locations I current have two domain controllers. One of
> which
> serves as the RID and the Infrastructure, the other serves as my PDC. The
> first PC also runs WINS and DNS.
> Because of some new software that needs to be installed on a Non-DC server
> I
> need to demote PC #2 to a member server.
> So here's my question. Does my memory serve me correctly in thinking that
> I
> cannot move the PDC operation to PC #1? I remember something of this
> sort,
> but I can't remember the details.
> Thanks.
>
serves as the RID and the Infrastructure, the other serves as my PDC. The
first PC also runs WINS and DNS.
Because of some new software that needs to be installed on a Non-DC server I
need to demote PC #2 to a member server.
So here's my question. Does my memory serve me correctly in thinking that I
cannot move the PDC operation to PC #1? I remember something of this sort,
but I can't remember the details.
Thanks.Um, this is a SQL Server newsgroup. You may want to try one of the Windows
newsgroups.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Preacher Man" <nospam> wrote in message
news:%23ltHePZXGHA.1352@.TK2MSFTNGP05.phx.gbl...
At one of our locations I current have two domain controllers. One of which
serves as the RID and the Infrastructure, the other serves as my PDC. The
first PC also runs WINS and DNS.
Because of some new software that needs to be installed on a Non-DC server I
need to demote PC #2 to a member server.
So here's my question. Does my memory serve me correctly in thinking that I
cannot move the PDC operation to PC #1? I remember something of this sort,
but I can't remember the details.
Thanks.|||Oops Sorry.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eVdSMsZXGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Um, this is a SQL Server newsgroup. You may want to try one of the
> Windows
> newsgroups.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Preacher Man" <nospam> wrote in message
> news:%23ltHePZXGHA.1352@.TK2MSFTNGP05.phx.gbl...
> At one of our locations I current have two domain controllers. One of
> which
> serves as the RID and the Infrastructure, the other serves as my PDC. The
> first PC also runs WINS and DNS.
> Because of some new software that needs to be installed on a Non-DC server
> I
> need to demote PC #2 to a member server.
> So here's my question. Does my memory serve me correctly in thinking that
> I
> cannot move the PDC operation to PC #1? I remember something of this
> sort,
> but I can't remember the details.
> Thanks.
>
Operations Master Question
At one of our locations I current have two domain controllers. One of which
serves as the RID and the Infrastructure, the other serves as my PDC. The
first PC also runs WINS and DNS.
Because of some new software that needs to be installed on a Non-DC server I
need to demote PC #2 to a member server.
So here's my question. Does my memory serve me correctly in thinking that I
cannot move the PDC operation to PC #1? I remember something of this sort,
but I can't remember the details.
Thanks.Um, this is a SQL Server newsgroup. You may want to try one of the Windows
newsgroups.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Preacher Man" <nospam> wrote in message
news:%23ltHePZXGHA.1352@.TK2MSFTNGP05.phx.gbl...
At one of our locations I current have two domain controllers. One of which
serves as the RID and the Infrastructure, the other serves as my PDC. The
first PC also runs WINS and DNS.
Because of some new software that needs to be installed on a Non-DC server I
need to demote PC #2 to a member server.
So here's my question. Does my memory serve me correctly in thinking that I
cannot move the PDC operation to PC #1? I remember something of this sort,
but I can't remember the details.
Thanks.|||Oops Sorry.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eVdSMsZXGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Um, this is a SQL Server newsgroup. You may want to try one of the
> Windows
> newsgroups.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Preacher Man" <nospam> wrote in message
> news:%23ltHePZXGHA.1352@.TK2MSFTNGP05.phx.gbl...
> At one of our locations I current have two domain controllers. One of
> which
> serves as the RID and the Infrastructure, the other serves as my PDC. The
> first PC also runs WINS and DNS.
> Because of some new software that needs to be installed on a Non-DC server
> I
> need to demote PC #2 to a member server.
> So here's my question. Does my memory serve me correctly in thinking that
> I
> cannot move the PDC operation to PC #1? I remember something of this
> sort,
> but I can't remember the details.
> Thanks.
>
serves as the RID and the Infrastructure, the other serves as my PDC. The
first PC also runs WINS and DNS.
Because of some new software that needs to be installed on a Non-DC server I
need to demote PC #2 to a member server.
So here's my question. Does my memory serve me correctly in thinking that I
cannot move the PDC operation to PC #1? I remember something of this sort,
but I can't remember the details.
Thanks.Um, this is a SQL Server newsgroup. You may want to try one of the Windows
newsgroups.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Preacher Man" <nospam> wrote in message
news:%23ltHePZXGHA.1352@.TK2MSFTNGP05.phx.gbl...
At one of our locations I current have two domain controllers. One of which
serves as the RID and the Infrastructure, the other serves as my PDC. The
first PC also runs WINS and DNS.
Because of some new software that needs to be installed on a Non-DC server I
need to demote PC #2 to a member server.
So here's my question. Does my memory serve me correctly in thinking that I
cannot move the PDC operation to PC #1? I remember something of this sort,
but I can't remember the details.
Thanks.|||Oops Sorry.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eVdSMsZXGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Um, this is a SQL Server newsgroup. You may want to try one of the
> Windows
> newsgroups.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Preacher Man" <nospam> wrote in message
> news:%23ltHePZXGHA.1352@.TK2MSFTNGP05.phx.gbl...
> At one of our locations I current have two domain controllers. One of
> which
> serves as the RID and the Infrastructure, the other serves as my PDC. The
> first PC also runs WINS and DNS.
> Because of some new software that needs to be installed on a Non-DC server
> I
> need to demote PC #2 to a member server.
> So here's my question. Does my memory serve me correctly in thinking that
> I
> cannot move the PDC operation to PC #1? I remember something of this
> sort,
> but I can't remember the details.
> Thanks.
>
Subscribe to:
Posts (Atom)