Uhg! (To both of you.)

(Good ones. Made me groan in humor.)

Not sure about why the error message. Get rid of the semicolons, the function will still run, it's just less "clean".

I also noticed that one of your input parameters...

If you want to bring this up without bypassing channels, there are a couple of ways to do that.

Probably the best option in most circumstances, is to call a meeting,...

Try this:

select distinct srs_esd.*

from srs_esd

left outer join srs_cap

on srs_esd.esd_code = srs_cap.cap_stuc

where srs_cap is null;

Try this:

create function dbo.Maxof

(@status text,

@actuals money,

@committed money)

returns money

as

begin

declare @Output money;

if (@status='Closed') or (@actuals > @committed)

select @Output = @actuals;

else

select @Output = @committed;

return @Output;

end;

There's no "End If" statement...

That sounds like a good way to do this. You could probably make the Date and LocationID columns into a composite primary key for the table.

If you could post the full definition of the proc, and the source tables, I bet I can not only fix this, but eliminate the cursor and make it much...

Again, you're nearly echoing certain chapters of Problems of Work.

A thought I heard once expressed it well to me, "You have to aim for the stars if you want to...

I have a job that does this:

set nocount on;

declare @sql nvarchar(max);

select @sql =

coalesce(

@sql + 'insert into dbo.SpaceUsed(TableName, Rows, Reserved, Data, Index_Size, Unused) exec sp_spaceused ''' + name + ''',...

Try:

Select unicode(FirstName) From Person Where FirstName <= 'a'

Then check the value returned against the unicode character set at http://www.unicode.org.

Does that help?

On relational theory, start with Wikipedia, work your way up from there. As usual, it's a good starting place. (As always, just don't use it as a single-source-of-information.)

Another...

You're welcome.

Personally, I'd be inclined towards option 3.

With the first one, all it takes is someone saying, "We need to change the first period so it starts at 6 AM", and...

Have you looked at simply using the Replace command? That should do what you need with the # symbols.

As far as getting addresses into fully formatted versions, your best...

Another option:

if object_id(N'dbo.Payment') is not null

drop table dbo.Payment

go

create table dbo.Payment (

ID int identity primary key,

Ord_ID int,

Seq_Num int);

go

create trigger Payment_Ins on dbo.Payment

instead of insert

as

insert into dbo.Payment (Ord_ID, Seq_Num)

select distinct Ord_ID, Seq_Num

from...