hoolash (12/3/2013)

---

Thank you for your solutions guys! Sorry for getting back late on this topic.

I am still a bit confused at the final solution proposed by ben.brugman.

If I understand well,...

This link should explain what needs to be done.

http://www.sqlservercentral.com/Forums/Topic558696-338-1.aspx

However, you may need an additional cast since your numerics are stored in a non-numeric datatype.

Also, if you look at the solution,...

DaveDB (11/25/2013)

---

Hello,

I am having issues rounding this number. I have a number that is a float (0.981) and I need to convert it to read (98.1) or (98.10). I have...

Test, test, and test!!

There are a number of techniques to populate a test table with millions of rows in...

This was discussed just recently.

http://www.sqlservercentral.com/Forums/Topic1511574-3412-1.aspx#bm1511578

If you are deleting more than you are keeping you can populate a duplicate empty table with the rows you want to keep, delete the old...

rlindstrom 38273 (11/6/2013)

---

I also included the select query that works as needed until I use the WHERE clause with dates. Excuse my ignorance but not sure what else you...

Why does it have to be a...

To make sure any answer is correct, please read the link under the signature line on how to post questions.

Can't you just do the following to pick up the null...

Briceston (11/2/2013)

---

I have added the extra closing paraenthesis, but still getting the same error.

LinksUp (11/2/2013)

---

Just an extra closing paren.

INNER JOIN cte2 b ON a1.AdmitCCYYMM = b.EffectiveCCYYMM

LEFT...

Just an extra closing paren.

INNER JOIN cte2 b ON a1.AdmitCCYYMM = b.EffectiveCCYYMM

LEFT JOIN cte1 a2 ON a1.AdmitCCYYMM = SubString(CONVERT(varchar, DATEADD(Month,1,a2.AdmitCCYYMM + '01'), 112), 1, 6)

...

This does not seem be a difficult problem. But as was mentioned, a lack of DDL for the tables and Indexes makes this very difficult to understand. This is an...

Briceston (10/31/2013)

---

I tried casting the date, but still had issues. My date field format is: YYYYMM

SELECT

(COALESCE(a1.Cost,0) + COALESCE(a2.cost,0) + COALESCE(a3.cost,0))/(3.0*b.numberofMembers)

FROM

cte1 a1

INNER JOIN cte2 b ON a1.AdmitCCYYMM = b.EffectiveCCYYMM

LEFT JOIN cte1...

This may help in getting you started in the right direction:

select *, DENSE_RANK() over(order by id) DRank

from #tester

The rnk column is not even needed. In can be generated at any...

You are getting that error because the 2nd exists query knows nothing about the alias ta at the time...

aeri_q (10/26/2013)

---

What i want, is a check like this, to be applied on NO_RANGE column of ASSET_CLASS at the time of insertion:

CHECK (LIST IN (SELECT NO_RANGE FROM RANGE WHERE ACCNT_TYP...