obfuscate or encrypt a parameter in SSRS
Sep 10, 2014 · I just want to be able to get the value of parameter (string), add some characters in it and then in my SQL convert it back to original string. For example "HELLO" => "@ …
Insert SQL Stmt with datetime conversion
Jun 13, 2009 · The best solution to this problem is to store the data as a datetime or smalldatetime; however, the next best solution is to convert the character value, using the …
converting a date to char (8) value then compare them as dates
Jul 1, 2010 · So my question is that i have a column on a table that is declared as a char (8) but my boss wants me to change the parameters to convert them to the same format so there isn't …
how to convert currency from US to CAD
Jul 29, 2011 · By using this code i am able to convert latest cur to cad, If i have to covert all the currencies value from last two year then what i have to do.
Variable Exists check - social.msdn.microsoft.com
May 28, 2016 · I have sql code I execute either as a block or interactively. I intersperse the code with messages and timer outputs that depend on variables. So like following: Declare …
Derived Column expression to convert string to datetime
Sep 22, 2009 · I'm trying to convert two strings (which are actually numbers) to a datetime in a Derived Column task.
how to convert from decimal to timestamp
Sep 5, 2009 · OLEDB source is : select id from tablename Take a Data conversion to convert id (decimal) to DT_STR. and give the output alias as id2 Take a derived column and give the …
Conversion failed when converting datetime from character string.
May 6, 2011 · finish date with current datetime using SQL Query select * from Conusermanager where CONVERT (datetime,finishDate,103) > getdate () Msg 241, Level 16, State 1, Line …
The replace function requires 3 argument (s).
Dec 21, 2012 · Select (Case isnull (SiteLimbPatient,'') when ',0,' then '' else REPLACE (REPLACE (substring (SiteLimbPatient,2,len (SiteLimbPatient)-1),'',CONVERT (VARCHAR …
Can I get a formatted SQL Server Date to sort correctly???
Oct 2, 2013 · Why are you writing 1960's Cobol in T-SQL? SQL has temporal data types. You do not turn the date into a string literal and then wonder why it sorts like a string? In fact, the …