DECLARE @Subject varchar(4000)

SELECT @Subject = MyField FROM MyTable

EXEC xp_sendmail 'me@mydomain.com', @Subject

Andy

CAST(CONVERT(varchar,[Quantity]*[UnitCost],1) AS float) AS ExtendedCost

CAST(CONVERT(varchar,[Quantity]*[UnitPrice],1) AS float) AS ExtendedPrice

CAST([ExtendedPrice]-[ExtendedCost] AS float) AS GrossMargin

CONVERT(varchar,CAST([GrossMargin]/[ExtendedPrice]*100 AS int))+'%' AS Percentage

Andy

Try:

UPDATE dbo.tbl_Voy_RCATransfer SET dbo.tbl_Voy_RCATransfer.Cancel_Field_Calls = '1'

FROM dbo.tbl_Voy_RCATransfer

  INNER JOIN (SELECT dbo.tbl_Voy_RCATransfer.CASEID

    FROM dbo.tbl_Voy_RCATransfer

      INNER JOIN dbo.tbl_Voy_RCATransfer AS tbl_Voy_RCATransfer_1

        ON dbo.tbl_Voy_RCATransfer.SerialNum = tbl_Voy_RCATransfer_1.SerialNum

          AND dbo.tbl_Voy_RCATransfer.CountryCD3 =...

Try:

SELECT 'AA'+CONVERT(varchar,ISNULL(ORG,''))+'00'

    +CONVERT(varchar,ISNULL(Acct_Nbr,''))

    +ISNULL(Tran_Code,'')

    +CONVERT(varchar,ISNULL(Amount,'')) AS MyAACol

 , LEFT(CONVERT(varchar,Eff_Date,1),2) AS Months

 , RIGHT(CONVERT(varchar,Eff_Date,12),2) AS Days

 , LEFT(CONVERT(varchar,Eff_Date,12),2) AS Years

 , CASE WHEN Tran_Code > ' ' THEN '00000' ELSE NULL END AS ZeroSpacer

 , CASE...

You could convert this script into a stored procedure:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=763

Andy

Google for "Brain Dump" as material to use for a before test cram session, always helps me keep the "senarios" in mind when they occur in the tests.

Now If I was just...

Have a look at SyncToy from Mircosoft:

http://www.microsoft.com/windowsxp/using/digitalphotography/prophoto/synctoy.mspx

Look in it's help file for "Schedule SyncToy" under "SyncToy How To Topics".

This was designed for XP and Photos, but then they are just...

You will still need to tweak your time, re:

SQL Server datetime datatype allows for a date value from 1/1/1753 through 12/31/9999 and a time accuracy...

Make sure that the account you are connecting with OLE DB has a permission route for the sadaslink Linked Server, in BOL lookup sp_addlinkedsrvlogin and/or Establishing Security for Linked Servers.

Andy

You can find more on this subject here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=185347#bm185575

Andy

SELECT

a1.account,

a1.disease_prog,

a1.confirm_flag,

a1.consent_flag,

a1.opt_out_reason_code

FROM ah_member_flags a1

WITH (nolock)

inner join ah_member_flags a2

on a1.account = a2.account

and a1.company = a2.company

and a1.disease_prog = a2.disease_prog

WHERE

a1.confirm_flag = 'y'

and

a1.consent_flag = 'y'

and

(

  (

   a1.disease_prog =...

My experience with this kind of data transfer is to always execute the INSERT script from the server that will be creating the rows. This tends to speed this kind...

From the directory where my.bat exists, open a CMD window and issue: osql /?

Do you see any message about not finding osql?

If you see the help message, have you examined...

OK, hows this?

Note: Table creation modified to prove query does not require the rownum to be sequential or a column in the table.

CREATE TABLE quiz1 (name varchar(50) NULL, start_dt datetime...

You were using Jet4 to access a Jet3 database.

Andy