I would suggest do not create a cursor.

And having read some basics about SQL would be quite useful.

There must be Line Feed charachters in one of those strings.

Select LEN(mediacode1) and you'll see the difference.

Select case when dbo.IsInt(ColName) = 1 then CAST(ColName as int) else NULL end, ...

FROM TableName

Where dbo.IsInt(ColName) = 1

You need to build SQL string first:

declare @sql nvarchar (4000)

select @sql = 'SELECT sAMAccountName

        FROM ''LDAP://corp.jpmp.chase.com''

        WHERE objectCategory = ''Person''

  AND objectClass = ''User"''

  AND givenName = '''...

Does the choice of second candidate depend on the personality of the first chosen?

If not, you may choose all in one roll and then work out selected list in a...

SET @@Rowcount = @NumberToSelect

Select IDENTITY(int, 1,1) as RandomID,

PersonId

INTO #Selected

FROM dbo.Candidates

WHERE

ORDER BY NEWID()

SET @@Rowcount = 0

Than you can join #Selected to original table by Person ID and do whatever you...

Use round ((value/60.0)+0.5, 0)

or even better CEILING(value/60.0)

SELECT T1.*

FROM <Table> T1

INNER JOIN (select productID, groupID, MAX(version) -- whatever method you use to identify the latest version

from <Table>

group by productID, groupID) T2 ON T1.productID =...

So, add WHERE eh_order_sent = 0 at the end of UPDATE statement.

If you test both approaches for performance you'll find out that yours is slower.

Relational databased are really bad on altering tables.

The problem is you expect no failed updates and you have not decided what to do when it's happened.

Now you just repeating failing update again and again. Not the smartest...

DELETE C

FROM CxCHon C

INNER JOIN Historic H ON H.Terc = C.Terc AND H.Val = C.Val

SELECT Class,

Sum(Volume) as 'Monthly Volume',

Sum(case when Datepart(dw,vDate) NOT IN (1,7) then Volume else NULL end) as 'Business Volume' ,

Average(Volume) as 'Average',

MAX( vDate) vDate, 

Max(Volume) Volume

from #tblTemp

group by class

INSERT INTO #Table EXEC SPName @var1, @Var2

Select @var1 as Var1, @Var2 as Var2, *

INTO #Table2

FROM #Table

Did you delete aliases?

What you need to do is to replace "Table" with real table name. Don't change anything else.