You earler post had a commet about the function only handles one expression at a time. That was kind of the point. In a select statement the function...

I don't have anything against the sql clr. In this case since I just needed a simple math expression solver, it seemed a bit over kill to call the...

When I try to put your code into a function passing in a string variable I get an error:

The argument 1 of the xml data type method "query" must be...

In my article I state that I considered using some form of exec. The issue is I needed this to be done in a function. Functions cannot use...

This is just a wild guess, but if the variable you are trying to set is a decimal type perhaps a numeric(18,6) or something like that you should actually set...

I have long believed just what you stated in your article. A CS degree doesn't mean you are going to be a great programmer or DBA etc. My...

Ian Massi (10/20/2011)

---

The website for Space Adventures has a video that shows them testing the rocket they would use. Really impressive and seems to work well. That being...

Grant Fritchey (10/19/2011)

---

By the way, DBA is just a term, we're talking data professionals concerned with databases. From the rules:

If you’re a finalist we will need to confirm that...

rmechaber (10/18/2011)

---

I've created a simple TVF (based on Jeff Moden's posts) to shred delimited strings to their constituent parts. (Background: this is to deal with SSRS multi-value parameters being...

trarunprasanna (10/18/2011)

---

Delete from t1 from account t1 join Resource t2 on t1.RID = t2.RID

Hi All,

The above query is deleting the similar columns in accounts table , it is...

sam.alexander (10/17/2011)

---

Hey Guys -

I'm thinking of enabling SchemaBinding on an application we're working on, but is there any simple way to change a View when SchemaBinding is enabled so it...

lema-922661 (10/17/2011)

---

yes - the Amount or Reference could be unique and will need to be - the report we want the individual to receive will contain a small table showing...

matthew.peters (10/17/2011)

---

Hello I have a locking issue which I'm trying to resolve, we have a table which gets hit with a lot of updates and selects. When the update occurrs...

The sql code I gave you should remove the duplicates. If it does not, it is because one of the other fields is unique for each row. If...

lema-922661 (10/17/2011)

---

Thank you for responding.

Yes - this is where I start "winging" it. Using the simple example above - this is how I have set up my report.

select Name,...