I mean then I can just pass the query to our DBA team and have them run the query. I myself don't have the rights to query the dm_exec_connections

I...

Would you mind writing to the query for me please ? Or else thx.

EXEC sp_MSforeachdb 'SELECT "?" AS DB, * FROM [?].sys.tables WHERE name like ''%HENCDP%'''

This works fine

To: RVARN:

Example -

ALTER TABLE employees

ADD CONSTRAINT check_value

CHECK (fieldname IN ('Y', 'N', NULL));

--The above does not work. It allows any value. The trick is you need to take that...

See the attached, If that helps you.....

It is a parameter of type string. It has a path and name of the output file.

So the value of this variable will be used by the ConnectionString property.

YB:

This is not for display purposes.

It is for a TAB delimited file that goes to another company.

I am not sure why they can not handle dates in the mm/dd/yyyy format.

I...

Good!

At the same time how would I decrypt the hex value back to normal text

The good thing about using the master.dbo.fn_varbintohexstr is that you are

able to directly insert that...

Good, I think I mentioned the same when replying..

The reason NULL was used is because every person in the table who had any other plan other than the 2 that...

Not quite...

What I was looking was a way to get that value but without having to hard code the value inside the code.

I was thinking whether there was a...

Good,

I was also asked to use the LTRIM(RTRIM( around the fields so that there be no spaces around. How can we handle that ?

Thx,

i found it on google

SELECT TABLE_NAME as ViewName,

charindex('fnGetProviderHoursByProviderNo', VIEW_DEFINITION, 1 ),

VIEW_DEFINITION as ViewDefinition

FROM INFORMATION_SCHEMA.Views

where

charindex('fnGetProviderHoursByProviderNo', VIEW_DEFINITION, 1 ) > 0

Folks,

You may ignore this post from now.

I did find my solution. Works well!

Select

member_id,

COUNT(*) as CNT,

MAX(RIGHT(the_month,2)) as MAXMON,

SUM( CAST(RIGHT(the_month,2) as int ) ) as SUM_OF_MONTH

FROM

#coverage

WHERE

RIGHT(the_month,2)...

Well, there will not be a continuous range of dates for each grouping. That is the challenge here. Some members have coverage all the way up until 201512.

Others have some...

Found the issue....

This has nothing to do with my programming. It is an issue with VS2012. The following gives us a fix. I ran the steps as listed and managed...