the example you found from simpletalk

http://www.simple-talk.com/code/WinWord/spExportToWord.txt

has nothing to do with mailmerge; it's just an example automating the population of data into a word document;

worse, you didn't modify it...

I dont believe you can.

You cwn open word and use word to select a datasouece which is on a sql server.

But sql has no way to call word and...

mrTexasFreedom I'm glad my code helped a bit, but mister magoo really identified the culprit, i think;

some process imported(and maybe still imports) data that should be nvarchar instead of varchar;...

got your fix right here:

ok just checking the basics here;

I'm assuming you are reviewing the code in SSMS? by default, to save memory, SSMS limits results to the first 256 characters...have you already changed...

glad this post helped you out!

or another version: a scalar function that would remove anything that was not A-Z/numeric:

same basic logic, i think:

select

id,

name,

dbo.StripNonAlphaNumeric(name) As Fixed

from my_user_table

If that's cleaning up...

Ells (1/18/2013)

---

Are my assumptions correct in that a deny would for USerB overrule the access that it had as USerN and as a member of RoleA?

Its mainly the difference between...

REVOKE would remove a GRANT from the permissions matrix (if it existed). In my head, i think "UN-GRANT"

DENY would add a new entry to the permissions matrix, and prevent access,...

i believe there is a bug in the ACE drivers which affects Access but not Excel, even if you've installed the 64 bit versions;

there's a connect item on it with...

SQL2012/2008R2/2008 Express is free, allows a database of 10 gig, and is much much easier to use than CE;

CE is a very trimmed down database version that is aimed towards...

without the code i mentioned previously, it's really hard to guess;

since i cannot test this,...

the cursor is your # 1 performanceproblem then.

i'm sure you can replace it with a set based function:

if you are doing the same logic to each row in the cursor,...

well, the obvious fix is to use an Inline Table Valued function instead of a scalar function;

i was able to convert it easily, but the example usage you pasted is...

and some ready made code to test it: creates a rule and a column that uses it:

CREATE RULE [dbo].[NumericCharsOnly]

AS

--@value NOT LIKE '%[0-9,-+]%' ESCAPE '!' --bad way...minus and spec...