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...

you posted in SQL2000, so be aware that if you meant 2008 or above, the ACE drivers would b eused instead.

typically, you will create a linked server, and reference...

take a look at this post i participated in a while back; it's got some handy code for finding all invalid objects, which would happen on procs/functions/views if the underlying...

i'd say it's a bad trigger.

it does not handle multiple rows at all.

there may be a logic hole here as well: it updates the entire contact2 table for any row...

seven columns in the table, only six in the query;

your table has the column name Logintime , but your query does not.

the implied column list, for when you say...

Mani-584606 (12/17/2013)

---

Thanks Keith,

The script is giving database level permissions. I'm looking entire instance level.

For example the user has read on one database and write on another database and has view...