You get to drink from the FIRE HOSE!!!!

sqldba_newbie (1/18/2013)

---

I am experiencing this exact issue as mentioned here . I do have a work around. I was wondering is there a setting on the report server or some...

winmansoft (1/21/2013)

---

I have xml something like below in my sql server table

<z>

<a>

<b>1</b>

<c>2</c>

</a>

<a>

<b>4</b>

<c>5</c>

.

.

.

so many tags similar to above

.

.

</a>

</z>

I wanted to remove some particular <a> node and it's child node where <b>...

SQLRNNR (1/23/2013)

---

Koen Verbeeck (1/23/2013)

---

wolfkillj (1/22/2013)

---

When I was doing a lot of SSRS development, I wasted so much time closing BIDS and reopening it because often that was the only way...

Whew - have fun with THAT, especially if you are going at it from the report development side. The admin side...

mrTexasFreedom (1/17/2013)

---

Lowell,

Sadly, this isn't matching any rows:

select id, name

FROM my_user_table

WHERE CHARINDEX(name,CHAR(0),1) > 0

No rows returned. Likewise, the replace operation doesn't touch any of the rows. Ideas?

Thank you very much...

anthony.green (1/17/2013)

---

Ed Wagner (1/17/2013)

---

If your field is a datetime data type, then you're comparing the datetime result of GetDate() against the datetime value of the field. So, nothing's going...

Money and Decimal are...

MS announced that SQL Server 2012R2 will be released in late 2014 and will officially support both DBCC TIMEWARP...

dwain.c (1/15/2013)

---

wolfkillj (1/15/2013)

---

I've been working on a set-based T-SQL solution to determine the Damerau-Levenshtein Distance between two strings. (DLD distance is just like LD - the number of changes required...

L' Eomot Inversé (1/15/2013)

---

KWymore (1/14/2013)

---

Thanks for the 2012 question. I'm not sure why I would ever use CHOOSE. I would usually join to a reference table, or use a case...

ChrisM@Work (1/15/2013)

---

Alan.B (1/14/2013)

---

Jeff Moden (1/10/2013)

---

Alan.B (1/10/2013)

---

This morning before work for example, after a lot of effort, I finally figured out how to get the Levenshtein Edit Distance between 2 strings...

SQLRNNR (1/14/2013)

---

wolfkillj (1/14/2013)

---

Well, if you can taste the rainbow, you're just eating...

Well, if you can taste the rainbow, you're just eating Skittles.

But are the CHOOSE function and its also-new-to-SQL-Server-2012 buddy IIF anything other than syntactical sugar for Visual Basic coders writing T-SQL? The CHOOSE function...