Do not know much about image columns (do not use them myself) but I believe the only way to read and write image columns is to use READTEXT and WRITETEXT.

In...

Great.

If you want to process the late renewals you can use

CASE WHEN (@WeekNo - 2) < 1 THEN (@WeekNo - 2 + 52) ELSE (@WeekNo - 2) END

and change the...

WHERE SU_RenewalWeek = (CASE WHEN @WeekNo > 50 THEN (@WeekNo-50) ELSE (@WeekNo + 2) END)

will cater for @WeekNo+2 for weeks 51+

Can u explain what you are trying to do for

'This...

Not pretty but give you what u want

declare @d datetime

declare @w int

set @d = '2003-01-01'

set @w = 5

set datefirst 1

set @d = @d-(datepart(dw,@d)-1)

select @d+((@w -1) * 7),(@d+((@w -1) * 7))+6

...

I would use

bcp "select icol1,col2 from databasename..tablename" queryout filename.csv -c -t "," /S servername /U username /P password

But as Guarddata stated, maybe DTS would be better.

I would not update Person each time but use the input to identify the record to get the PersonID for the insert into the Task table. I would supply a...

When I wanted to output data to several text files I used ISQL.

Do not know of a way to insert multiple records without selecting from another table.

You could create a permanent table with the maximum number of entries and then select from...

Clive,

I answered your query on another thread but there seems to be a common problem with cdosys and attachments. Many people have posted their procs on this site and I...

Need to add another subquery

select count(*) from (select candidateid,count(*) as 'skillct'

from (select distinct candidateid,skill from #skillset) a

where @list like '%'+skill+'%' group by candidateid having count(*) = @kount) b

Rachel r u still having problems. Can u post more info, SQL version, bcp command line parameters (without security info) etc. Anything would be of help.

Thats great and speaks a lot about yourself and your honesty. As I explained I call my a DBA in title only, I too am only starting on this long...

Nice post Tim. I too have to learn in my own time as well (VB, VC++, TSQL, HTML etc) and been using SQL since 6.5. I think you probably undersell...

There are several threads on this site referring to your query and most seem to be attachments. I used the following snippet to add an attachment

EXEC @hr = sp_OAMethod @iMsg,...

Assume you pass skill list and count of skills then try

declare @list varchar(100),@kount int

set @list = 'xml,oracle'

set @kount = 2

select count(*) from (select candidateid,count(*) as 'skillct' from skillset where @list...