jarick 15608 (1/31/2015)

---

The one I dont get is the use of float in a financial application. I just don't see the reason. Someone help me.

I've seen some big...

Storing currency values in a FLOAT is my least favourite, as I am constantly having to do stupid things like this

WHERE ABS(table1.column1 - table2.column2)<0.01

just to check for equality...

You just need to use a new variable for the second procedure name, like this:

CREATE PROCEDURE [dbo].[runDMQ3_2014LDLComplete]

@QQ_YYYY char(7),

@YYYYQQ char(8)

AS

SET NOCOUNT ON;

select

[provider group]

...

I have to agree with Tom, exchange rates are slippery devils and although it may seem like you want to have a monthly rate now, as soon as someone starts...

You could try using an expression to change the output of the cell when the RenderFormat is excel, to include either a leading apostrophe (single quote) OR an equals sign...

try this, just to see:

SELECT table.column AS [processing-instruction(x)] FOR XML PATH('')

the output of that should be like this - where {your data} is your html string.

<?x {your data}?>

In your report,...

...or you can use the Object Explorer Details view to sort the columns.

Just click on the "Columns" node in Object Explorer, then press F7 to open the details view and...

I don't care either way - intellisense types it for me.

The easiest way (IMO) is to create an empty file with the extension ".udl"

Then double-click the UDL file and it will open a simple connection dialog that you can test...

halifaxdal (1/16/2015)

---

Hello, I have a script to be used to backup a specific table in a weekly basis, here is the approach what I take, if you have a better...

Another free option (I have no affiliation) is Apex SQL Refactor.

http://www.apexsql.com/sql_tools_refactor.aspx

Edit: Actually, now I'm not sure if that would do the full 4PN refactoring..but maybe worth a quick look.

What version of SSRS?

On 2012 there is a Between operator, and (I don't have access to check earlier versions) if that is missing, then two filters, one > = and...

Display the parameter ADAuthorizations on the report and compare dev to live?

it sounds like you just need to allow nulls in the sub_area parameter of the detailed report.

Ok, now that I had a spare 10 minutes, I can see the problem was that you are manipulating multi-line text, and in my test I wasn't.

Handling the line feeds/carriage...