Viewing 15 posts - 2,071 through 2,085 (of 11,678 total)
Indu-649576 (8/14/2014)
Hi,Is there any other way to assign row number to the result set with out using Row_Number/rank/Dense rank functions or loops?
Thanks,
Indu
While we are making things more complicated, you could...
August 14, 2014 at 3:44 am
Gary Varga (8/14/2014)
I am out today but will donate. Surely the big question is whether you will be sporting a matching Hawaiian shirt???
I see what you did there 😉 😀
August 14, 2014 at 2:19 am
Phil Parkin (8/14/2014)
I can't see a way of querying SSISDB directly to get this data. Which makes me wonder where SQL Server has put it!
I asked Matt Masson about this...
August 14, 2014 at 2:02 am
CASEWHEN [Post Cost] IS NULL OR [Pre Cost] IS NULL
THEN 1
WHEN [Pre Cost] = 0 -- avoid divide by zero error
THEN 0
ELSE [Post Cost] / [Pre Cost]
END
August 14, 2014 at 1:54 am
At second sight another CASE is not needed necessarily, just another WHEN will suffice.
,CASEWHEN CAST(CAST(ROUND(((T0.LineTotal - T0.StockValue) / NULLIF(T0.StockValue, 0)) * 100, 2) AS DECIMAL(10,2)) AS VARCHAR(30)) = '0.00'
THEN 'N/A'
WHEN...
August 14, 2014 at 12:58 am
Which deployment model? How do you deploy?
August 14, 2014 at 12:46 am
The commented line should be preceded with a new CASE.
If you would have posted your code as regular text instead of a screenshot, I could have modified it 😉
August 14, 2014 at 12:43 am
GilaMonster (8/13/2014)
And the profound post of the day award goes to:In such critical situation you must go with reliable and effortless recover tool.
That's the entire post.
In such critical situation you...
August 13, 2014 at 6:08 am
Method 1 seems more easy to set-up than method 2.
Is it a big data load?
August 13, 2014 at 12:56 am
sqlfriends (8/12/2014)
Anyone else...
August 13, 2014 at 12:53 am
The SSISDB is the database that contains all the objects for the SSIS catalog. So yes, it is perfectly normal that this database is created.
I am not sure how this...
August 13, 2014 at 12:45 am
Great question, and a fine example of why sp_rename should be avoided.
August 13, 2014 at 12:38 am
ps_vbdev (8/12/2014)
August 12, 2014 at 7:00 am
GilaMonster (8/12/2014)
How...
August 12, 2014 at 2:52 am
Viewing 15 posts - 2,071 through 2,085 (of 11,678 total)