So what happened late last week? Are there new triggers on...

Then take some time and read the article that Steven linked...

SQLCrazyCertified (6/24/2013)

---

Sean Lange (6/24/2013)

---

SQLCrazyCertified (6/24/2013)

---

Hi,

When a user tries to edit a table, he is getting a timeout error.

Here is a brief details about the error.

"Executed SQL Stmnts: "the stmnts"...

SQLCrazyCertified (6/24/2013)

---

Hi,

When a user tries to edit a table, he is getting a timeout error.

Here is a brief details about the error.

"Executed SQL Stmnts: "the stmnts" from dbo.tablename,

Error source:...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

I don't think there is anyway to do this kind of thing directly in Access. The query engine is just not that robust. You will probably have to do this...

There are some faster ways to generate a tally table. The code you are looking at is selecting data from actual tables and inserting into a temp table. You can...

TBIG (6/23/2013)

---

I need to do an INSERT for a subset of records in a table to the same table. What is the best way to determine the primary key of...

As Jeff and Steve have eluded, you don't need a loop to do this. You just need to use a tally table.

Something like this should be close.

update m set mrno...

When you say it won't let you what does...

Best of luck man. Hope all goes well,...

realvilla (6/21/2013)

---

Sean, you may not be there today but I made an interesting discovery. I tried four groupings for totals. For example, I took the group represented by:

Select...

This seems to work fine. There is no reason it should change just because it is in a view.

if OBJECT_ID('Something') is not null

drop table Something

GO

create table Something

(

ID int,

Type varchar(10),

Term varchar(10)

)

GO

insert...

You're welcome. Glad that makes sense. It is a zillion times less complicated than building up a...