Hi Chris,

quote:

---

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/chedgate/clusterthatindexparttwo.asp

---

this is no...

Hi kiberu,

quote:

---

How do you put a calculated value eg. sum of all entries in the footer of a data entry form in...

Hi Tomi,

quote:

---

There's only one problem. It doesn't take advantage of possible indices i.e. it does an index scan when it should do...

Hi Anil,

quote:

---

I am trying to migrate to SQL Server from Oracle and I have trouble finding an equivalent to ROWNUM (Oracle) in...

Hi Jugal,

quote:

---

Currently we are using san storage to store files in pdf format. This has led to space issues on the disk....

Hi kiberu,

quote:

---

Alter Procedure QryOrderFooter

(

@OrderId int OUTPUT

)

As

SELECT OrderId,QTY,QtyValue, (QTY * QtyValue) as Revenue

FROM qryOrder

WHERE (qryOrder.OrderId...

Hi anilg,

quote:

---

Thanks, but the problem is i cannot add a column to the database. All i can do is change the queries...

quote:

---

Error message, that Domain aggregate functions not allowed in VBA?

---

I've tested this one

Me.Text2 = DSum("[id]",...

quote:

---

Correct, Moved to ACCESS ADP and my forms have gone beserk!

FE is in Access 2K (Office 2K SP3)

---

July 18, 2003 at 7:51 am