concatenation in query and bcp query out.

select 'Andrews Phone Book'

union

select 'phone:'+col from table

union

select 'End of Phone Book'

COALESCE

declare @allplancode int

select @allplancode = count(*) from plancode

select plancode, count(*) as plancodecnt , 100.0 * count(*) / @allplancode as percent

 from thetable

 group by plancode

It lands you a job.

A normal join from table and view. something like

select a.*

from creditors a

inner join guptaview b on a.credid = b.credid

create view guptaview as

SELECT *

FROM OPENQUERY(PROGEN, 'SELECT * FROM sysadm.creditors') a

if the Gupta sql base table is small, then view in sql server using openquery may help for the real time join.

login use query analyzer to change user's default db.

If in query analyzer, check you connection properties, make sure Set noexec is not on.

make a cmd file to automate your ftp process. something like

z:

ftp -s:ftpfile 127.0.0.1

in the ftpfile, put login password etc, like

username

password

lcd cms

as

mget [name of file]

bye

In DTS, use Execute Process...

try to put go between each statement to avoid confusion.

From your statement, there was no 'table'.

Schedule a job at the end of month to calculate interest.

Have you consider to limit them right in database?

check involved table in stored procedure, sp_depends can help you.

instead of trigger may help.