Nilssond (4/13/2016)

---

I have data in a string column such as $154,111.85

My task is to reduce this string to 154111.85 The string values can range from $1,000.00 to $700,000.00

Is there...

2Tall (4/13/2016)

---

Hi. I have tried adding CASE to WHERE clause.

WHERE

GLItems.GLYearPeriod =

CASE

WHEN MyCal.AccountingPeriod = 1 THEN ((MyCal.AccountingYear * 100 -1) + MyCal.AccountingPeriod + 11)

ELSE GLItems.GLYearPeriod = (MyCal.AccountingYear *...

2Tall (4/13/2016)

---

Hi Luis/Sean. I confirm I DO NOT wantt to use the parameters hence the re-write to enable VIEW creation.

Luis I did re-write as inline table function but I was...

FunkyDexter (4/13/2016)

---

Hi Sean. Thanks for the response and sorry if I was unclear. Let me see if I can clarify that a bit.

The values in the second column on...

What defines a pair? This just seems to be totally random what values get paired. There does not appear to be any solid business rule here.

Why is 8,5 a pair?...

Not really sure if you need parameters or not. You mention them but also have a commented query using the current date. If you need parameters than use the fine...

Hugo Kornelis (4/11/2016)

---

Sean Lange (4/11/2016)

---

Forget about optimization for a second. Think about normalization. What are you going to do when a user name changes? Somebody changes their name and suddenly...

Stating the relative cost of the batch when compared to the contents of...

The code posted seems to have both READUNCOMMITTED uncommitted and NOLOCK thrown around all over the place. I realize some of this is vendor code but you should read up...

With the replace function. https://msdn.microsoft.com/en-us/library/ms186862.aspx

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Forget about optimization for a second. Think about normalization. What are you going to do when a user name changes? Somebody changes their name and suddenly you have to update...

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1776192-3077-1.aspx

SQLRNNR (4/6/2016)

---

jasona.work (4/6/2016)

---

SQLBill (4/6/2016)

---

Sean Lange (4/5/2016)

---

Luis Cazares (4/5/2016)

---

I constantly avoid...

c_wager (4/5/2016)

---

Hi, My first post here seeing as how I became the accidental admin for our databases.

Learning a lot the last few months, but I believe I have an performance...