Lynn Pettis (12/22/2015)

---

Silver Spoon really doesn't seem to care about learning anything. Just the answer, that's all he is interested in.

I really hope there is someone else there who...

Alvin Ramard (12/22/2015)

---

Phil Parkin (12/22/2015)

---

Plugging...

I prefer making sawdust as my form of therapy.

From your description of the situation I would add a few columns to a table. As described this would be a 1:1 relationship which is really kind of silly. Since...

jeffshelix (12/21/2015)

---

I was trying to divide by 0, but then learned I have to Cast as Numeric.

not sure how that works, I've tried every syntax I can find online ....

This should work.

ALTER TABLE [TableName] REBUILD WITH (IGNORE_DUP_KEY = ON)

You do know that only...

jasona.work (12/21/2015)

---

Ah, what worries have I...

To go for a nice, relaxing massage after work, or to burn off some stress punching holes in paper with high-velocity pieces of lead...

Decisions, decisions,...

s.kandepi3 (12/21/2015)

---

I am inserting some data from a self join CTE into a table. When i do select * into to load data into that table it works fine. But...

pherman777 (12/21/2015)

---

The reason I am posting on multiple sites is that I am under a deadline (as is the case for most of us). I don't believe it is required...

pherman777 (12/21/2015)

---

OK. I got the values to come in using a comma delimited list. The execution time was a matter of seconds but now the issue is I need to...

pherman777 (12/21/2015)

---

I am using a function to split the strings on all parameter values and the query does work when I input hard-coded values. The issue is it is taking...

T2512 (12/21/2015)

---

That's what i always thought, from a users perspective speed is the only factor.

During an interview I was asked apart from reducing speed, what else does a developer...

T2512 (12/21/2015)

---

Hello

I am relatively new to SQL Server. I had a view that was taking about 10 min to run, i was able to reduce the time to 3 seconds...

pherman777 (12/21/2015)

---

Does this also work when executing the stored procedure with hard-coded values? The number of possible equipment class values is taking a long time to execute which is why...

pherman777 (12/18/2015)

---

I have a stored procedure in which I need to set the parameter equal to a column in a table. I have tried @parameter = select distinct column_name from...