Ok, after some more digging I found this

prev_bizday= dateadd(day, case when datepart(weekday, dte) = 1 then -2
when datepart(weekday, dte) = 2 then -3 else -1 end, dte)

where dte is...

What I need is the SQL code to display the last business day - usually will be one day prior, but I want that if I run this code on Monday that, instead of Sunday's date, I get Friday's date.

This...

Great help... thanks a lot!!

My manager has just asked me to research whether it would be possible to restore a previously fully backed up database into two or more filegroups, with each filegroup being on a separate drive using...

Thanks, but I wanted it as an INTEGER, not a varchar... the script references the sysjobhistory table in the msdb database, and, in that table, the run_date column is an integer.

This set of code below shows all SQL Server Agent jobs that have failed for the date 200.03.29. The run_date column is an integer, but I want to run the code in such a way that the resultset is...

Yeah I recognize that. Thanks! I was just opening the VB.NET to send it there

ok thanks .... here we go...

I will... thanks!

Should I post another question concerning why the datagrid isn't showing up the data from the function, or should I ask it here?

I seem to have gotten past that problem... now it says

InvalidCastException
Unable to cast object of type 'System.Data.SqlClient.SqlDataReader' to type 'System.Data.SqlClient.SqlDataReader[]'.'
...

wow... I didn't see that... you're right! I'll modify it and get back to you... give me a sec...

I have created two table valued multi-statement functions using SQL Server 2000 and am now trying to develop a VB.NET front end application where I run the functions and pass string parameters to...