compulsive personality. I see an article that interests me and stick around answering questions for a few days then find something else...

ok now I have this.

update tb_leadbox set invalidflag=6 where

uid2 not in

(select uid2 from (

select min(uid2)as uid2,fname,lname ,homephone from tb_leadbox where entrydate >= dateadd(dd,-365,getdate())

group by fname,lname,homephone

) t2) and invalidflag in...

should have mentioned this is SQL7 and upgrade is not a possibility.

I use Outlook 2000 and have the same formatting issue.

Hi mrpolecat, A new reply has been added by Vladan to a topic your subscribed to. You can view the reply...

you could test it by raising an error or change the smtp server in the code to an invalid mail server to force an error to occur.

you are correct about the typo.  Since this is sample data we'll go with an incorrect result set, which makes your result set correct. You are also correct that random...

The agent usually runs under a different user tham SQLSVC.  You can check this by right clicking on the agent. Make sure the account it is running under has the...

Server 1-Count is how many areas are at level 1 (red) for that server

Server 2-Count is how many areas are at level 2(yellow) for that server

Server 3-Count is how many areas are...

what you want is a pivot or crosstab query and there are lots of post about dynamically creating them on the forum.

The static version for this task looks like this:

select...

Loner-

In tableB the combination of cutomernumber and store is unique.  It was created from a transaction table that contained a date and time for each store use.

I want the primary...

a customer number is an integer, a store number is an integer, storeusedtimes is an an integer

Table A

CustomerNumber,Store Number

1,1

2,1

3,2

4,4

5,2

TableB

CustomerNumber,StoreUsed,TimesUsed

1,1,5

1,2,5

1,3,1

2,1,1

2,2,1

2,3,1

3,2,1

3,5,5

3,4,5

4,1,1

4,2,2

4,3,3

Results

CustomerNUmber,StoreMostUsed

1,1 PrimaryStore in tie

2,2 Primary Store in tie

3,5 PrimaryStore not in tie

4,3 No...

Here is an articel on numbers tables

http://www.sqlservercentral.com/columnists/mcoles/2547.asp

a vbs script sets a global variable to create your tablename.

ww= datepart(ww,date())

DTSGlobalVariables("importpath").Value = "\\import path to file\"

DTSGlobalVariables("exportpath").Value = "\\export path to file\"

DTSGlobalVariables("importname").Value = "w" & ww &...

If they are not huge files a vbscript activex could be used to cycle through the records and separate them into individual files for import.

Can you post a sample of your data file to test with?