SELECTLEFT(EngineMakeAndModel,CHARINDEX(' ',EngineMakeAndModel)),

RIGHT(EngineMakeAndModel,LEN(EngineMakeAndModel)-CHARINDEX(' ',EngineMakeAndModel))

FROM

(values('engines')) as x(select engine from units)

can i do the one above?

I want the Input to come from the Select Statement i have provided

Much Thanks

Noel

Good Afternoon Guys,

The EngineMakeModel is The Raw Column that is not Yet Concatenated and would need to be split into th

EngineMake Columnd and Model Column Separately. The Input would also...

By The Way. The Report is a Subscribed report and was received via e-mail. the device that was having a problem rendering the report in e-mail is an IPhone 4...

Hi Gsquared.

Thanks for giving me an advice on this problem. i will be testing my code for this one later and give you feedback on this one. again much thanks

Best...

Much Thanks Sir. It Did Work For Me!!! 🙂

Hi Lynn,

This Is Awesome!!! Much Thanks

Best Regards,

Noel

Hi Lynn. Yes, I was trying to Set All The Dates To January 1 (For Data Scrubbing Purposes). i am also thinking if a trigger is causing this error? any...

Hi,

i try to run the report and was able to display the months but in even order. (February, April, June, August, October, December). i am not sure why the...

Thank you Very Much Daniel i will be testing this on my own Database. by the way the Query that i created for the report is displayed below.

AS

BEGIN

SELECT convert(varchar(7),...

Hi Mark,

Thanks For the Clue You Gave Me The Format("") thingy. it did the trick.

Much Thanks

Thanks Matt,

I was able to do the Data manipulation in SSRS and worked fine for me. i also tried Your Sample Solution and this also worked perfectly to my...

Thank you guys so much for the help. i would be needing these tools to rewrite the SP's that is running slowly here in our company. i am barely a...

Good Morning To All,

I would like to ask if there is A Tool Besides SQL Profiler that can measure the performance of a certain stored procedure? any advise/help from you...

Hi Jack.

I've Done It.I've tested it in my reports and it did the thing for me.

thank you very much for your assistance.

Best Regards,

N.O.E.L.

Hi Sir,

I Modified The Reporting Parameter to Allow null, but the RS doesnt allow me to do so. i've already set a Dummy Value('ALL') to the Select Statement which will...