eobiki10 (12/10/2013)

---

There's actually no problem with the code for single value. I want to know how to tweak the code to work for multi-select so users can choose all offices....

eobiki10 (12/10/2013)

---

This is exactly my problem and my sql. The report has cascading parameters and it works well for a single value. I tried to make it work for multi-...

You realize that violates 1NF right? A column of data in a row of a table should hold 1 and only...

Hi and welcome to the forums. It is nearly impossible to tell you how to fix this. It is however fairly easy to tell you the problem. Your subquery is...

pgupta6644 (12/10/2013)

---

The following query I want to genrate dynamically:

select @mesg_string = 'Error : ' + @mesg_out

where @chk_dt <= @org_dt

becuase the where conditions will be changing and messing will different...

As a general rule you should NOT design your tables based on how you expect to query the tables. You should design your tables to support the data. Then you...

Why do you need to use dynamic sql for this? I don't see anything in what you posted that would indicate you need to use dynamic sql.

The reason you are...

I am pretty sure...

That depends. Do you really want a comma delimited list in a single column or do you want...

So what is the EXACT query you are trying and what is the error message? This is probably incredibly simple to fix but...

So are you good to go then...

eobiki10 (12/10/2013)

---

Hi All,

Please I need help with this. I am having an error when I try to run a report that contains this code. The error is this "the Select...

Congrats Gail. I think the creep of the Thread may have reached unstoppable speed at this point. 😛

In MySQL a foreign key can reference columns which don't have a uniqueness constraint on them, which is an excellent feature that more DBMSs really ought to support. There's no...

Technically speaking your Row_Number is in fact ordering, it is just ordering by the constant value of the parameter. 😉

Be very very careful with what you are doing here. So...