Change the Join to an In statement with a sub-query of the Address table.

What you're looking for is "dynamic cross-tab". Do a search for that. Phil Factor has an article on it on simple-talk.com, and Jeff Moden has one on this...

Have you contacted local recruiting agencies (headhunters) to see what they can find for you?

(As an aside, noting where you are, at least the country and region, might help people...

Actually, the main use of BCP is to import and export data to and from text files. It's got other uses, but that's probably 99% of what it gets...

create table #T (

ID int identity primary key,

Members varchar(100));

insert into #T (Members)

select '1/2/3' union all

select '2/3/4';

select ID,

case Parsed

when 1 then 'Father'

when 2 then 'Mother'

when 3 then 'Sister'

when 4 then...

I have to admit, I use xp_cmdshell for this one.

Turn it on, run the command, turn it back off. That keeps it secure.

"d5" means "decimal 5", similar to scientific notation. It means "26 followed by 5 zeroes". That's a number.

It's one of the main weaknesses of IsNumeric.

Sometimes, you have to...

Is the purpose of this query to get the number of addresses for a company?

Per Books Online:

Fragmentation alone is not a sufficient reason to reorganize or rebuild an index. The main effect of fragmentation is that it slows down page read-ahead throughput during index...

It means your first inner select is returning more than one row in at least one case.

Turn it into:

select t1.seq, t2.seq

from t1

inner join t3

on t1.obj_num = t3.obj_num

and t1.name = t3.name

inner...

Try this:

SELECT

CONVERT(VARCHAR(12), PRPHourlyEnd, 112) + 'PR' AS PRBatchID,

EmpLname,

EmpPayrollnum,

CASE WHEN PREarnCode IS NULL

...

Steve: Might want to remove that image. This site doesn't validate age of people with accounts, and it also could cause some work issues.

Phil Factor (11/9/2009)

---

Ah. I think I can see an ambiguity here. Asking the question "Can you name someone in this particular book 'coders at work', and what they're famous for?"...

You can use the Execute Package task to execute other SSIS packages.

So long as you update the referenced copy of the package, yes, it will stay synchronized. (Since you...

Phil Factor (11/9/2009)

---

The quote said "If the next programmer you interview can't identify at least one of the programmers interviewed in Coders at Work and tell you roughly what they're...