this might be outside the scope of your question, but what does Bondcli do? can the trigger be written into a CLR instead? i ask because the trigger is likely...

you do know that @name and @age are going to be the values from the insert?

i didn't see any error message...

the problem you're running into is that depending on a condition, you want to either select from a list of values or from one value. the easy way to fix...

see 3 posts above:

if @product_name = 'all'

select * from product where product_name in (select 'a' union select 'b'...)

else

select * from product where product_name =...

when you're done, all the code that was in your report (all the DECLAREs, SELECTs, etc) should be in a proc. then, the report should contain only one line: NameOfYourStoredProcedure....

if... then is vb. the sql syntax is:

if condition

statement

else

statement

begin... end is only required when more than one statement is executed in a particular branch....

you'll probably have to do something like:

if @product_name = 'all'

select * from product where product_name in (select 'a' union select 'b'...)

else

select * from product...

SELECT * FROM employee

WHERE FIELD1 = CASE @employee

WHEN 'Value1' THEN 'Something'

WHEN 'Value2' THEN 'Something Else'

ELSE 'Something more'

END

i play classical/flamenco guitar, piano, pretty much any percussion and i'm teaching myself violin. i figure i think in yes/no, on/off, black/white terms all day long, it all balances out.

but...

SSRS tries to build/use metadata from the query you type in, and it has problems with variables (because it thinks you're trying to pass them as parameters?). i have a...

try using aliases in your FROM clause:

From BACKUPSQLSRV3.tradecs.dbo.profile A1

inner join BACKUPSQLSRV3.trading.dbo.account A2

on A1.acct = A2.acct

this is assuming you...

perfect, that's what i needed to know. i didn't think it was, but it's always nice to get a second opinion.

thanks...

just before you do the update, issue:

select * from STAGE..tbComm_3Months_Ago where Missed_Instalment <0.3333

a better question is... you're updating ALL records where missed_instalment is not NULL, so what exactly are you...

maybe i'm not understanding what you're after, but if you reeport the file and wrap the 25th column with quotes, you won't have to write a script to parse...