i'd want to see the proc, i's quite possible whatever you are doing does not have to be done with dynamic sql.

it's possible to create a view that has...

glad i could help!

yes you can; the correct syntax is below;

note i added a suggestion to make it cleaner and easier to read:

select

CASE

WHEN SCE_AYRC = '05/06' AND C.MAV_BEGW IN('36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52')

THEN '06/07'...

i think this will do what you are after; this leaves 0-9,A-Z,a-z and strips out everything else...commas,punctuation, hi ascii, etc.

select dbo.StripNonAlphaNumeric(address1) from #addr

--results

53240thaveneapt104

1000sectorwaystapt111ac

3333summerpointplace

pobox22000a330042

5566firststettnlot204aapt2c

select ascii('a'),ascii('z'),ascii('A'),ascii('Z')

GO

CREATE FUNCTION StripNonAlphaNumeric(@OriginalText VARCHAR(8000))

RETURNS VARCHAR(8000)

BEGIN...

this is a common security issue. The problem is that when you access any resource OUTSIDE of SQL server, like network shares, local hard drives,sp_OA type functions etc, it doesn't...

mikelordi2 (3/23/2010)

---

We are int he process of implementing a new procedure whereby we take client flat files, perform transformations on the data using both derived functions as well as reference...

for me,trolling through the forums here on SSC, i literally copy and paste every example that interests me into a SSMS window and run it.

that's why everyone encourages(demands?) that...

the devil is in...

andrew in my sql 2008 db, if i create a diagram, then a single row is created in the table dbo.sysdiagrams.

select * from dbo.sysdiagrams

name ...

you can do it with a tally table as well;

for example the function I'm pasting below will strip out everything except chars in my specific range of ascii characters:

--ascii...

Thank you for the salute Jason and Thanks for identifying the fix, Chris;

Something that might escape some folks is did you know that C2 auditing is just another version...

i think you want something like this, but the key is which column has the "status", and it's data type:

i assummed a string field, but you'll get the idea once...

duplicate post.

continue reading here:

http://www.sqlservercentral.com/Forums/Topic887248-391-1.aspx#bm887384

duplicate post.

continue reading here:

http://www.sqlservercentral.com/Forums/Topic887248-391-1.aspx#bm887384

with stored procs, it's a best practice to add SET NOCOUNT ON as the first line of the proc;

this prevents other applications from thinking subsets or commands like (x...