Create UDF to Pad Ride Side of Number with 0 - Fixed Width Number Disp(blog.sqlauthority.com)

submitted by pinaldavepinaldave(9662) 3 years, 2 months ago

If you prefer you can create UDF for the same. I would encourage my readers to submit the UDF for satisfying following criteria using code provided above. UDF should take a parameter ‘Total Width of Number (in our example it is 7). I will publish the reader who posts first correct answer to this UDF on this blog with due credit.

2 comments |category: |Views: 140

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:

posted by codebettercodebetter(0) 3 years, 2 months ago 0

interesting.

Reply

posted by pinaldavepinaldave(9662) 3 years, 2 months ago 0

I have written follow up post of this article as well : http://blog.sqlauthority.com/2009/03/16/sql-server-udf-pad-ride-side-of-number-with-0-fixed-width-number-display/

Regards,
Pinal Dave

Reply

information Login or create an account to comment on this story