obfuscate or encrypt a parameter in SSRS
Aug 21, 2023 · 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 …
convert hh:mm to total decimal hours
Feb 24, 2014 · IS there any way to get total hours from a column with data in the format HH:MM.?
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 Import a Guid from Excel using the import wizard?
May 2, 2013 · It seems that the source query doesn’t support the complex syntax in SQL Server Import and Export Wizard. To work around the issue, I suggest you use SQL Server …
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 …
How to get rid of Warning: Null value is eliminated by an …
Jul 4, 2018 · If you would like to get rid of the warning message, you need to check the number of the subquery records at first, then use IF...ELSE construct to execute the SQL statement for …
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 …
Encrypt Column (Full text Search) - social.msdn.microsoft.com
Nov 17, 2014 · The column XML_DATA is configured with Full Text Search and the datatype is TEXT (Is wrong, i now). In this column information is stored in XML format.