mmm...

I was born in Harare, Zimbabwe and am now based in London.

As soon as I get bored of the bustle and hustle of London, I hope I will go back

CREATE

PROCEDURE sp_AppendToFile(@FileName varchar(255), @Text1 varchar(255))

as suggested by l0n3i200n

have your stored proc like so

ALTER

PROCEDURE [dbo].[spInsTable1]

@out varchar

I would think 4s is good enough considering that you are filtering on free text.

Is there a business rule that wants it any faster?

If you have any ODBC drivers then yes you should be able to, just create a system DSN and you are in business.

p.s....

I don't know how else you can do but just drag some controls on to a report and call it template. Any reports you want later just first 'Save As'...

I agree with Scott, definately keep those people out of the database queries. unless you want to spend countless hours rolling back some unwanted changes.

If you really want it, let...

I was intending to use lots of practise and the book

Implementing and Maintaining Microsoft SQL Server 2005 Exam: MCTS 70-431 Exam Cram (Exam Cram) (Paperback)

by Thomas Moore

its going...

an alternatibe to the trigger solution is using a scalar function

create function NextSiteId(@custid varchar(4))

returns int

as

begin

declare @siteid int

 if exists (select siteid from assettable where custid = @custid)

 begin

  select @siteid = max(siteid) +...

get somebody to do it for you and claim the fame.

you would probably need to just know a bit and then use a...

what sort of status information is it returning? if you don't mind my asking what is the dts package doing?

if you want to continue with your current solution you can...

i agree with rao, why would you want a one column table. reconsider your db design or you can post your requirement to see if we can help

good on you then.

cheers

I am a developer using mainly SQL backend so this is what i like about the product

------------------

-The new Visual Studio Database Project allows you to import your database schema and...

try this one

--on server nysvrweb03

use

TPGWeb

GO

UPDATE

dbo.Project

SET

ProjectInfo = custProjectInfo,

[bunch...