Your @Names variable is null which means joining this into your dynamic query will make the whole statement NULL.

You also do not have a space in this part @columnname +...

From my understanding the percentage format will automatically add in a *100 to the data.

Check to see if you are doing this in your expression or code and if so...

Hi,

You cant reference a column alias in the same select statement it was created.

You will either need to do Column1*10*column2 as Column6

or wrap it in a cte first

with cte as...

Soemthing like this maybe ?

DECLARE @choice int;

SET @choice = 0;

if exists (select 1 from yourtable)

set @choice = 1;

I think this is what you are after.

with cte as (

select

o.custid, od.orderid as IorderID, sum(amt * itemcnt) as tot,

ROW_NUMBER() over (PARTITION by o.custid order by sum(amt * itemcnt) desc) as...

Why not use something thats already around ?

Ive used the scripts from Ola Hallengren with great success in the past.

Something like this ?

select distinct

itemno as [Item],

count(*) over (partition by ITEMNO) as [Purchases],

sum(case when entrytype = 0 then qty else 0 end) over (partition by ITEMNO) as [QtyPurchased],

sum(case when...

Potentially can just do a cross join like the below.

create table #test (PO int, DaysToTravel int, DaysInWarehouse int)

insert into #test VALUES

(1, 10, 20),

(2, 5, 30),

(3, 7, 40)

select b.PO, b.DaysToTravel, b.DaysInWarehouse,...

Why dont you add the column(s) in the key lookup to your index as included columns ?

This will most likely still allow an index seek and remove the key lookup...

Try this.

select top 1 PRICE

from table1

order by price desc

Really not sure if this is what you are after. (No sample results so i cant be sure)

;with cte2 as

(

select

[Invoice],

[D_Type],

[Status],

left(datename(month, [RemediationDate]), 3) as Mo,

year([RemediationDate]) as Yr

From

#Remediation

),

cte3 as...

You have a typo

@Poll_I int

Im pretty sure this should be @Poll_ID

Thanks - this is a lot nicer than what i had.

Are you trying to compare an actual date or just a time ?

Can you put together some sample data ?

There really isnt much information to go on here.

If you can post the ACTUAL execution plans and the definitions for both views that would be a start.