In SSRS is really easy.

=Format(Parameters!intTime.Value, "#0:00:00")

No, PowerBI is an independent platform. You can work online or use the desktop application.

Power Query , Power View and Power Map are different products.

Here's a formula to get it.

DECLARE @t TABLE( iTime INT);

INSERT INTO @t VALUES(33059),(103743);

SELECT iTime,

RIGHT(STUFF( STUFF( 1000000 + iTime, 6, 0, ':'), 4, 0, ':'), 8)

FROM @t;

Avoid...

You're welcome. I hope you understand how this works, and if you don't ask any questions you might have.

I tried to keep it 2000 compatible, but a different solution might...

Why do you think I have it?

And if I did, I wouldn't share it to anyone,...

I need to get out of the office, but this might give you an idea for a function.

--234234,234089,295380,111111

DECLARE @number varchar(10) = 123469;

DECLARE @CountConsecutive int = 1,

...

Error 1: IF statements can't be part of a SELECT statement, that's what CASE is for. IIF can be used only on 2012+ versions.

Error 2: AVERAGE function (which is AVG)...

Raghavendra Mudugal (5/5/2016)

---

Luis Cazares (5/4/2016)

---

No need for cursors, or several statements.

WITH CTE AS(

select distinct personid from @t

)

SELECT PersonID,

...

Onion

scott_carl_turner (5/5/2016)

---

thank you for the advise,

i have been practicing on SQL server 2012 express, management studio with the adventureworks DB which was provided.

this might sound dumb but what is the...

The first step is to get your copy of SQL Server Developer Edition (includes all the features but shouldn't have production data) and install it. If you want to try...

Any of those columns is nullable? Can you post DDL and sample data?

Use a tally (or numbers) table. Here's a great article on them https://dwaincsql.com/2014/03/27/tally-tables-in-t-sql/

WITH

E(n) AS(

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

),

E2(n) AS(

SELECT a.n FROM E...

You almost had it, you just needed to complete the CASE statement. Also make the range start inclusive.

SELECT b.cust_code,

a.part_no,

...

Nallya (5/5/2016)

---

Hello,

i have one column having data like

777777777777777777 0 ...