if object_id('tempdb..#t') is not null DROP TABLE #t;

create table #t( str varchar(4000) );

insert into #t(str) values ( 'fox' );

insert into #t(str) values ( 'fox fox fox' );

insert into #t(str) values...

I can not .. Why ? The Catalog table is a table in the ReportServer.

I am sure if you do have SQLserver , the go the ReportServer database and...

Agree

Sorry , my mistake.

What I wanted was to get the path with out the file name .. So anything starting from char position 1 going all the way till we...

PLEASE IGNORE THE ABOVE POST...

I found the solution...( LISTED BELOW )

Thanks for reading

If object_id('tempdb..#t') IS NOT NULL DROP table #t;

CREATE TABLE #t( path varchar(255) )

INSERT INTO #t(...

Done! Works!

Thanks

Declare @SCHEMA VARCHAR(100);

Declare @TBL_PREFIX VARCHAR(100);

Select @SCHEMA = 'CLAIM'

Select @TBL_PREFIX = 'IMP'

DECLARE @sql NVARCHAR(MAX);

SELECT @sql = ( Select 'ALTER TABLE ' + TABLE_SCHEMA + '.' + table_name

...

Not sure since it produces more than one row as output.. Some help would be appreciated!

One more thanks.... LUIS

Your constraint allows me to add NULL values as well. I needed that !

Good job.. I tested the following code and it worked

CREATE TABLE CheckTest(

...

Thanks LUIS C

We both posted at the same time.

Thanks for the help

OK I got it .... The following function works... NOW I need SYNTAX help. How do we add this as a CONSTRAINT to a existing varchar column

ALTER FUNCTION...

Here.. Can someone help me with the syntax and I we can add the function as a constraint. I need someone to help me with the ID statement inside.

Now sure...

Luis C

I don't have control over the structure of the table the data is landing. They defined it as varchar(25)

I am good at writing functions but I am not sure...

Please IGNORE the above.. I found the answer...from another website.

THE TRICK is in the PROPERTIES WINDOW

The best way that I've found to accomplish this is the following:

I create a test...

I am pleased with the reply from Luis Cazares (8/1/2016).

That works fine for me.

No need to reply to this post anymore.

Thanks for stopping by

SELECT

R.SESSION_ID,

R.REQUEST_ID AS SESSION_REQUEST_ID,

R.STATUS,

S.HOST_NAME,

C.CLIENT_NET_ADDRESS,

CASE WHEN S.LOGIN_NAME = S.ORIGINAL_LOGIN_NAME THEN S.LOGIN_NAME ELSE S.LOGIN_NAME + ‘ (‘ + S.ORIGINAL_LOGIN_NAME + ‘)’ END AS LOGIN_NAME,

S.PROGRAM_NAME,

DB_NAME(R.DATABASE_ID) AS DATABASE_NAME,

R.COMMAND,

ST.TEXT AS QUERY_TEXT,

QP.QUERY_PLAN AS XML_QUERY_PLAN,

R.WAIT_TYPE AS CURRENT_WAIT_TYPE,

R.LAST_WAIT_TYPE,

R.BLOCKING_SESSION_ID,

R.ROW_COUNT,

R.GRANTED_QUERY_MEMORY,

R.OPEN_TRANSACTION_COUNT,

R.USER_ID,

R.PERCENT_COMPLETE,

CASE R.TRANSACTION_ISOLATION_LEVEL

WHEN...