More likely, there was actually some difference in the text when it was imported. Possibly in copy-and-pasting it into the SQL query, it got reformatted to have a space...

ASCII 10 is a line-feed, ASCII 32 is a space. That's why they are different. They'll look the same when you just select them, but to the computer,...

I'm not sure why you would want the checksum of the characters. Why not something more generally useful, like the ASCII value? With the ASCII value, you could...

I think one of the reasons that databases and their tools have lagged behind other software development is that it still requires human expertise to make a database perform very...

Lynn Pettis (2/18/2009)

---

I have to agree on reading books. I have a bunch of books I keep in my car (my portable library) so I can have them at...

The method of import won't make a difference.

What you might try is breaking it down, character by character, and comparing that.

If you have a numbers table, you can do something...

On the original point of the editorial, yeah, there's a definite line between doing something off-job-description for the team, or doing something that should be at a lower level but...

On Darren's point, I can certainly see the CEO wanting to be appraised of such situations. Were I in charge, I'd want to know about emergency travel needs, or...

Jason Miller (2/18/2009)

---

nicholas.catley (2/18/2009)

---

...taling of getting the person with the right skills doing appropriate tasks, I really thing that someone with a better grasp of the grammar of the English...

You need to have a batch separator in there. In default installations of Management Studio, it's "go".

Add "go" to the line above "CREATE PROCEDURE", on a line all by...

If your proc actually gets a list that looks like "ID1,ID2,ID3" as opposed to "1,2,3", then you'll need to change the "replace" part of the XML string to:

replace(@IDs, ',ID', '"...

Here's a high-performance way to accomplish what I'm talking about. Doesn't use a Numbers table, instead uses XML, which gets the same performance. Either one will work, but...

As a follow-up to the whole thing about BOL, I did end up finding a book, The SQL 2000 Bible, that was adequate to get a total newbie (me) up...

If you had something that would pop up and tell you, "this query involves a cross-join", or "this query will involve multiple table scans of large tables", or something like...

Lynn Pettis (2/17/2009)

---

Back to the topic at hand (at least for the moment). Both products have their place or else they both would not exist. Where I may...