Thanks again Lowell. Here is my code...

SELECT INTERVALSTART

,RIGHT(INTERVALSTART, 7) as Times

...

LOL, sorry, I meant 12 hour clock instead of a 24 hour clock.

Thanks

Thanks Lowel (and everyone else who responded), very helpful.

Is there a way I can display this time in USD format?

Thanks Very Much!

In addition to the great advice from Koen....

SSAS is tough because building and querying cubes is much different than querying a database. Data Warehousing requires you to "De-normalize" data when...

Hello,

In my humble opinion I do not think you should focus on only one area of SQL. This limits you tremendously, plus you will have to write T-SQL code for...

Thanks very much for your response!

Cool thanks.

So, I would just import the .rdl file into VSS? No .rdf necessary?

Thanks so much for your response.

Look around amazon for a publishing company call "Wroxx". I have been reading the SQL Server books by Robert Vierra and it has really stepped up my SQL game. I...

Thank you so much. You are correct, this is not a rounding issue, that's why it wasn't working! Awesome!

Thanks! I am new to SSRS, so simple things like this are a bit challenging. Thanks very much for your time 🙂

Apologies for not being clear and thanks so much for your response.

Ok, so basically I have a time value (1:2:3) as vachar and want to ensure that the zero's...

Unfortunately, I am using SQL 2005, so it's a varchar. Here is the expression. Pardon the spaghetti code...

=(SUM(Cint(Split(Fields!ACDTime.value,":").GetValue(0)))

+ (SUM(Cint(Split(Fields!ACDTime.Value,":").GetValue(1)))

+ Sum(Cint(split(Fields!ACDTime.Value,":").GetValue(2)))\60)\60 ).ToString

+ ":" + ((SUM(Cint(Split(Fields!ACDTime.Value,":").GetValue(1)))

+ Sum(Cint(split(Fields!ACDTime.Value,":").GetValue(2)))\60) Mod...

Thank you very much for your time. This was helpful 🙂

I would love to just kick it off and cross my fingers but we do not have DR. That is...

Thanks very much for your response.

Quick question, we do not have a DR environment set up, so how do you recommend I deal with the SQL jobs that run every...