Woops, one more try. This gives you 07/11/2011 00:00:00 to 07/21/2011 23:30:00

DECLARE @DateStart DATETIME = '7/1/11'

, @DateEnd DATETIME = '7/20/11'

DECLARE @Daydiff int = Datediff(dd, @DateStart,...

Like this?

DECLARE @DateStart DATETIME = '7/1/11'

, @DateEnd DATETIME = '7/20/11'

DECLARE @Daydiff int = Datediff(dd, @DateStart, @DateEnd) + 1

SELECT DATEADD(mi, Mi.N * 30, dateadd(d, D.N -1...

Thank you for the information. That does make sense and I have switched to truncating the table, dropping the index, loading the table, and building the indexes. Performance in general...

Thanks again Jeff. I see what you are saying on the Cell now 😀

I will have to play with the dash thing as well to see if I can capture...

I am not sure what you mean by 'cells'

I want exactly what your code does which is find illegal characters in a given column of a given table.

That...

I believe I found a slightly alternate solution however, to answer your question first, I am not trying to split up the string just identify the records that have the...

Ok finally got the code to work out the 3 issues I had I have posted below. I notice originally the code you posted ran in about 6 seconds on...

Figured out how to get the characters in the substring to show where in the string the illegal character is and what illegal character it is. still working on the...

Thanks Jeff this is an excellent bit of code!

A few problems I see however

1) It is grabbing columns with the dash ('-') as 'weird' columns even though looking at...

No worries take your time. I have been looking for a solution as well, I will post something if I figure it out 😀

Yes you are correct sorry it has been a while since I designed and/or even looked at this code. I use it as a comparative like

select dbo.removespecialcharacters(column) from table...

Not a problem. I know I didn't do too good of a job explaining myself. Basically we transfer some of our data to a 3rd party source for reporting that...

Great article Jeff!

One situation I would like to see if it can be solved, is I wrote a script that will search my database char columns for 'funny' characters. Of...

So I solved my own problem by rebuilding the other non clustered index on the table. Not sure why that was needed I just did it on a hunch 🙂

My...

Great! Thank you for this information!

I was starting to come around to that line of thinking as well through my endeavors yesterday, and that makes complete sense. Thank you...