You may want to view this page

http://msdn.microsoft.com/en-us/library/218s85f8.aspx

to see a list of non-printable characters

It has been 7 hours since you posted your question with no answers.

Let me ask:

Have you looked at:

Impersonation

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/scsql9/html/dc049e56-b210-47f9-815a-a03b9ef7b6ba.htm

and / or the "Execute As"

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2c7004bf-9385-429e-a616-9bd7a7b19978.htm

subjects in Books on Line?.....

May I suggest that you read Books On Line (DDL Triggers) starting with

http://technet.microsoft.com/en-us/library/ms190989(SQL.90).aspx

This will lead you to other pages which are quite specific, with example code, which I hope will...

Per Jeff's comment here is my second attempt to show the function. As a side comment on my local machine openning the .txt file or even when it was...

bkmooney

Nice function and reasonably well commented. May I suggest adding the url for Jeff Moden's page -- as a comment of course. By this time next year if...

Like most items in SQL Server the answer is "It depends".

a. Is the SP reporting an error?

b. Is the SP returning invalid / incomplete data?

Using SSMS

In either case...

Suggest you read this SSC article

http://www.sqlservercentral.com/articles/Product+Reviews/sqlcomparereview/272/

And then go to the REDGATE software web site and do some reading.

http://www.red-gate.com/products/SQL_Compare/index.htm

Pbreitenbeck

I posted to the incorrect forum YOU DID NOT.

And thanks about the bug in the signature block, it used to work and I have cut and pasted the correct url...

Wahkna.

May I suggest that you look at Books On Line (BOL) at

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/4534b705-d946-441b-9b5d-5fbe561c9131.htm

for examples of how to use the AVG function available in SQL Server.

knowing how your dates are...

May I suggest your reading the following. The first is by Jeff Moden and is EXCELLENT

http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/

http://www.sqlservercentral.com/scripts/DateDiff/63346/

Sorry original posted to incorrect forum, my apologies

The answer like most answers to SQL questions is "That depends"

These 2 BOL pages should give you the guidance you need for your databases.

1. To understand the...

Jeff - you are kidding aren't you?

Alright... how'd ya do it? How'd you get that right parenthesis to hang out in mid air like that without it turning into...

May I refer you to Jeff Moden's excellent articles here in SSC

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/cross+tab/65048/

You might want to read this article:

http://support.microsoft.com/kb/154886

for how varchar values are stored. It also contains very simple sample code so that you can test and view the results...