Try using case like this:

;

with mycols(ID, colvalue1, colvalue2, colvalue3)

AS (SELECT

...

Sounds to me like you need to buy a dedicated server for that application and let the outside developers manage it, since you can't put it on an existing SQL...

Sam,

You shouldn't run the Shrink Database command. That is the point that Jeffrey and Tim were trying to make in their posts.

As mentioned the only time you...

Lynn Pettis (5/22/2009)

---

I actually think that is one of the reasons I LIKE soccer, there are no instant replays, the referee and his assistants have to make the calls in...

Have you verified that the Data Source was deployed? If it was deployed, was the User Name and Password saved?

Jan Van der Eecken (5/22/2009)

---

Now, that' a very interesting approach. Could have never thought of that myself. Kill SQL, then copy...

By using the UDF SQL Server has to call the UDF for each row in returned, while the UPPER() function is optimized.

If you need to use the function you would...

Can yo create a linked a server from the SQL Server to ORACLE using that driver?

Have you verified that the ORACLE oledb provider is installed on the SQL Server? Have you checked for a 64 bit driver?

There is not a subquery in the code you provided.

Please include the ALL code you are running that produces the error.

I'd also be concerned that this trigger, and I would assume the others, only handles a single row delete. What happens if there is a set-based delete?

I'd...

Without backups you will have to rebuild msdb. Check out this article.

Do you have the FailPackageOnFailure property of the dataflow task set to false?

SQL Server is doing the conversion BEFORE any filtering. Since you are OR'ing the criteria I would recommend using UNION ALL like this:

SELECT

M.modelid

FROM

...

Here's one way:

CREATE TABLE [dbo].[ES]

(

[ID] [int] NOT NULL,

[Wages] [char] (8) Null

)

CREATE TABLE [dbo].[Master]

(

[ID] [int] NOT NULL,

[Wages] [decimal](9, 2) NOT NULL

)

INSERT INTO dbo.ES (

ID,

Wages

)

SELECT

1,

...