Viewing 15 posts - 2,881 through 2,895 (of 8,731 total)
Ed Wagner (5/9/2016)
Grumpy DBA (5/9/2016)
Ed Wagner (5/9/2016)
PlunderPillage
Treasure
Hunt
May 9, 2016 at 7:56 am
In SSRS is really easy.
=Format(Parameters!intTime.Value, "#0:00:00")
May 9, 2016 at 7:19 am
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.
May 6, 2016 at 9:58 am
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...
May 6, 2016 at 9:31 am
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...
May 6, 2016 at 6:43 am
amar_sharma (5/6/2016)
@luis Cazares, I'll try that. Could you please help me with his genuine email?Thanks.
Why do you think I have it?
And if I did, I wouldn't share it to anyone,...
May 6, 2016 at 6:07 am
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,
...
May 5, 2016 at 2:38 pm
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)...
May 5, 2016 at 1:37 pm
Raghavendra Mudugal (5/5/2016)
Luis Cazares (5/4/2016)
Raghavendra Mudugal (5/4/2016)
(EP)Z!!!No need of STUFF. (very old code)
No need for cursors, or several statements.
WITH CTE AS(
select distinct personid from @t
)
SELECT PersonID,
...
May 5, 2016 at 11:57 am
Ray K (5/5/2016)
Ed Wagner (5/5/2016)
Eric M Russell (5/5/2016)
ThomasRushton (5/4/2016)
TomThomson (5/3/2016)
Ed Wagner (5/3/2016)
RandyThe Band
Bonzo
Garbonzo (the bean, otherwise known as chickpea)
Hummus
Garlic
Onion
May 5, 2016 at 10:54 am
scott_carl_turner (5/5/2016)
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...
May 5, 2016 at 10:36 am
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...
May 5, 2016 at 9:51 am
Any of those columns is nullable? Can you post DDL and sample data?
May 5, 2016 at 9:31 am
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...
May 5, 2016 at 8:33 am
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,
...
May 5, 2016 at 7:39 am
Viewing 15 posts - 2,881 through 2,895 (of 8,731 total)