you need to use a three part naming conventions which includes the schema:

testdb.dbo.Rfunctioname

testdb..Rfunctioname

you also may run into permissions problems, as the person calling the procedure or code needs access to...

i would go with explicitly identifying the collation in the statement;

here's some code examples you can copy and paste to see the issues:

an empty table with no data at all...

i had to wrap you r example a couple of times to get it to return an empty string instead of null;

does this help at all?

declare @id int

set @id...

there's a good article here on SSC by Brian Kelly that covers allof the tools i've ever used for finding sql servers:

.

Tools I Use to Scan for SQL...

Luis's /Seans's suggestions will perform the best;

if you want to stick with a scalar function, this post has a function fn_parsename, which fidns values form left-to-right, where the original parsename...

you skipped the second part of my question:

... are you sure you don't need to insert new rows, or are you sure you need to update the existing table?

if you...

mcfarlandparkway (12/18/2013)

---

I have two tables

select * from snsystemcertification

where fiscalyear=2013 and IsActive=1

--282 rows

select * from SNLunchSevereNeeds

where HHFKOverride=1 and HHFKProcess=1

--430 records

--Need to check the list who are eligible for...

it might be easier to just query the active directory from SQL via a linked server.

then the pieces can be pulled out automatically;

does this help you at all? it just...

bharat sethi (12/18/2013)

---

Hi! The data is not going to a web page. It's a SSIS package which process this task and then provide this data to sucessor tasks or other...

it depends on how you design your package; you need to avoid any RBAR processing within the package itself.

http://www.sqlservercentral.com/Forums/Topic362049-148-1.aspx#bm1174434

---

http://www.sqlservercentral.com/Forums/Topic362049-148-1.aspx#bm1174434

The SSIS is using streaming approach (processing blocks of data) and...

the STUFF command can help you with that one:

CREATE TABLE #tmp(ID int identity(1,1) not null primary key,[SampleString] varchar(150))

INSERT INTO #tmp(SampleString)

SELECT 'this is a test, hello World 4.2 test' UNION ALL

SELECT...

what if you change the Or to be two distinct update statemetns instead?

DECLARE @date DATETIME = '09-Dec-2013'

--part1

UPDATE #tmp_sp_abc

SET test = RTRIM(xyz_test)

FROM

#tmp_sp_abc t1,

t_h_bg_pc_it t2

WHERE...

if you are selecting all rows(we still didn't see the query, which might be improved), then you can't speed it up...

well you are assuming based on your formatting that you'd never have more than 10 people with the same name(xxx09);

i'm providing an example below, but i don't think like the...

using collation is the key here; here's two adaptation from my snippets for you to play with:

--find anything that has lower case in it at all.

select * from member where...