anjaliagarwal5 (5/26/2015)

---

Hi All,

I have to modify a stored procedure that is written by someone else.Basically the stored prcoedure uses a cursor to fetch the data from the table...

This is exactly the...

How about:

SELECT X.Warehouse,

CASE WHEN Total_Quantity > 10 THEN CONVERT(varchar(100), Total_Quantity) ELSE 'There are less than 10 items in this warehouse' END

FROM

(SELECT Warehouse, SUM(Quantity) Total_Quantity

FROM #Product

GROUP BY...

A few more thoughts...

Is there any mechanism for a "parent" and "child" type questions?

Example 1, if you answer NO to question 5, you get taken to question 10. If...

You can probably find a local company that will do all of the admin work for you and pay you as a W-2 employee.

They are going to want a percentage...

1. Throw the trigger away.

2. In the trigger, you do this code:

set @P_NEW_ID = NEXT VALUE FOR dbo.SEQ_MASTER

Do this in the insert procedure!

You have the sequence, do...

To pile on to Erland's suggestion, run a script that disables all logins except your own.

Try this script.

Instead of doing a backup, detach, copy and re-attach.

This should be faster, plus, as soon as you detach the database will become unavailable.

Use caution, however, there may be some transactions...

Eric M Russell (5/18/2015)

---

Sean Lange (5/18/2015)

---

Michael L John (5/18/2015)

---

Jeff Moden (5/18/2015)

---

andrew gothard (5/18/2015)

---

Jeff Moden (5/14/2015)

---

This one is actually true.

Me, the interviewer: As the Lead Developer on this project, we're...

One of the shortcomings of using the maintenance plan wizard is that it blindly re indexes everything, regardless if the index is fragmented or not.

Subsequently, maintenance takes longer, deadlocks...

Jeff Moden (5/18/2015)

---

andrew gothard (5/18/2015)

---

Jeff Moden (5/14/2015)

---

This one is actually true.

Me, the interviewer: As the Lead Developer on this project, we're very interested in someone that understands and can...

I would recommend a calendar table.

http://www.sqlservercentral.com/articles/Test-Driven+Development/71075/

Interviewer: If your database was a country, what country would it be?

My answer: North Korea, because it will be run by a dictator!

Float is the problem. Compounded by dividing by an integer.

Is this money? Use decimal(21,5).

Floats are called inexact numerics for this reason. You may never get...