+1. Same here. Never used with Delete so never saw the CTE from that view. 🙂

Overall good...

Quick answer:

selecta.Empid, a.Empskills+', '+b.Empskills

from#Empa

inner join #Empb on a.Empid = b.Empid

where a.Empskills = 'C' and b.Empskills = 'CPP'

kevaburg (9/24/2013)

---

sqlnaive (9/24/2013)

---

kevaburg (9/24/2013)

---

sqlnaive (9/24/2013)

---

Really Fantastic article. I have been on both sides of it and now working purely as Developer so that helps me having a healthy negotiation with...

kevaburg (9/24/2013)

---

sqlnaive (9/24/2013)

---

Really Fantastic article. I have been on both sides of it and now working purely as Developer so that helps me having a healthy negotiation with system DBAs....

Really Fantastic article. I have been on both sides of it and now working purely as Developer so that helps me having a healthy negotiation with system DBAs. Remember the...

Nice easy question for me. 🙂

Very good question. A topic very often left behind. though I was on the wrong side of answers, it definitely cleared basics about the 'guest' login. 🙂

Thanks Jeff. Nice article.

I came across this function just two days back during some conversion issues. I found some surprisingly different results and thus started playing with it (for...

Can anyone please put some light into it ?

float and Numeric are both number data types so why we can't convert the varchar directly to numeric ? The difference between...

🙂 No worries Sean. but thanks about the STR functionality. Was playing with it and had fun to know about some things. 🙂

Adding to your command statements, these two works...

My question remains the same:

float and Numeric are both number data types so why we can't convert the varchar directly to numeric ? The difference between the two being "exact"...

Thanks Seane. So in order to convert it to numeric/decimal, two conversions have to be done like this:

select convert(numeric(28,8), convert(float, @varchar))

float and Numeric are both number data types so why...

Thanks for referring this link Andrew. I had planned to include this link as additional info but...

I second these guys on security. Windows authentication is best way of providing secuiryt to users. AD group can be defined for group of users requiring saem level of permissions.

L' Eomot Inversé (9/18/2013)

---

sqlnaive (9/18/2013)

---

it is going to set the default language for that session as 'us_english' no matter what the other settings are. I myself has 'british' as default...