Split is used to break a delimited string into multiple rows. The below user defined function udf_Split accepts 2 parameters Input the string that you want to split into multiple rows. Delimiter the delimiter based on which the seperation will be performed.
PadLeft accepts 3 parameters and returns a string that right aligns the characters. Value: an integer number PadChar: the character that will be used for the padding Length: the length of the output
There are two ways to remove the time from the datetime datatype. The first method is using the dateadd and datediff system functions and the second method is to convert from datetime to characters. --First Method SELECT DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0) --Second Method SELECT CONVERT(CHAR(11), GETDATE(), 113) The second method converting the [...]