i have this saved in my snippets; it's checking a short dictionary of weak passwords, and also where the password is the users name.

you might want to expand the dictionary;

for...

a lot of great guys here have put together a bunch of "stairways" series on many of...

oh your fast on the draw there, partner!

well, 'f' repeats as well in your example.

the easiest way for the count is simply

SELECT LEN(@asd) - LEN(REPLACE(@asd,'a',''))

so do you want a count of the max number of repeats in the string for each letter?

so a=4,s=1,d=1,f=2, or are you after just...

runs on 2005 also;

jean 93062 (9/20/2012)

---

I was reading about this and I think the print statement actually does go somewhere. Another developer recommended that the Print statement be used instead of returning...

if you are running a...

jasona.work (9/20/2012)

---

And before anyone suggests making up a pros / cons to actually buying something vs the script, I've done that. I often feel my boss is of the...

the entire error message is what we need to help; the state and actual error message are critical.

error 2 is cannot connect in general;

for example:

Microsoft SQL Server Login

Connection failed:...

yep, answering my own question, found a post from an MS spokesman:

Unfortunately, OPTION (MAXRECURSION limit) is not allowed in the definition

of views or user-defined functions. This restriction may be...

agreed, that's where i thought it should go, but when i put it there i get a syntax error:

Msg 156, Level 15, State 1, Procedure XML_To_ASCII, Line 91

Incorrect syntax near...

cidr (9/19/2012)

---

lowell 2012-09-12

@67 posts, i didn't think this was homework for the OP, and i got all excited about making a recursive CTE work before someone else beat me...

iit depends on your data, if any status other than OK, then it fails, for example?

With MyCTE (Product,Parts,Status)

AS

(

SELECT 'Laptop1','mouse','OK' UNION ALL

SELECT 'Laptop1','screen','OK' UNION ALL

SELECT 'Laptop1','button','OK' UNION ALL

...

there's more than a few great threads here on SSC on the subject: i think all of the threads here have actual documents attached from various posters as well.

http://www.sqlservercentral.com/Forums/Topic590668-338-1.aspx

http://www.sqlservercentral.com/Forums/Topic857703-391-1.aspx

http://www.sqlservercentral.com/Forums/Topic560087-145-1.aspx