Luis Cazares (7/7/2014)

---

david.holley (7/7/2014)

---

Jeff Moden (7/7/2014)

---

jfogel (7/7/2014)

---

Great, just great. A year ago I wrote something that has to break down a CSV-style parameter string and it uses a loop to...

If the column is a datetime data type, there is no formatting of the value. What you are showing are two different character representations of the same datetime value.

Jeff Moden (7/6/2014)

---

Not really... I like to know what the business reasons actually are and not that they simply exist. The reason is that people making the business decisions...

I would also like to see the code for the view using this function.

You mean:

... but the internal sequence must start at 1.

I wish...

Jeff Moden (7/6/2014)

---

Mac1986 (7/5/2014)

---

Point taken. My plan is to drop all the Non Clustered indexes in all 6 tables and only add them in case by case basis.

Can you...

Are we doing the SSC Fantasy Football League again this year?? I need to regain the crown.

Hopefully what I posted works for you, unfortunately I just noticed that you had posted in a SQL Server 7/2000 forum and the code I provided will work in SQL...

This?

Maddave (7/5/2014)

---

It's data that...

Updated the code above.

While waiting for what you tried I thought I'd give it a shot. Is this basically what you were looking for?

select

*,

rn...

And what code have you developed so far in an attempt to solve your problem?

Sounds like it may not be doable.

Tell us more about the ID's in the tables. In fact, it may help if you could post the DDL for the tables...

Can you modify the child tables to have a datetime column?

Actually a duplicate post, please post answers here: http://www.sqlservercentral.com/Forums/Topic1589548-3077-1.aspx?Update=1