Assume dtmInserted is a datetime field used to record when the application inserted the record...

DECLARE @StartDate SMALLDATETIME

DECLARE @EndDate SMALLDATETIME

SET @StartDate = GETDATE() - 7

SET @EndDate = GETDATE()

SELECT COUNT(*) FROM table_name...

quote:

---

As an alternative, you can use OPENXML to insert multiple rows with one procedure call.

---

Indeed,...

Unless there's something you really don't like about VB, I'd recommend making a stored procedure for the insert, opening the file in VB, cutting it up in VB, then executing...

We have had problems in th epast performance-wise with Crystal Reports. Have you noticed any patterns regarding # users running crystal reports and timeout issues? Can you identify...

what I have done in a similar scenario is have a system table that stores the next available sequence number:

CREATE TABLE stblNextAvailableSeqNo

(

NextSeqNo INT NOT NULL

)

then, when doing...

You will have to either:

a) include the case expression's switch field in the where clause, or

b) put the whole select in a derived table then build a where expression on...

quote:

---

Would it make sense to rewrite the code in a stored procedure ? Would I get some speed- improvements ?

---

quote:

---

...I am afraid that there are other gotchas like this there that I am not aware.

---