Sure, that this is not an old radio interview with Ronald Reagan, which recently was discovered again?

If you have the choice between Access and SQL Server, use SQL Server.

As your app will be exposed to the web, it shouldn't matter from where they log in....

Yes!

There's always more than one way to skin the cat (Hey, did anybody notice I learned a new phrase )

Language barrier:

Ich muss jetzt mal eine Lanze für die neue Forumsoftware brechen

I like the new forum. Definitely something to get used...

I think you need to state the appropriate content type like this (Excel in my example)

Response.Clear Response.Buffer = true

Response.Expires = 0

Set oConn = ConnectAttachment()

Set oRecSet = Server.CreateObject("ADODB.Recordset")...

Andy,

you didn't say anything about availability outside US.

Anything new on this?

I might be wrong, but IMHO in almost any case using (NOT) EXISTS will be faster to check for existence, because EXISTS can stop once the logical test proves true.

But that's...

Hm, obviously I missed the char description. Gladly char with leading 0s will turn without problems into int.

Jonathan, nice to see you started correcting wrong answers again!!!

Not sure if this will really help, but what about

declare @myyear int

declare @mydays int

declare @startofyear datetime

set @myyear = 3

set @mydays = 57

set @startofyear =dateadd(d,@mydays-1,dateadd(yy,@myyear,cast('01.01.2000' as datetime)))

select @startofyear

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

2003-02-26 00:00:00.000

(1...

Define the identity property is no guarantee for a gapless sequence.

CREATE TABLE MyIdentity(

id INT IDENTITY(1,1) NOT NULL,

some_other VARCHAR(10)

)

GO

BEGIN TRAN

INSERT INTO MyIdentity VALUES('Erster')

COMMIT TRAN

BEGIN TRAN

INSERT INTO MyIdentity VALUES('Zweiter')

ROLLBACK TRAN

BEGIN TRAN

INSERT INTO MyIdentity...

I'm not sure if I understand you.

Do you want to test before actually inserting?

Is the ID some kind of key?

Can you give some more information?

I guess right now, we don't have to worry about that, David.

It seems not to be available outside the US, or...?

I think rockmoose means a user-defined function that returns a table. From BOL

CREATE FUNCTION LargeOrderShippers ( @FreightParm money )

RETURNS @OrderShipperTab TABLE

   (

    ShipperID     int,

    ShipperName   nvarchar(80),

    OrderID       int,

    ShippedDate   datetime,

   ...

Monday morning

Can you post your asp code?