That is because oracle likes cursors

Try:

Create Function Get_XY_Coordinates (@i_Pupil_Number int)

Returns int

Begin

Declare @iXYCoord int

SELECT @iXYCoord = sab.address_id

From sps_address_bridge sab inner join sps_stud_assignment_address saa on sab.street_number = saa.street_number

And sab.full_street_name =...

I agree with Sergei is that it is best not to do it. That being said, there are ways to pass the where clause to a SP.

One way that...

Provided the date rows are always valid dates and follow a row with a name, there is this solution:

create table #test (Id int, Value varchar(25))

insert into #test

select 1, 'John Smith'

union...

Or

delete a

FROM #UserSession a

WHERE EXISTS (SELECT NULL FROM #UserSession WHERE UserName = a.UserName AND LastUpdated > a.LastUpdated)

Great script. It is nice to have everything together when viewing the results and checking for blocking.

Dave Novak

You can not do a derived table in MS Access. The derived table is the select statement in the '()' in the FROM clause. You will have...

It would be helpful if you could provide some examples of the data and how you want the results to look.

Dave Novak

I was just looking at some of the info on 'TRY .... CATCH' blocks.

One of the item it states is if the severity of the error is 10 or less,...

You might want to try an SSIS package.

SSIS can check the data as it is being loaded. If it finds a value that does not pass the appropriate checks...

You may have some other issues.

Looking over your data in the attached Zip file, you have multiple line designated by the 'br' html tag

code for the same Id value.

You...

There is another reason to us views besides the the aspect of making difficult joins easier for others by putting them in the view so that the just need to...

You will have to script out the table to set up the table in the new database. Then use OPENQUERY to get the data to be transferred to the...

One such solution would be to create an User-Defined Function that takes in the Start and End date and returns a table variable with all the dates

Then use a while...

No, you can not use an 'IN' clause in a 'CASE' statement as you are trying to.

You can use an 'IN' clause in the 'WHEN' part of the 'CASE' statement....