Viewing 15 posts - 1 through 15 (of 32 total)
June 14, 2017 at 8:38 am
J Livingston SQL - Monday, June 12, 2017 11:17 AM
I apologize J for not giving that information. I have updated...
June 12, 2017 at 11:40 am
SELECT ... NULL AS ColumnName
FROM MyTableMay 12, 2017 at 2:57 pm
I have fixed my date and number errors by casting them to the correct data types. I am still having a problem setting the other columns to null though.
May 12, 2017 at 12:48 pm
May 12, 2017 at 8:24 am
Is the best option to just insert nulls like what is suggested here?
May 11, 2017 at 3:49 pm
In this case it is a straight update-insert situation. I was hoping there might have been an item in the SSIS toolbox in Visual Studio that would help with that.
April 15, 2016 at 10:55 am
Thank you for the replies. Would it be recommended to use decimal over numeric because it is a wider held standard?
March 16, 2016 at 7:07 pm
Alexander, thank you for reading through my rambling. Your solution was exactly what I needed. Still being new to SQL I think I sometimes miss the obvious solutions.
February 1, 2016 at 2:01 pm
I'm still interested in what question this calculation is answering; my curiosity (read: paranoia) wants to make sure this is the right calculation for the question.
Cheers!
Percentage Increase and Decrease
January 27, 2016 at 12:29 pm
Jacob Wilkins (1/27/2016)
bsmith 63193 (1/27/2016)
Jacob Wilkins (1/27/2016)
January 27, 2016 at 12:13 pm
Jacob, you beat me in fixing my correction. I am now getting the same result as you with the -0.006431... When I type 419-1174/1174*100 into a calculator I get the...
January 27, 2016 at 12:11 pm
Jacob Wilkins (1/27/2016)
January 27, 2016 at 11:58 am
Has anyone used Veeam Backup for SQL?
January 20, 2016 at 7:59 am
What about specifying a specific value for a column in all rows?
October 7, 2015 at 2:21 pm
Viewing 15 posts - 1 through 15 (of 32 total)