Nadrek (2/17/2014)

---

Luis Cazares (2/17/2014)

---

It's easy to take family members off of WinXP. Not so easy for companies that need lots of licenses and testing time to make sure nothing is...

Will you always have your output in one line?

It's easy to take family members off of WinXP. Not so easy for companies that need lots of licenses and testing time to make sure nothing is going to break....

You can read the stairways[/url] in this site, as well as the articles. You can try to solve problems from the forums even if you don't post the answer but...

1.- No, password information is never revealed.

2.- Not exactly, just number of rows (AFAIK).

It's more for databases meant for reading and not for writing. Basically reporting or some kind of OLAP.

You're right. You need to create a tally or numbers table.

mike 57299 (2/14/2014)

---

Does it really matter if they tried? If they understand the solution you present or they learn something, isn't it what the forum is really about?...

I'm sorry, your answer makes it completely different. I'm sorry but many people come here and ask questions without even trying anything (some people believe that is easier to write...

Have you even tried looking for "CREATE SCHEMA" on google?

That can be true (even if it usually isn't).

To get this right withuot a cursor, the best option is a method (which some call undocumented feature) called Quirky Update. You must read about this method on the following...

That inner join won't give you a better performance as your condition is non-SARGable. You should remain with a LEFT JOIN like this:

SELECT Customer.CustomerId, ISNULL( Location.Description, 'Unknown Location') Description

FROM Customer...

What do you mean by O/P?

DATEDIFF will always return whole numbers.

dhananjay.nagarkar (2/14/2014)

---

Dear Journey Man,

I have to calculate the value for a field "[ORC Position Duration (months)]" using the following 2 fields from DataBase source- 1)Target Start Date , and 2)...