Phil Parkin (8/5/2014)

---

ronan.healy (8/5/2014)

---

hi

im using the following code to remove a comma

REPLACE([Counter Party Ref],", "," ")

the value in the column comes in like this

EDQE40000222004,0S0

any reason why my replace wont...

What do you mean with the S3 edition of SQL Server?

Try the expression without a space after the comma.

REPLACE([Counter Party Ref],",","")

GilaMonster (8/5/2014)

---

In that case, for 5+ years experience:

Name 3 backup...

I guess in a job interview.

Eirikur Eiriksson (8/4/2014)

---

The main difference would be some components like fuzzy matching and grouping are Enterprise only,...

I guess shared datasets are the logical thing to do.

Lynn Pettis (8/4/2014)

---

Don't you just love people that ask for help but tell you it can't be a certain way, especially when the way the say it can't be done...

And you should finish your statements with the semicolon operator....

Nice question Hugo.

Your explanation left out "compound assignment operator" however 🙂

http://technet.microsoft.com/en-us/library/ms189484(v=sql.100).aspx

Ah yes, it's INFORMATION_SCHEMA.COLUMNS.

Case-sensitive databases, can't live with them, sure can live without them 🙂

The SSRS expression language is basically VB.

According to the MSDN page on Nothing:

When checking whether a reference (or nullable value type) variable is null, do not use = Nothing or...

I am afraid I have left it in my other coat...

What is the query that you used, and in which environment?

crussell-931424 (8/4/2014)

---

...and that's just counting the events you know about. I'm sure there are many unofficial events doing the same thing. We have one here in my town once a...