Your sample data makes it tough, but here is my shot at it:

SELECT

CASE WHEN T1.BUTY = 'AD' THEN REPLACE(T1.SUBTYPE, 'EQUIPMENT P&L', 'OTHER DIRECT COSTS ')

...

When you say replication, do you mean repeated rows?

You...

One of the first things you will need to do is to set up comparisons between sales, orders, and store volume.

For example,

Stores over 10k in volume:

Sell 5k of fries,...

That is the proverbial horse of a different color!

As for getting more memory from the admins, I have no advice other than begging and pleading.

Good luck!

What is missing in this calculation is attention to the disk subsystem. I have worked on far too many systems that have been configured with little attention to the...

Unless a column with an IDENTITY is defined as a primary key...

Can you right click on the job a create the scripts?

wenkat_j (3/7/2011)

---

Can any one help me on this syntax,I refered everywhere it seems to right.

(T3.lastchangedtimestamp between

ImportFromDate=? and ImportToDate=?)

these two parmeters are already defined in the datastage .

any...

Do you possibly have two schedules that are running at the same time?

How about:

CREATE TABLE Junk.dbo.SchemaTest

(

Database_Name varchar(200),

Schema_name varchar(200),

Schema_Owner varchar(300)

)

sp_msforeachdb "USE [?]; INSERT INTO Junk.dbo.SchemaTest SELECT CATALOG_NAME, SCHEMA_NAME, SCHEMA_OWNER FROM INFORMATION_SCHEMA.SCHEMATA"

This error can be a couple things, none of which are obvious.

You didn't say if this happens every time, or is intermittent. What is the OS? If it's Windows 2008,...

Same server, same database, same everything.

We tweaked some of the things in the report, such as sizing all of the text boxes properly and turning off CanGrow and CanShrink,...

Here's a thought.

1. Change the table to include a "database indicator" to hold the C or T values.

2. Make the version an integer.

3. Stop using the function and...

I have seen this regularly, and it can be a pain to solve without a lot of trial and error. I am struggling with it right now on a...

I looked in the registry, and in almost every file I could think of on the drives, and under the rock in my backyard. I couldn't find it.

...