Viewing 15 posts - 16,756 through 16,770 (of 18,926 total)
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...
June 15, 2005 at 6:50 am
Hehe, looks like I made a fan here... Feels weird
.
June 15, 2005 at 6:43 am
Does it have to be in excel??
Cause this seem to be a really great task for any reporting tool out there.
June 14, 2005 at 9:45 pm
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?
June 14, 2005 at 9:43 pm
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.
June 14, 2005 at 9:07 pm
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...
June 14, 2005 at 9:06 pm
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.
June 14, 2005 at 9:03 pm
You're right... first time I see this situation.
Always something else to learn
.
June 14, 2005 at 8:59 pm
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...
June 14, 2005 at 8:50 pm
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. ...
June 14, 2005 at 8:44 pm
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...
June 14, 2005 at 8:40 pm
It's not hard
try
--fail
insert into SomeTable (SomeCol) values ('This fails : '')
--works
insert into SomeTable (SomeCol) values ('This works : ''')
June 14, 2005 at 2:32 pm
Forgot to ask (really the last one
)
Is it 10 consecutive records for the same name or can have different names?
June 14, 2005 at 2:15 pm
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...
June 14, 2005 at 1:55 pm
Now if it's not a typing problem, I can't help you, otherwise there's always those typing teaching softwares
.
June 14, 2005 at 1:44 pm
Viewing 15 posts - 16,756 through 16,770 (of 18,926 total)