christophe.bernard 47659 (10/28/2015)

---

Hi yb751, Luis Cazares

thanks for your time that's exactly what I want ..

I don't know the function pivot but I can see that's very powerfull ..

@yb751 => your...

Oh well, guess I'll just take my point for posting here instead. 😉

Luis Cazares (10/27/2015)

---

Yes, it's...

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....

Your question isn't very clear. I'll take a stab at it but I can't be sure its what you are looking for. At the very least maybe I...

Just though I should add that you can also use INTO in a UNION statement to load the data into a new table. Just be aware that only the...

Well wasn't the original seed value 1?

IDENT_SEED

https://msdn.microsoft.com/en-CA/library/ms189834.aspx

DBCC CHECKIDENT

https://msdn.microsoft.com/en-us/library/ms176057.aspx

Checks...

GilaMonster (10/5/2015)

---

With poor queries, that'll just make matters worse. If the queries can't...

The upcoming 'Stretch Database' feature in SQL 2016 may be exactly what you are looking for. I know this doesn't help you at the moment but it might be...

Lowell (10/5/2015)

---

agreed. they added code that insta-deletes anything Celko posts(thank you for that!), so they can reuse that same code, and just add something that detects the new user spamming...

No problem, I also noticed a potential problem with your string concatenation.

CA.house_num + ' ' + CA.street_name + ' ' + CA.apt_num AS [MailingStreet]

If there is any chance that...

DISTINCT applies to the whole result set not just for that one column. Just remove 'application_id' from the select statement and see what you get. That being said...

Absolutely, there is a great write up here: http://www.sqlservercentral.com/articles/Best+Practices/61537/

You should try to provide a test table which will help you get help much faster.

Like this:

DECLARE @Milestonetable TABLE (JobNo INT, MileStoneName CHAR(1), ForecastDate DATE, ActualDate DATE, StatusFlag CHAR(1))

INSERT INTO...

This remind me of the old saying.

Always use the right tool for the job and...