jckfla (8/13/2015)

I do have to say though. I receive no spam at my work email after signing up for SQLServerCentral (and another site I found here where I attended...

I hate case sensitive collations. The vast majority of the time in working with data, I don't care that "acme" and "ACME" are different characters on disk. They're the same...

Apologies, my grammar miscue. I had thought the "only" in the other two answers would lean towards the reading being only the answers given and not others. As opposed to...

Just renewed. I think one was me.

Ready to go!

If it's difficult to get connectivity, then Grant's solution can likely be scheduled in Windows. No need for SSMS.

However I'd also be sure there's some process to check that it's...

Ah, didn't think of replace. Certainly that can work if the domain of special characters is just the one character, and it never appears within the strings. If it could...

I am. See you there.

My apologies, I didn't see the B can't see A part.

I'll agree with Jason on finding out why B can't see A. Can A see B? You could reverse my...

GoofyGuy (8/12/2015)

I do hope GitHub and many of the low cost services are able to transition and survive as they mature as businesses. Even if many of them can't continue...

Thanks, appreciate the note that we're doing a good job.

I think we're in close agreement here for the most part. In a business context or other organizational/decision recommendation context, I do think some knowledge is needed.

My original piece was...

I agree on normalizing. In other words, store each mark as a separate row.

Student Mark

--------- ------

Bill 88.5

Bill...

What other columns are in the table? Any identity or key values you store?

First, understand the SQL Management Studio is a client application. It doesn't do anything on a server, even if it's running on the host that the SQL Server instance is...

Is there a domain of values at the end? Meaning, do you know the possibilities? Or is it a large set of possible values?

The way to do this is use...