rockyshi (4/18/2016)

---

DECLARE @locale AS VARCHAR(25);

SET @locale = 'User!Language'

DECLARE @lcid AS INT;

SET @lcid = dbo.fn_LShortNameToLCID(@locale)

DECLARE @Machine_Class AS VARCHAR(25);

SET @Machine_Class = 'Server'

DECLARE @Vendor AS VARCHAR(25);

SET @Vendor = 'Microsoft'

DECLARE @Assignee AS VARCHAR(25);

SET @Assignee...

I understand being a bit overwhelmed when working with something new but you have got to learn some...

Eirikur Eiriksson (4/15/2016)

---

Ed Wagner (4/15/2016)

---

Greg Edwards-268690 (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

jeff.mason (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Quick fix in three...

Sergiy (4/14/2016)

---

Lynn Pettis (4/14/2016)

---

Sean Lange (4/14/2016)

---

Those nested views are going to kill your performance something fierce....

Of course you do realize that all the same people that still start a cte with a semicolon...

Huh? That is not helping us understand what you are having a problem with. There are three people so far in...

Luis Cazares (4/14/2016)

---

Ed Wagner (4/14/2016)

---

Luis Cazares (4/14/2016)

---

Ed Wagner (4/14/2016)

---

SQLRNNR (4/14/2016)

---

Luis Cazares (4/14/2016)

---

Is this guy for real?

How is it possible that he can't work out a basic DML statement and still...

Luis Cazares (4/14/2016)

---

Phil Parkin (4/14/2016)

---

Steve Jones - SSC Editor (4/14/2016)

---

Well, apparently I don't write good questions to teach these people things.

Maybe some of you should write some questions to help...

Ed Wagner (4/14/2016)

---

Sean Lange (4/14/2016)

---

Phil Parkin (4/14/2016)

---

Steve Jones - SSC Editor (4/14/2016)

---

Well, apparently I don't write good questions to teach these people things.

Maybe some of you should write some questions...

Phil Parkin (4/14/2016)

---

Steve Jones - SSC Editor (4/14/2016)

---

Well, apparently I don't write good questions to teach these people things.

Maybe some of you should write some questions to help people learn...

Those nested views are going to kill your performance something fierce. They seem so logical but...

Mike Frazer (4/13/2016)

---

Yes, I included the execution plan. There is an icon called 'Key Lookup (Clustered)' that accounts for 68% of the cost.

Physical Operation: Key Lookup

Logical Operation: Key Lookup

Actual/Estimated...

fareedhmohamed (4/13/2016)

---

Hi,

I have a question regarding increments in trigger. I want to update a field in customer table, if the same customer has more than two orders. I am not...

EamonSQL (4/14/2016)

---

Hi,

Is it possible to find out which updates were made against a first, second, third etc nested transactions?

For example, if select @@trancount returns 4 can I find out what...

The next question is why are you storing dollar amounts as formatted text instead of decimals?