Sel what I've done myself is to create a CLR function that returns RTF2Text, or vice versa;

that's the best way i know of, because the RichTextBox from windows.forms handles...

the barcodes i'm used to, like at the grocery store are basically a concatenation of a vendor number plus a product number;

ie 41415 -00106 is Eggs, Large at Publix Supermarkets,...

oops i missed that part;

doing something like SELECT RIGHT('0000' + SomeString,3) will give you stuff like 002 with preceeding zeros;

then it's the find and replace you were after.

i think this...

in my case, i don't use the @query parameter; instead i build a varchar max string, and append multiple FOR XML outputs to it.

I use that string for the @body...

sys.objects has the last time the DDL of an object was modified.

here's a simple example

SELECT

objz.create_date,

objz.modify_date,

SCHEMA_NAME(objz.schema_id) AS SchemaName,

objz.name

FROM sys.objects objz

--WHERE ...

ok, if you are sure there is always three sections to your ID's, here's one way to do it:

with myCTE (ID)

AS

(

SELECT 'AG001/1/P1' UNION ALL

SELECT 'AG002/1/P1' UNION ALL

SELECT 'AG003/1/P1' UNION ALL

SELECT...

glad i helped a little bit Jason! i fixed the link in my original post also, thank you!

I Tripped over this same issue myself, even wrote an article about it long ago(Reverse Engineering a Server Side Trace[/url])

this is a much-improved-since-that-article version of a proc I've created this...

whoops thought i had it...still looking

ok got it;

looks like you were starting to wrap the big query with SELECT * () ds

WHERE....

there's a beginning open parenthesis, but no select *...

i might be reading it wrong, but i think you just want to use either a CTE or a subquery, so you can further group your data;

something like this, maybe?

SELECT

...

ryan.mcatee (3/12/2013)

---

To clarify, say we have three tables:

schemaA.MyTable

schemaB.MyTable

dbo.MyTable

If my current-logged in user's default schema is schemaA and the default schema for the database is schemaB. And we create a...

the default DelimitedSplit8K is...

i would think it depends on the query; if the query is returning a million rows with text data, there's not a lot to do;

but depending on the query,...

ok dumb question time guys:

i also have 4 instances on my developer machine, for versions 2005 thru 2012.

when selecting the memory counters in Perfmon, i see instances for 2008, 2008R2...

actual foreign key constraints cannot expand to objects outside of the existing database.

you could potentially create a user defined function that is used as a CHECK CONSTRAINT, which checks if...