COUNT Function

Relevant answer

Manuel Bolaño Galindo 1 year ago

Yo lo haría de la siguiente manera

Declare @query VARCHAR(MAX), @b VARCHAR (MAX) ,@cantidad Int

Set @b=‘Articulos’ Set @query=‘SELECT’+@cantidad+’=count(*) from’+b+’where costo>=1000’

Exec(@query)

If (@cantidad>10) begin SELECT ‘si jalo’ as funciona End

4 Likes

Relevant answer

Jeff Blakley 1 year ago

Instead of -8 for the height, try -7. The height is not an offset from the referenced cell after applying the row/column offset arguments (whatever cell is referenced after apply row/column offset gets included in the range that results from applying height/width).

0 Likes

Relevant answer

Mike Geering 1 year ago

Reviewing your rules and applying your original formula if someone gets FIVE 1s and ONE 6, they score a DISTINCTION, however should they get ONE 7, in place of the 6, they would receive a REFERRED. Is this correct?

0 Likes

Hot network questions