You may have duplicates in your SELECT statement. Adding a DISTINCT clause may resolve this.

Drew

SSSolice (10/11/2010)

---

Thanks for your reply Drew. I did remove the redundant call to tblControlLog but the performance against the presentation data is still too sluggish. Any help with a new...

SSSolice (10/11/2010)

---

I use the following to build a csv column from table "A" (one) and table "B" (to many). It works fine but is very slow exspecially when building multiple...

I put the UNION within a CTE and then used SELECT @var = expression instead of SET, because it appears that you can't use a CTE with SET.

DECLARE @CurrencyRateHistoric...

It would help if you had posted the code where you tried to assign the variable and the error that you received. It also helps if you post DDL...

You're trying to insert new rows when you should be updating existing rows.

UPDATE A

SET B = B + ' Large', C = C + ' Large'

WHERE A LIKE '%LG'

I assume...

Assuming that your dispLookup table changes relatively infrequently, it might be best to create a trigger on dispLookup to dynamically create/alter a view with the user-friendly column names. This...

You can save a grid as CSV or you can select the entire grid and paste it into Excel. There is a setting in options that will copy the...

I agree with Bhuvnesh that your join on B3 and B2 is probably what is causing the problem. (Of course this would be easier to test with sample data.)...

It's better to use

update...

Jeff Moden (9/30/2010)

---

Exactly. Do the same thing with a variable and it changes the Simple to a Searched CASE in the scalar operator. I haven't tested it but...

The foreign key should be referencing Status, not StatusReason.

Drew

Your FOREIGN KEY is referencing a table called Table2. You probably need to change it to reference the Status table.

Drew

A FOREIGN KEY constraint specifies that the value(s) for some column(s) must uniquely identify one row in the referenced table. You have a foreign key constraint "IUser1" on your...

Actually, if you remove the comma, you can remove the STUFF...