Luis Cazares (10/27/2015)

---

This looks very similar to a running total problem (except that there's no total). This can be managed by the quirky update, a cursor or a triangular join....

David 76709 (10/27/2015)

---

Thank you.

That doesn't quite do it. I am still getting a NULL where the values of date_serial are not present in both tables:

date_serial ...

David 76709 (10/27/2015)

---

I have two tables one list changes of hospital ward and one lists changes of consultant doctor. These can change independently ie a ward change can occur...

Tara-1044200 (10/27/2015)

---

Hi, this query below is giving product join for me, is there a way to avoid this?

SELECT DISTINCT a.RevID, indexdate, transadate

FROM temp1 AS a

INNER JOIN temp2 AS d ON...

Seems to be moving around. A week or two ago it was...

pmb88 (10/26/2015)

---

I have a client who wants to start using tags with their items. I am having trouble on how to filter the data. For example I want only the...

Sheesh...

Jeff Moden (10/25/2015)

---

I agree. Since most spam posts are by new users, it would be good to also make the new user signup have an email verification process where...

jbalbo (10/21/2015)

---

Hi

I am using the following "MySortedRows" routine

...

select count(icd10)as counticd10 ,icd10

,ROW_NUMBER() over (order by count(icd10) desc) as Row

,case when ROW_NUMBER() over (order by count(icd10) desc) > 5 then...

Another highly likely issue for performance is the lack of normalization. You have to join to the same table over and over. If this was properly normalized that wouldn't be...

gentong.bocor (10/17/2015)

---

Yes, that's actually my design is calculating the formula based on the value of each rows. I made it because the user can freely adding any rows for a...

celticpiping (10/16/2015)

---

Howdy,

I'm trying to do the following:

update a tables value(a single column), based on a query of another database, using

a common column.

Here's what I've cooked up so far:

Declare @trackingNo nvarchar...

gentong.bocor (10/16/2015)

---

I have 2 tables, one of those table is master formula which has some records like this :

Table1: MasterFormula

NoDescriptionFormula

1Occupancy

2Leased

3Rate Consumed

4Rate street lighting

5AVG Installed Capacity

6Consumed a: Minimum Charges

7Consumed a:...

Same here. Oops!!

SQLPain (10/15/2015)

---

Thanks !!! its working

I read it somewhere merge statement has a less complicated code to write. which would be better in my case, merge or update? merge is getting...