Scott Ohar (9/18/2008)

---

Service Pack 2 Failed

Product : Database Services (MSSQLSERVER)

Product Version...

That would indicate a priviliges issue - try creating a new job (doesn't have to have anything in it or be scheduled) and see if you get any errors.

The concatenation operator in SQL Server is the plus sign (+). Change your formula to ([STATE_ID] + [COUNT_ID]).

I wouldn't say that - I didn't see it the first time through either. 😀

BTW - with that condition I would be verifying the table for DRI and/or triggers...

Step 1: Import Excel spreadsheet into SQL Server

Step 2: Write update script to use data in imported table

Basic structure of the script would be something like:

BEGIN TRANSACTION;

SELECT * INTO dbo.Report_T_Backup...

Try running the following query:

SELECT ChargeCodeDE, count(*)

FROM Charge_Code_Fee_Schedule

WHERE EffectiveEndDT IS NOT NULL;

For every row that has a count > 1 - you will have a problem. Now, change...

Version 9.0.3054 is service pack two with a small patch to fix some problems with maintenance plans. You can find more information at:

http://support.microsoft.com/kb/934458

This contains a link to the update...

If you cannot see SQL Server Agent, then one of two things comes to mind. Either you are connecting to a SQL Server Express Edition (does not have SQL...

Well, you didn't include the insert portion of the procedure - but I am not sure that is needed in this case.

My guess is that for some Charge Codes -...

What you did was show the version of SQL Server that you were connected to. To see the version for your client tools - click on Help | About.

Version...

Just one note on 'sp_updatestats'. By default, this will update statistics using the default sample rate. If you pass in the parameter @resample = 'RESAMPLE' - then the...

The database file will not become smaller just because you truncated a table within the data file. If you do not have any issues with disk space - I...

Look on this site for Tally table and/or Calendar table. Either of those articles will show you how this can be accomplished.

t-pinto (9/16/2008)

---

Hello,

I have an alias for 2 calculations. I would like to filter only those results that are >1000.

Here is my statement.

Select InvoiceTotal,

InvoiceTotal*(.10) as "10%",

InvoiceTotal+(InvoiceTotal*(.10)) as "Plus 10%"

From Invoices

Where...

Another option (possibly) would be to use synonyms in each database. Part of your script would be a check for the synonym, and if it does not exist -...