myzus2004 (9/26/2015)

---

Thanks all for sharing your ideas / opinions.

I have attached few costly queries . The query number is same as the query number in execution plan.

The time statistics...

eric-silva (9/25/2015)

---

Hi there,

I have to increment sequencial values for the following:

Current Data

Col1 Col2 Col3

12.345.678 0001 ...

Wayne West (9/25/2015)

---

Sounds like the ERP system used by a previous employer. I told...

zulmanclock (9/25/2015)

---

Hello all. I have a strange one that i have never encountered and at this point am totally lost. We have a proc that adds some fields to a...

Well actually he didn't even reference them anywhere in...

danielfountain (9/25/2015)

---

Sean Lange (9/25/2015)

---

danielfountain (9/25/2015)

---

Hi all,

I have been away from SQL for a couple of months, and for the life of me cannot work out a simple way to do...

John Mitchell-245523 (9/25/2015)

---

Sean, I think he's wanting to insert the values into tblVoting, and at the same time return the inserted values as output parameters. Obviously that'll only work...

deedv (9/25/2015)

---

Hi All.

I am trying to write a stored procedure that is an INSERT INTO <sql table> FROM <other sql tables> WHERE <where clause>.

I need to insert 3 columns...

Let's start with this...how do you deal with delimited values? Do you have a...

Alvin Ramard (9/25/2015)

---

Sean Lange (9/25/2015)

---

Alvin Ramard (9/25/2015)

---

Sean Lange (9/25/2015)

---

And let's not overlook the fact that the OP is converting a PO Number to a float. A numeric would be a...

danielfountain (9/25/2015)

---

Hi all,

I have been away from SQL for a couple of months, and for the life of me cannot work out a simple way to do what i want...

Steve Jones - SSC Editor (9/25/2015)

---

jasona.work (9/25/2015)

---

I've been wanting to pile into that topic, but keep restraining myself...

Hmm. Maybe we need to Godwin that topic, and bring in a...

Alvin Ramard (9/25/2015)

---

Sean Lange (9/25/2015)

---

And let's not overlook the fact that the OP is converting a PO Number to a float. A numeric would be a much better option than...

myzus2004 (9/25/2015)

---

Hello Guys,

i got a requirement from business that they need pagination for an application.

The stored procedure takes ~ 10 seconds every call. The execution plan is Index seek...

And let's not overlook the fact that the OP is converting a PO Number to a float. A numeric would be a much better option than float. And if you...