here's an example of how two seemingly different queries can be combined as a function without using dynamic sql;

the param being passed decides which results to return. this might give...

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