Viewing 15 posts - 6,136 through 6,150 (of 18,926 total)
stan-617410 (5/13/2011)
Running this query throws the "Subquery returned more than 1 value." error.What am I missing?
Thanks for your help.
You have a trigger on the updated table that can't handle...
May 13, 2011 at 10:32 am
SanDroid (5/13/2011)
Steve Jones - SSC Editor (5/13/2011)
Hugo Kornelis (5/13/2011)
In the daily newsletter, the question specifies to "select 4". Which is what I did. And then I find that the site...
May 13, 2011 at 10:23 am
Sean Lange (5/13/2011)
May 13, 2011 at 10:03 am
Mark-101232 (5/13/2011)
SELECT dt, DENSE_RANK() OVER(ORDER BY YEAR(dt), MONTH(dt)) rn FROM @tblORDER BY dt
Nice, had never seen that function before!
May 13, 2011 at 10:00 am
I had actually read it correctly the first time :hehe:
SET DATEFORMAT YMD
DECLARE @tbl table (dt datetime)
insert into @tbl (dt)
SELECT
'2010-02-01' UNION ALL SELECT
'2010-02-03' UNION ALL SELECT
'2010-02-05' UNION ALL SELECT
'2010-02-10' UNION ALL...
May 13, 2011 at 9:59 am
Sorry I misread the question!!!!!
SET DATEFORMAT YMD
DECLARE @tbl table (dt datetime)
insert into @tbl (dt)
SELECT
'2010-02-01' UNION ALL SELECT
'2010-02-03' UNION ALL SELECT
'2010-02-05' UNION ALL SELECT
'2010-02-10' UNION ALL SELECT
'2010-02-12' UNION ALL SELECT
'2010-03-01' UNION...
May 13, 2011 at 9:52 am
check out partition by in the row_number topics of books online.
May 13, 2011 at 9:33 am
You must have your data like this :
gross fy1, fy2, fy3....
net fy1....
Create a new group on rows on group on the column that contains the run type. ...
May 13, 2011 at 9:30 am
With (Base query)
SELECT * FROM cte inner join
(SELECT Date ROW_NUMBER() FROM CTE GROUP BY Date) dta
...
May 13, 2011 at 9:16 am
dsh_roy (5/13/2011)
col1 and col2 col3 are revenue columns, like net and gross revenues in the dollor amounts.
So this is like a revenue type column?
Make sure you get all the...
May 13, 2011 at 9:15 am
Steve Jones - SSC Editor (5/13/2011)
Hugo Kornelis (5/13/2011)
In the daily newsletter, the question specifies to "select 4". Which is what I did. And then I find that the site thinks...
May 13, 2011 at 9:11 am
My pers preference... adapt to your needs.
Take full backup during off hours. Move copy and restore with norecovery on 2nd server
When you're getting close to the move copy...
May 13, 2011 at 8:49 am
Steve Jones - SSC Editor (5/13/2011)
May 13, 2011 at 8:47 am
Viewing 15 posts - 6,136 through 6,150 (of 18,926 total)