CONVERT_IMPLICIT is a custom stored function ?

You probably need to expose the columns specified in the function to eliminate this message.

Quick answer:

Desperately trying to avoid "catalog clutter" with stupid tables that show no real business purpose.

In this case, these are tiny tables that have meaning only during processing.

More importantly, why...

Brilliant, brilliant, brilliant.

In that way, I only have a small amount of dynamic SQL to build...

Thanks Lowell, and we are considering creating the cataloged tables.

The Tempdb option won't work since all of the databases would share the same table....

and that table would need to have...

Gail - I ended-up using a constraint instead of a unique index.

CREATE TABLE [dbo].[CONTROL_FACT](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CTRL_ID] [int] NULL, -- 1

[CTRL_KEY] [varchar](50) NULL, -- 'TARGET_LAST_UPDATE'

[CTRL_VALUE] [varchar](1000) NULL, -- '2015-11-03',...

Thanks Gail -

I think that computed column with unique index is the best approach.

From what I've gathered, filtered indexes can only be created with filters on a single column.

Now I have a new problem.

I want my table to have two "keys", one integer, one string so that a value can be accessed by either.

I have solved the problem...

Guys - I figured it out !!!

We had 3 separate databases ON THE SAME SQL SERVER INSTANCE !!!

Each database was trying to delete and then re-create that global temp...

Lowell - thanks much for that.

I think what is happening is that Pentaho is losing the connection to our SQL Server instance....

Thanks for that Sean....that's been my inclinaton as well.

PDI in release 5.3 has been so "glitchy"....just tons of small issues.

The strange thing about this is that "prepareExecution" method in...

Thanks, wasn't sure if the following syntax was supported or not....

CONSTRAINT C_KEYS CHECK (CTRL_ID IS NOT NULL OR CTRL_KEY IS NOT NULL),

Yes I did Jeff and it is showing up when I go:

Help,Manage Help Settings, Choose online or local help

And when I click on "Check for Updates", It says "Books Online...

Wow, thanks for that Lowell....nicely done !

Now I need to look into:

1) establishing and configuring my mail profile

2) scheduling the report via SQL Server Agent.

TO: user1;user2;user3

FROM: admin@xyz.com

SUBJECT: Hourly Report For 9 am : CORE 13 (+2) UPSELL 5 (-1)

BODY: embedded reports in HTML format - cell phone friendly

Note: There is nothing stupid...

We ended up purchasing Red Gate's SQL Compare utlility.

Very fine product indeed !!!