I’ve glanced at the title of the latest SQL Server Central newsletter “Lots of Interesting Tech News” and it looked like, “Lost Interest in Tech News” :- ) Then I...

I really liked the last seconds of you video, when you're saying, 'That's...

kiranmai.gompa (7/7/2010)

---

hi,

Iam developing a database with Access as front end and Sql Server 2005 express as back end. It should be used in a multi-user environment. Some users should have...

Or you can run the dynamic SQL in your VB code and execute you stored procedure with explicit parameters naming:

EXEC sp_MyStoreProcedure @Parameter2 = 2, @parameter1 = GETDATE()

Thank you!

This is what I need.

myke (8/7/2008)

---

I actually do something very very similar in an app i work on. We have a rates table that has rates for given services. These rates may change fairly...

Egon Rijk (8/6/2008)

---

What about using a status field in the fact table?

The status field should be part of the key and has three values, according to your scheme.

Actual records have...

Well, the thing is that user needs to work with the whole set of data most of the time. The database itself is not a large OLTP database with thousands...