I haven't worked with SS2005, but it does make sense that SS2K will not be as capable of linking up with SS2005 as vice versa, so I'm glad you've managed...

Where is the reference to Transactions coming from in the error message? Are you by any chance using Transactions?

Thanks Jacob, works like a charm!

Ramesh, thanks for grasping the idea so fast, I am grateful.

The idea is a Hall Reservation will be JOINed with "<=" and a Room Reservation with "<" only.

I adapted your...

I have indicated the line where I want the dynamic join, unfortunately the colour coding is not coming out correctly. It is at the first JOIN on D to RT.

Thanks, I took a look at it; it is good but not of immediate use for me for this issue.

I tried all possible date...

I fixed it somehow; I don't know why CR was displaying the parameters in an order different from the one required by sproc, so I reordered them.

Thanks to all.

Hi, guys, sorry to bother you again but I need help from any Crystal Reports pros here. What is the proper format to pass date values to DateTime variables in...

Thanks, Luebbers, you've all been a great help.

I don't think I need to use the perm tables to hold my temp data anymore if I can pass the whole recordset...

As easy as that? Thanks, I'll give it a shot.

Now, to the slightly tougher part:

I need to open this sproc's output as a data source for Crystal Reports' how can...

One of my sprocs that populates a DB table:

CREATE PROCEDURE [dbo].[sp_DAILYMOVEMENTS] @MyDate DateTime AS

DELETE MOVEMENT

INSERT INTO MOVEMENT(TODAY, ROOMNAME, ROLLOVER, ARRIVAL, DEPARTURE)

SELECT @MyDate, Description,

...

Thanks to each of you; now, if I use this in VB6 simply as it is, will it work?:

Cnn.Execute "If @@trancount > 0 RollBack"

(where 'cnn' is my ADO Connection)

[Quote]Set RS=Server.CreateObject("Adodb.Recprdset")

RS.ActiveConnection="Some connection to a database"

Sql = "Select Id, Name From Users Where Name like '%Smi%'

Set RS=RS.Open SQL

If Not RS.Eof Then

While Not Rs.Eof

Response.Write("Id =" & RS("Id") & " - ")

Response.Write("Name...

Thanks, pal, but what I meant was how do I retrieve the temp table returned by the sproc into my vb code? How do I get a handle on it...