You need to use the convert function, have a look at this thread

😎

This is from a "clean" installation of SQL 2012

😎

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\

[b]SharedCode[/b] has the value of the Shared Code installation directory

[b]ErrorReportingDir[/b] the error dump folder

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\Tools\ClientSetup

[b]SQLBinRoot[/b] The SQL...

Quick thought, you need to have two from clauses, one for the XML and one for the outer query and then link them with a where clause in the inner...

Minaz Amin (6/23/2015)

---

Hi All,

I have a function with multiple if ( condition) which is CPU intensive. How could I avoid this.

CREATE FUNCTION prici.[fn_pricipalamt]

(

-- Add the parameters for the function...

ruM

GilaMonster (6/23/2015)

---

WayneS (6/23/2015)

---

Brandie Tarvin (6/23/2015)

---

So I know it's dirty pool to promote one's own blog on the forums, but in this case, I absolutely MUST show off.

Click it and you'll...

he he, just like my youngest said yesterday, "I told everyone but I did not tell them that it was...

Ed Wagner (6/23/2015)

---

Eirikur Eiriksson (6/23/2015)

---

Ed Wagner (6/23/2015)

---

Wow - that's pretty serious. ...

Ed Wagner (6/23/2015)

---

Wow - that's pretty serious. They're only focused on...

Yup, the [head]<->[leather padded desk] and it still hurts:crazy:

😎

Surely this is meant for someone "slightly" younger;-)

Back to physics, inertia = mass x velocity, don't think you need to much of the...

Not only are the question's quality deteriorating but the responses to the answers are too

😎

PiMané (6/23/2015)

---

Hi,

I've a database with a table that has 16 columns that are searchable. There can be a numerous combination of those columns used for searching...

In this case the best...

Target

pjn (6/23/2015)

---

Basically I am try to cut down some processing time.

Currently in its simplistic form:

sql1 = "select table1.theSql,table1.userid from table1"

loop through sql1.resultset

...