Viewing 15 posts - 7,831 through 7,845 (of 14,953 total)
Change the Join to an In statement with a sub-query of the Address table.
November 9, 2009 at 2:12 pm
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...
November 9, 2009 at 2:11 pm
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...
November 9, 2009 at 2:08 pm
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...
November 9, 2009 at 2:07 pm
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...
November 9, 2009 at 2:04 pm
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.
November 9, 2009 at 1:58 pm
"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...
November 9, 2009 at 1:56 pm
Is the purpose of this query to get the number of addresses for a company?
November 9, 2009 at 1:51 pm
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...
November 9, 2009 at 1:37 pm
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...
November 9, 2009 at 12:59 pm
Try this:
SELECT
CONVERT(VARCHAR(12), PRPHourlyEnd, 112) + 'PR' AS PRBatchID,
EmpLname,
EmpPayrollnum,
CASE WHEN PREarnCode IS NULL
...
November 9, 2009 at 11:46 am
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.
November 9, 2009 at 10:02 am
Phil Factor (11/9/2009)
November 9, 2009 at 8:20 am
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...
November 9, 2009 at 7:37 am
Phil Factor (11/9/2009)
November 9, 2009 at 7:26 am
Viewing 15 posts - 7,831 through 7,845 (of 14,953 total)