JohnFTamburo (1/27/2014)

---

So.... How does this work with selecting values from columns in a table? Using this would take at least two or more conversions per row on...

peter-757102 (1/27/2014)

---

This will indeed not work:

(code)

But this will:

(code)

As the l-value type is already a datetime and can hold the time part that is added.

You just found a case where it...

JohnFTamburo (1/27/2014)

---

PHYData DBA (1/27/2014)

---

Could you give me an example of how this should be done? Maybe you did not understand the questions...

How would YOU take the two different data...

declare @time1 time(0)

,@date1 date

,@sdate smalldatetime

SELECT @time1 = '16:20', @date1 = '2013-04-20'

SELECT @sdate = @time1

select @date1 +...

JohnFTamburo (1/22/2014)

---

PHYData DBA (1/22/2014)

---

Jeff,

In reference to your comments about using date and time data types.

How would you recommend we take a date value and a time value and convert them...

Jeff Moden (1/23/2014)

---

PHYData DBA (1/22/2014)

---

Jeff,

In reference to your comments about using date and time data types.

How would you recommend we take a date value and a time value and convert...

Jeff,

In reference to your comments about using date and time data types.

How would you recommend we take a date value and a time value and convert them to a smalldatetime...

Jeff Moden (1/22/2014)

---

mtassin (1/22/2014)

---

Jeff Moden (1/21/2014)

---

what I've seen on the query plan is that it typically grabs the few rows from the calendar table with a clustered index scan (yes...

Thanks for the easy question Steve.

Having worked a lot with all types of replication this might have been easier to answer for me that the 45% that have not found...

To everyone that has commented about calculated columns, functions for values, and using something other than an Integer as a PK and row ID for Dimension tables.

I appreciate your comments...

Jeff Moden (1/21/2014)

---

PHYData DBA (1/21/2014)

---

I want to thank everyone that took the time this morning to read my article and comment on it.

I had no idea that my...

I want to thank everyone that took the time this morning to read my article and comment on it.

I had no idea that my very first submission would...

davoscollective (1/21/2014)

---

raulggonzalez (1/21/2014)

---

davoscollective (1/21/2014)

---

Ah yes you are correct, my mistake, the maxrecursion 0 removes the limit. I agree, go for the better performing code. It is one statement, but internally...

davoscollective (1/21/2014)

---

raulggonzalez (1/21/2014)

---

PHYData DBA (1/20/2014)There might be several other ways of doing this without using a Row By Row script. We could not find one that was as easy to...

mtassin (1/21/2014)

---

Jeff Moden (1/21/2014)

---

Just a couple of thoughts...

First, these two tables are one of the few places where I'd use the natural key of either the date or the time...