Might be easiest to determine which characters are legal and look for anything that DOESN't match. I'd use patindex for that.

something like

PATINDEX('%[^0-9a-zA-Z .,!+-]%',MyColumnname)>0

I read the part about the firewall exception as needed if this dev workstation was going to be the "SQL back-end" to a remote SSRS install. So - no...

abinder (6/19/2008)

---

You're correct, Matt. I have this aversion to writing dynamic SQL although I have used it in the past. It is awkward at best and I have read many...

If you're trying to get information out of them - you really want to stick to the DMV's. the views simply took over for the tables, so they really...

John Rowan (6/19/2008)

---

Jeff, Do you have documentation to support that SQL Server behaves that way? I've never heard this before. Are you saying that if you create a...

Actually - the other person was me, and the comment centered around the "locking TempDB" urban legend that seems to pop up a lot. That got a lot of...

Somebody needs to find whoever designed this process on the vendor side, and beat them with a data normalization book. They should go back to designing spreadsheets because they...

KingGorilla (6/19/2008)

---

Hi

On a slight tangent... 🙂 i try to avoid using the select.. into #tmptable syntax due to locking on the tempdb while it creates and inserts the rows. I...

Looks to me that you'd have a much easier time if there were a flag to tag lineitems that have been entirely used up, or alternatively, something to how much...

The result you're pointing to is 26 digits long before the decimal (if i counted correctly with all of my fingers and toes) so at very least you'd have to...

Now there's a left turn across the field....I've used Excel for a lot of things, but that's a new one for me...:cool:

Michael Valentine Jones (6/18/2008)

---

The easiest way is to left join each row to the prior row for the same customer, and do a difference between the dates from the current...

Have you browsed the article archive here? Last time I poked in there, there were over 100 of varios degrees about SSIS in there.

From what I can tell - you're trying to do dynamic SQL without actually setting it up as actually dynamic SQL.

Your insert is supposed to pull dynamically fron...

If the set isn't too big

select contact,count(studentno) as freq

from (

SELECT StudentNo, COUNT(ContactId) AS contact

FROM StudentContact

GROUP BY StudentNo

) t

group...