Jack Corbett (5/29/2013)

---

Sean,

I think your choices to produce N rows from 1 row are some type of explicit loop or a triangular join. I think the triangular...

Jack Corbett (5/29/2013)

---

Luis Cazares (5/29/2013)

---

There's a small mistake on Jack's code. A simple tweak on line 19 will correct it.

--Corrected line

CONVERT(INT, CEILING(quantity / CAST( @quanityPerRow AS decimal(10,2)))) AS...

You should look into...

Lynn Pettis (5/29/2013)

---

It is scanning the entire table because it has to check every row to determine if it matches the criteria for the WHERE clause. If the clustered...

In essence you are passing a delimited string where a space is your delimiter. You can use the DelimitedSplit8K function for this quite easily. You can find the code for...

Sounds to me like parameter sniffing.

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/%5B/url%5D

http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/%5B/url%5D

prakashr.r7 (5/29/2013)

---

Hi Friends,

I am trying to track a multi user application . I am one of the user. I want to...

dan-572483 (5/28/2013)

---

How about in a WHERE EXISTS clause?

According the the Querying SQL2012 exam prep book, a SELECT * inside an EXISTS clause returns true or false only - not all...

----------------------

-- #4 - Now update the CRM CEB table

----------------------

DECLARE @Rows int = 1

--DECLARE @RowPrint int

DECLARE @BatchSize int = 5000

WHILE...

dwilliscp (5/28/2013)

---

If you have a record, where there are 12 columns, one for each of the last 12 months, and you want to use STDEVP, how would you go about...

drew.georgopulos (5/28/2013)

---

how can i tell of transactions are written as 'all or nothing'...i realize they are acid, but for example, if there is an update that is going to affect...

sqlguy-736318 (5/28/2013)

---

Hello - I have a stored proc that's not completing.

I ran it once before and it completed in 1.5 hours but then I ran the same proc on Friday...

So to answer your question. NO this isn't possible. #1 and #3 make this impossible. If you have a default, you have a constraint. Give a shot and check it...

keshava.murthy (5/28/2013)

---

If I try order by month( startdatetime) then it sorts the data by month.

The problem here is when the data spans to multiple years then it will sort as...

NJDave (5/28/2013)

---

Hello - I am inheriting 5 servers to administer from a jack-of-all-trades DBA/developer in another department.

2 of the instances are SQL 2000 standard and are worried that SQL 2000...