Search:

That did the trick. Thanks a lot.

Dirk

I am creating a VBA-application in Excel, and I noticed that, while running the application, the tab-key browses through the widgets on the window in the order there were created. I wonder whether it...

count(sid)/count(distinct sid) is indeed what I was looking for. Thanks a lot

I have a database containing a table "Case", and a table "Session".
I want to calculate the average number of sessions per case, but I don't know how to do this.
The following code does not work:...

I want to execute a query from VBA to a MS SQL database, and store the results of the query in a resultset, so that I can loop over these results, but I don't find the correct syntax to do so. Can...

Hallo everyone,

I have another problem related to producing reports from MS SQL Server using Excel. I know how to put the results of a query in an Excel worksheet, but now I want to use the...

OK, I removed the single quotes. Thx for the suggestion (as well as the other help)

Grtz,

ddebecke

This is what I tried to do in my VBA script:

' Get the number of callers that made more than 5 calls
' Set up the SQL Statement
sqlstring = "execute dbo.PersonsWithMoreThanXCalls '5'"
...

OK, I've found the answer.
For those of you interested, my stored procedure looks like this:

CREATE PROCEDURE PersonsWithMoreThanXCalls
@MinNbOfCalls int
AS
EXEC('SELECT COUNT(*) [People with...

Thx Krzemo,

That is almost what I was looking for. But now I get as a column header
"People with more than @MaxNbOfCalls calls".
That is, the system does not seem to substitute the parameter...

Here I am again with another question related to producing reports in Excel by querying a ms sql database. The answer to my previous question was satisfying (thx Krzemo), so I hope that will also be...

Hi,

I would like to create some queries (actually, preferrably views) in ms sql server that allow for user input. The reason why I want this, is because I am trying to generate some reports about...