SELECT

CONVERT(varchar(10), CAST(CounterDateTime AS datetime), 101) AS Date,

RIGHT(CONVERT(varchar(20), CAST(CounterDateTime AS datetime), 100), 7) AS Time

FROM table

Jeff Moden (12/24/2013)

---

Awesome! I don't believe anything will...

If you don't have any data longer than 24 bytes (or so), it might be easier just to "brute STUFF" it:

WITH SampleData (MyStr) AS

(

SELECT '12345678'

...

Jeff Moden (12/20/2013)

---

ScottPletcher (12/20/2013)

---

Evil Kraig F (12/20/2013)

---

ScottPletcher (12/20/2013)

---

Admittedly the gain is much clearer when the clustering key is the ISNULLed column. So, let's just flip the clustering keys on...

Evil Kraig F (12/20/2013)

---

ScottPletcher (12/20/2013)

---

Admittedly the gain is much clearer when the clustering key is the ISNULLed column. So, let's just flip the clustering keys on your original table...

Evil Kraig F (12/20/2013)

---

ScottPletcher (12/20/2013)

---

Admittedly the gain is much clearer when the clustering key is the ISNULLed column. So, let's just flip the clustering keys on your original table...

Evil Kraig F (12/20/2013)But, I'd like to bring us back to the origination of this minor alteration in the direction of this topic, and that's SARGability and effeciency and if...

Evil Kraig F (12/20/2013)

ScottPletcher (12/20/2013)

---

There could be great harm in it if either (1) SQL could have done seeks on both terms and produced the final output more efficiently than...

Jeff Moden (12/20/2013)

---

ScottPletcher (12/20/2013)

---

Jeff Moden (12/20/2013)

---

ScottPletcher (12/19/2013)

---

I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent...

Jeff Moden (12/20/2013)

---

ScottPletcher (12/19/2013)

---

I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent not to use...

Snargables (12/19/2013)

---

I had to create an index that added all the columns in the include of the index. This was because i created a function that has to return all...

wolfkillj (12/19/2013)

---

ScottPletcher (12/19/2013)

---

Jeff Moden (12/18/2013)

---

ScottPletcher (12/18/2013)

---

If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather than...

Sigerson (12/19/2013)

---

Grant Fritchey (12/18/2013)

---

I could, but won't, argue that identities are a crutch. Natural keys can work fine. I try not to worry too much about the key structure while...

Jeff Moden (12/18/2013)

---

ScottPletcher (12/18/2013)

---

If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather than having a...

I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent not to use it in IF...