ExecuteScalar() does not return the RETURN value of the stored procedure. I returns the first column of the first row of the result set. That is why you are...

The last Monday of the month is nothing more than the first Monday of next month minus 7 days.

yeah, my keyboard glitched before I finished that post so I had to edit it. Glad to have the chance to help out.

You might consider removing the holidays and...

Okay, here's one way to do it. First, define a CTE for your business dates:

with BizDates (Bdate)

as (

select Date

from Datetable A

...

it does not work with wildcards.

I would have whatever app puts the attachment files in the folder insert a row with (containing the path) into a table as well.

sure, shoot me a private message with an email address.

I would also look at the query plan. Depending upon the size of the table if suddenly decides to perform a tables scan Vs. some other plan it can result...

I wrote a stored proc that computes the dates of all known (in our case banking) holidays. Some dates are always fixed (such as July 4th, Nov 11th) others are...

Best way is to maintain a holiday tablecontaining holidays on out years into the future. (we have a SQL agent job that keeps the table current out 8 years ahead)....

declare @x datetime -- this is your date time column or variable

set @x = getdate() -- set it to current time value

select @x ...

Not if...

try this:

Select* from mytable

WHERE functionDate > CONVERT(char(10),getdate(),101)

that assumes all times are 00:00:00

You should probably employ the expertise of an experienced DBA to help you establish and implement all of the procedures from application upgrades to disaster recovery.... at least in the...

please provide the entire query instead of the part of it.

look up ALTER DATABASE in BOL it should explain how you can do it.

Alternatively, you can right click on tempdb from SMC, go to "files/filegroups" and do it that way.