I am an SQL Dummy!

In the old 2008 version of SQL I had to run a script to fix a rounding error in my Microsoft Accounting software (no longer supported)  I think I have version 10 now?

SQL FIX for Fiscal Year won't close

Need to use Sql Management Studio (as oppose to more obscure osql.exe)

to run sql script

b) Use Sql Management Studio to execute script below:

SELECT *

FROM dbo.CashPostingTable

WHERE (amountcredit <> amountCreditCompanyCurrency OR amountDebit <>

amountDebitCompanyCurrency) AND exchangeRate=100

If you get any rows/data back, proceed to step c), if no result, a more

serious problem - good lucks or buy help.

c) Use Sql Management Studio to execute script below:

UPDATE cashpostingtable

SET amountCreditCompanyCurrency = amountCredit,

amountDebitCompanyCurrency = amountDebit,

companyAmountRemainder = accountAmountRemainder

WHERE (amountcredit <> amountCreditCompanyCurrency OR amountDebit <>

amountDebitCompanyCurrency) AND exchangeRate=100

Management Studio no longer works.  Is there a way to do the same thing in the version I have?

Thank you,

Dean

• Moved by Alberto MorilloMVP, Moderator Sunday, February 01, 2015 12:40 AM More relevant forum

In the old 2008 version of SQL I had to run a script to fix a rounding error in my Microsoft Accounting software (no longer supported)  I think I have version 10 now?

SQL FIX for Fiscal Year won't close

Need to use Sql Management Studio (as oppose to more obscure osql.exe)

to run sql script

b) Use Sql Management Studio to execute script below:

SELECT *

FROM dbo.CashPostingTable

WHERE (amountcredit <> amountCreditCompanyCurrency OR amountDebit <>

amountDebitCompanyCurrency) AND exchangeRate=100

If you get any rows/data back, proceed to step c), if no result, a more

serious problem - good lucks or buy help.

c) Use Sql Management Studio to execute script below:

UPDATE cashpostingtable

SET amountCreditCompanyCurrency = amountCredit,

amountDebitCompanyCurrency = amountDebit,

companyAmountRemainder = accountAmountRemainder

WHERE (amountcredit <> amountCreditCompanyCurrency OR amountDebit <>

amountDebitCompanyCurrency) AND exchangeRate=100

Management Studio no longer works.  Is there a way to do the same thing in the version I have?

Thank you,

Dean

• Moved by Kalman TothEditor Saturday, January 31, 2015 9:40 PM Better fit
• Merged by Alberto MorilloMVP, Moderator Sunday, February 01, 2015 12:36 AM Duplicated thread

1.  Sorry

2. I think version 2012.  I don't know where / how to run select@@version

3. I am not able to load Management studio. I also have

4.  No error message I just can't find it.  Looked at Microsoft info on web and it says run

I tried the OSQL command as shown below and I can't get that to work either.

When I run osql I get a long message about osql not supporting all features of SQL server 2008 use sqlcmd instead.

When I run sqlcmd -i C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSMLBIZ\MSSQL\Data\classicboatworks61.sbd

I get an invalid filename message.

I want to run this script:

UPDATE cashpostingtable

SET amountCreditCompanyCurrency = amountCredit,

amountDebitCompanyCurrency = amountDebit,

companyAmountRemainder = accountAmountRemainder

WHERE (amountcredit <> amountCreditCompanyCurrency OR amountDebit <>

amountDebitCompanyCurrency) AND exchangeRate=100

which fixes a rounding error and allows me to close my Fiscal Year.

3. I have visual studio installed but it does not show on my Start / Programs list

4. Microsoft says run "set up" to add Management Studio (does not show on program list) but couldn't make that work either

4. run: sqlcmd -i C:\\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSMLBIZ\MSSQL\Data\classicboatworks61.sbd

"Invalid Filename"

You can download SQL Server Management Studio from this link:
http://www.microsoft.com/en-us/download/details.aspx?id=43351

You should select one of the SQLManagementStudio files.

SQLCMD  -Q "SELECT @@VERSION"

SQLCMD -i "C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSMLBIZ\MSSQL\Data\classicboatworks61.sbd"

SQLCMD -Q "SELECT @@VERSION"

Judging from the path that Dean posted, this should probably be

SQLCMD -S .\MSSMLBIZ -Q"SELECT @@version"

Success!

Thank you All...

I finally got SQL Management Studio installed then followed the directions of how to run a script found here: https://hiskb.healthcois.com/KnowledgebaseArticle10340.aspx

Once I ran the script the data base is fixed and working properly.

Thanks again, I could not have done this without your help.

Dean

• Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator 4 hours 55 minutes ago

SQLCMD -Q "SELECT @@VERSION"

Judging from the path that Dean posted, this should probably be

SQLCMD -S .\MSSMLBIZ -Q"SELECT @@version"