OK so...

That looks like Oracle not SQL Server. SQL Server doesn't have a TO_CHAR function. 😛

I am willing to help you but you have to provide enough details for me to...

Thanks for sharing Scott. That gives me an idea of what you are doing here. Never really thought of using the extended properties like that. Gives me some cool ideas...

cleanup

headmanracer (12/26/2012)

---

I need some help with SQL to capture transactions posted 90 days prior to month end for the last 12 months. I have a table named TRANSACTIONS and...

Well unless you can share a LOT more details there is not much I can offer. This sounds like a challenging situation.

ScottPletcher (12/26/2012)

---

Sean Lange (12/26/2012)

---

ScottPletcher (12/26/2012)

---

Sean Lange (12/26/2012)

---

SQL_Kills (12/26/2012)

---

Hi,

First of all I hope everyone has had a good Christmas!

Just wanted to know if anyone documents there table using MS_Description? I'm...

WangcChiKaBastar (12/26/2012)

---

I have a stored procedure and when I run it First time it creates an execution plan and it takes long time to complete which is understandable after the...

This seems to be a representation of what you are looking for.

create table #Client

(

ClientID int identity,

Name char(2)

)

insert #Client

select 'C1' union all

select 'C2' union all

select 'C3'

create table #Orders

(

OrderID int identity,

ClientID int,

OrderName...

ScottPletcher (12/26/2012)

---

Sean Lange (12/26/2012)

---

SQL_Kills (12/26/2012)

---

Hi,

First of all I hope everyone has had a good Christmas!

Just wanted to know if anyone documents there table using MS_Description? I'm struggling to think...

You are right Adi. I was the one missing something. :blush:

Hugo Kornelis (12/26/2012)

---

Basics? That's not how I would describe it! :w00t:

Thanks for a good question, Sean. I think I once read or heard that after deleting all rows from a...

Great question. A bit hard to read through the formatting but is not the author's fault.

Adi Cohn-120898 (12/26/2012)

---

Makes perfect sense. I was missing something:-)

Adi

edited: Sorry, just had a look at it. It does seems to work. According to the where clause one...

Golfer22 (12/25/2012)

---

Tinyint and bit have a higher precedence than ntext. Why is this? Couldn't ntext we complex alphanumeric values? Tinyint and bit are limited and simple.

What precedence...