You give it that long do you Gaz? I'm thinking at least 20 years sooner...

'$' + cast(floor(Price*DollarPrice) as varchar)

This will give you $xx. You won't be able to do any calculations on that though. If you need to do anything...

You could use a Multicast Transform from the derived column. This lets you send the data multiple ways.

The attached image shows what I mean.

I'll be heading back North tomorrow after a very informative five day BI course in London town. I'm not entirely sure whether I'll be more excited to see my...

Felts

Well done Jason and Jack.

Thanks to those of you who had a look over the website for me, particularly Tom and Luis for taking the time to give such helpful...

Luis Cazares (9/30/2014)

These are some comments with no interest on diminishing your effort.

- Design could improve, but I can't give specific ideas.--I know, it's definitely a work in progress....

Four thousand plus points....

Anyway, could I possibly prevail upon the folks around here to do a little testing for me please. I've...

"Enter your text here ""

If you enter the code above without the " you get

This

To just post the link enter it as below

""http://dba.stackexchange.com/questions/77016/how-to-obtain-sql-feature-list-from-the-command-line""

Now I really am confused, I'm definitely misunderstanding something.

I thought CreatedOn was in the format yyyy-mm-dd hh:mm:ss.ttt. Where does the string come from?

If your dates are stored as

2014-09-26 14:25:51.310

2014-09-26 12:46:42.647

2014-09-24 14:49:35.190

2014-09-24...

Good spot Chris. I'd mentally accounted for it but forgot to actually write it in.

create table #Test

(

CreatedOn datetime

,ID int identity(1,1)

)

insert into #test

select '2014-09-26 14:25:51.310' union all

select '2014-09-26 12:46:42.647' union all

select '2014-09-24 14:49:35.190' union all

select '2014-09-24 12:39:21.150' union all

select '2014-09-19 15:22:36.233' union all

select '2014-09-19...

I'm struggling to understand what you need. Is that the only row you need returning? Can you post some sample data please.

What exactly is the problem? You need to be very careful using BETWEEN with datetime. You're much better using >= and <=.