an indexed view cannot have functions applied to any of the columns,right? so the CASE and CONVERT statements in the query you posted will disqualify the view from being indexed,...

probably. If you can give an example of the unencrypted value / encrypted value as it would be processed from vb.net, we can see if there is a matching algorythm...

I see the execution plan returns 8 columns of data and 90 rows, but had estimated 237,932;

I see that WR_SCOPE_FITUP is actually a view of other tables; are...

interesting Pablo;

If i drag add existing tables that belong to a different schema, no problem;

creating them via the diagrams interface, you can't specify the schema, i agree.

I think you'll...

i see your point Chad;

I'd consider removing the table as well;'

for me, a phone number is an attribute of a person/location; so the attribute should stay with it's containers.

you could...

nested replace would probably be the easiest:;

you could substring it as well, because the desired string, including dashes will be 36 chars.

SELECT REPLACE(REPLACE('{784A4579-8689-438E-ADAA-9DCBC8A88AE7}','{',''),'}',''),

SUBSTRING('{784A4579-8689-438E-ADAA-9DCBC8A88AE7}',2,36)

Are all the tables the same layout/columns?

if they were, you could create One View to Rule Them All:

CREATE VIEW OneViewToRuleThemAll

AS

SELECT 'CLT123' AS ID, * FROM ClientTableCLT123 UNION ALL

SELECT 'CLT124' AS...

well, A: cannot be correct at all: a table doesn't have collation, only the columns in a table do(and only those that happen to be varchar/char/nvarchar/nchar)

D cannot be correct, becuase...

True story: my wife was miserable at her job; mean co-workers and the usual underpaid, overworked, underappreciated, story.

so I told her she should start shopping around, but not settling for...

well, the forum inteprets the escaped values as something it should render...whoops.

link to the function as raw text here:

HTMLEncode.txt

and here's a similar one i wrote long ago which converts things like © to the html entity ©

I think it was specifically due to XML:

CREATE FUNCTION HTMLEncode(@OriginalText VARCHAR(4000))

RETURNS...

i've put more than a few posts on the board here on SSC, so I've helped an aweful lot of people.

;

the best way to learn is to try. if...

both these posts looked way to much like homework;

I don't think the OP will learn anything if we do the work for him, without letting him learn the techniques.

it depends on what you mean by "month", either the number or the name:

there's some handy built in functions to help:

SELECT ContId

,CreditL

,CreatedOn,

MONTH(CreatedOn) As MonthNumber,

DATENAME(month,CreatedOn) As MonthName

...

i would swear i've seen this; i think it has to do with the account that is starting the service having the password/expired/changed.

i'm not having luck finding it in my...