dndaughtery (9/8/2011)

---

I have a pkg where I want to call it and set the value of its global ssis variables with values passed in as parameters from the call. How...

chris.stuart (9/8/2011)

---

Hi All

I'm having a problem with regional settings in SSMS. I'm creating reports in SSMS which pulls the data from my server. On my PC the settings are set...

Rem70Rem (9/7/2011)

---

When I remove the primary key on my destination table, the execution time is decent. I need to have this for performance issue. This is my fact...

Interesting question, and BOL politely avoids being specific (http://msdn.microsoft.com/en-us/library/ms179917.aspx)

I guess you will have to assume that in the case where the IsTransferASCII property is set to false, no...

The short answer to your question is yes...there are a few alternatives. If you are...

thang_ngo_2002 (9/3/2011)

---

I have an alert system based on SQL Server

When I use SQL 2000, I monitor an Oracle system by SQL DTS, DTS contains 1 transform "select 1 from dual"...

You can choose to ignore all truncation errors (in the error output), but you would still have to do this for all source columns and IMO it is a very...

GSquared (9/2/2011)

---

It's adding a number of weeks (ColC) to ColA, until ColA is caught up with the current date.

So, if ColA started out as a year ago, and ColC =...

On face-value, it seems like the while-loop will only be executed once...unless there is something else that happens between the update (maybe triggers) and the select inside the loop.

Not sure...

If-statements in queries could cause some sub-optimal execution plans. See the following for reference: http://sqlinthewild.co.za/index.php/2010/12/14/do-if-statements-cause-recompiles/

My suggestion would be to have separate procs if the queries are that different and it...

You are very welcome 🙂

sql4us (9/1/2011)

---

Thank you so much...Now it makes sense. I have one more question

I want to include all column names to display

For ex:

Zipcode West East North South maxvalue Colname

00001 ...

Almost there 🙂

Two things to consider:

1. Your order by clause should only include the maxvalue column and not the zip code.

2. Encapsulate your whole query in a cte, and then...

sql4us (9/1/2011)

---

I have 30,000 records..I almost got it but if you saw my code and results it shows all the values for the same zipcode. I just need max value,...

If you have a limited number of columns, you could use a case statement. Alternatively, try using a cte to "normalize" the data before aggregating.