Hi,

Basically I need to know which of these jobs are connecting to which servers when the job step runs a T-SQL script or when running a ssis package?

Is this possible...

Hi IgorMi this will not work, thanks though!

Thanks dwain.c !

Exactly what I need, nice work!

Hi,

How do you do the CTE? As I would like a flag field?

Thanks

Hi,

I don't want to alter any table, I want this done by a sql select statement only? Plus this would not work as only want it to appear as Yes...

Hi,

No problem, where do I find this attached zip file?

Thanks

Firsly I got the following message when trying to create the table SCF_Invoices

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '('."

Which I then amended the script and...

Any experts out there, that can advise?

What if the table does not have a index or primary key? I take it the above sql will only work if it has this?

Sorry what is the above meant to be saying to me?

Hi,

Can you not add a update statement at the end of the package, which update all that column and removes any pipeline characters?

update yourtablename

set yourcolumnname = REPLACE(<columnname>,char(124),char(32))

Hi,

I have taken CHAR(13) off from query now and still works, so the sql query looks like the below now:

DECLARE @SQL NVARCHAR(MAX)

SELECT @SQL = substring(REPLACE(

CAST(

(

SELECT ' UNION SELECT * FROM...

Hi, I have amended your code so that all appears in one select statement.

DECLARE @SQL NVARCHAR(MAX)

SELECT @SQL = substring(REPLACE(

CAST(

(

SELECT ' UNION SELECT * FROM ' + QUOTENAME(name)

--Select *

--'SELECT...

Nice one Thanks!

Hi,

Thanks for quick reply, when I ran this I am getting unknown characters which does not work when I execute the SQL for this:

USE [master];

SELECT * FROM INFORMATION_SCHEMA.COLUMNS