check the plan of the proc. When you use 123456, you'll probabely have a clustered index seek, but with 123456.00 you'll probabely have a clustered index scan. The...

Hehe, looks like I made a fan here... Feels weird .

Does it have to be in excel??

Cause this seem to be a really great task for any reporting tool out there.

It is that simple, unless I don't understand the question.

Do you have multiple triggers that insert in the same target table?

Can you post the code you're using with its problems?

Good idea... but make sure it's a column with a default if possible. Just to avoid data that's be reloaded from an even older version of the app.

Isn't there a collection for the queries in access just like for the forms and reports.

Like currentproject.allqueries

You could do a for each q in ... and recreate the queries on...

Isn't there anyway to just return the recordset without transforming to xml?

Xml is only a much more bloated version of the data and therefore takes more resources to transport.

You're right... first time I see this situation.

Always something else to learn .

on the first trigger :

CREATE TRIGGER...

FOR Insert

AS

SET NOCOUNT ON

Insert into dbo.Table2 (Col1, Col2, Coln) Select Col1, Col2, Coln from Inserted

GO

Repeat process for the next trigger. This will do...

You have to keep the whole date to easily solve this problem :

Select datediff(d, '2005/01/01 20:00.000', '2005/01/02 04:00.000') = 480 minutes (8 hours)

This is the easy way out. ...

So close yet so far :

select custid from dbo.Txusage

where UsageTime between '2005-06-14 11:59' and '2005-06-14 17:00' and Venueid in (5,12)

group by custid

having...

It's not hard

try

--fail

insert into SomeTable (SomeCol) values ('This fails : '')

--works

insert into SomeTable (SomeCol) values ('This works : ''')

Forgot to ask (really the last one )

Is it 10 consecutive records for the same name or can have different names?

To quote Joe celko :

"You guys need to stop thinking proceduraly and start thinking in sets".

And I'm still waiting for my own answer on this one. Not the...

Now if it's not a typing problem, I can't help you, otherwise there's always those typing teaching softwares .