This looks like you are trying to do an UPDATE. If so, then

UPDATE  YourTable
SET     columnB = CASE
   ...

Remove this part

PARTITION BY WhatWeight

I have not checked this against your spreadseet

WITH cteBase AS (
    SELECT  whb.ID, whb.grower, whb.block, whb.section, whb.year, whb.weight, whb.payclass
    ...

hi

here i am again with a noob question again:

i'm trying to do this:

case 
when columnA <> 0 
then columnB = 1 
else columnB
end

but it return error.

i used...

Use coalesce to replace the null value

set @log =   @Log + '  ,Date: ' + coalesce(@Date, 'NULL')

You can create an iTVF that will generate numbers on the fly

CREATE FUNCTION [dbo].[fn_GetNums](
    @low  AS BIGINT
  , @high AS BIGINT
)
RETURNS TABLE...

You could use a dynamic cross-tab query.  Take a look at the following 2 articles by Jeff Moden

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Cross...

You want to use SUM and not COUNT

Select distinct Model_id,
SUM(CASE WHEN Doors = 4 then 1 ELSE 0 END) [4DoorCount],
SUM(CASE WHEN Doors = 2 then 1 ELSE...

You either have to add a filter into your stored procedure, or store the results of your stored procedure in a table, and then re-query that table.

EXEC dbo.LogTable @Inserted,@Updated is outside of the catch block, so it will run after the rollback.

Also, @Inserted and @Updated are variables, which do not revert their value on rollback.  You...

Add the following to your WHERE clause

AND name LIKE 'DBA%'

If newtable exists ...

;with cte as
(
  select col1, col2, ...
  from ...
)

insert into newtable (col1, col2, ...)
select col1, col2, ...
from cte

If newtable does not exist

You've discovered the hard way why it's not a good idea to store dates in a char column.  That's not a criticism of you - I'm sure it's not...

It seems that if you simply add a '0' to the end of your string, it converts correctly

DECLARE @charDateTime char(22) = '2012-06-03 04:11:49:16';

SELECT CONVERT(datetime, @charDateTime+'0', 121)

If you change %3.00 to %3 then you will also remove the floating point issue.