I think even when you are casting the getdate() function as a datetime variable, you are really only passing a string to the udf, and the udf is doing the...

I'm guessing this BOL statement is why:

...Built-in functions that can return different data on each call are not allowed in user-defined functions.....

Now you could do the following:

declare @MonthToRun as datetime

select...

You might try a tool like log explorer:

http://www.lumigent.com/products/le_sql/le_sql.htm

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

You may want to check out: http://www.iss.net

They have a product call DBSCANNER that scans SQL Server reporting security vulerabilities.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my...

I like this one! Much better than my hack.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Try this hack:

select a.*

from loadinfo a

left join (

select distinct b.agencycode from

(SELECT count(*) as count,agencycode, OriginCity+DestCity x, OriginState+DestState y from loadinfo

group by AgencyCode, OriginCity+DestCity, OriginState+DestState ) b

join (select...

Don't think Antares686 example works if a giving load, picked up in a single origin city, has multiple destinations in different cities and states, where at least one destination is...

Isn't this date changed anytime a block is written to the MDF file?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Not my experience. Look here for additional information:

http://support.microsoft.com/default.aspx?scid=kb;en-us;263556

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Possibly something like this might work for you.

create table LoadInfo(

Company# char(4),

AgencyCode char(3),

LoadNumber int,

OriginCity varchar(25),

OriginState char(2),

DestCity varchar(25),

DestState char(2))

insert into LoadInfo values ('LDWY', 'XYZ', 11010, 'ONEILL', 'NE', 'CLEVELAND', 'OH')

insert into...

Very interesting definition, of byte not exactly what I thought, all based on machine you working on. I'm sure someday a byte as we know it today will change.......hopefully...

What popuptext are do you want returned when the tblapptranslation does not have have a matching language and appname?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my...

Thanks for the explaination Antares686. I'm not sure I agree with the last sentence, but I think I get your point.

Guess I'm from the old school where a...

My point exactly. Unicode will require more pages, therefore more I/O bandwidth, and hence slower performance if used, when not needed.

Gregory Larsen, DBA

If you looking for SQL Server Examples...

OH, shutdown the server. Well then you might want to look at the SHUTDOWN command in BOL.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website...