You need to use DATEPART with weekday to determine which day of the week it is. Also, you might consider a calendar table to determine holidays as well.

Jeff, the output could be a single delimited line.

This is a 'one time thing' so I ended up getting it to work with something similar to Luis's suggestion....

Thanks for the lead, I'll take a look in that direction.

It looks like it might be a registry issue. There don't appear to be DefaultFile and DefaultLog entries in the standard location. Thanks for pointing me down the...

Lowell I can grab them that way and might if need be, but ideally in powershell. Its pretty straight forward in powershell

$Instance = New-Object('Microsoft.SqlServer.Management.Smo.Server') $InstanceName

$Instance.DefaultFile

$Instance.DefaultLog

These are blank for a...

sweetumz (11/17/2014)

---

Hi Jeff,

All the data is on a MS SQL 2008 server and is managed/modified etc. using a GUI similar to content management system. I get the following error:

Validation failed:...

Are you trying to update a character field with an integer value?

What does your data look like and what is the error message you are receiving?

Gail has written a great article on Simple-talk.

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

What is the timeout value in the application's connection string? This typically occurs when a query's processing time exceeds this value. You can increase the value or tune...

I tried drop/create for laughs, still the same. I have a few databases on a local instance that I use for dev purposes, different branches if you will and...

I just tried it in a different database and it worked fine...

Totally agree. I'm right-clicking 'Modify' - > making changes in query window -> execute -> Modify again to verify. This is strange.

Did you try the function I posted above? sorry for the formatting here. I can't upload a screenshot...

c1 ...

PATINDEX finds the first occurrence of the pattern. With CHARINDEX you can specify a starting location.