This is totally off topic but man I really hate contract developers sometimes. We had this guy in our shop for about three months helping relieve some of the pressure...

Does anyone know how to disable the intellisense in sql prompt? I only want to do this temporarily. I have a very long list of parameters and I need to...

I just nearly spit out my coffee laughing. I was looking at a table built by some consultants for a project a few years ago. This is a product table...

Holy cow Luis. I was not at all understanding what they were looking for. I was not even on the same planet as your post. That is pretty awesome my...

For starters lets format this function so we can read it.

CREATE FUNCTION dbo.ufnConvertToFraction
(
    @NumbertoConvert FLOAT
)
RETURNS VARCHAR(20) AS

BEGIN

DECLARE
    @output VARCHAR(20)
    ,...

spam reported

You are asking us to help with performance but we have no idea what your table structures and indexing is for any of this....although "There are multiple heap tables in...