SQL!$@w$0ME (7/22/2015)

---

We need to migrate a SQL 2000 db environment to SQL 2014. As part of the migration there are a lot of DTS packages that needs to be migrated....

Johnny B (7/22/2015)

---

Thanks Alvin,

I've looked at the etiquette page and gather my question is not clear. It's certainly a challenge to articulate. I am looking for documentation telling me which...

santa326 (7/22/2015)

---

Hi Fellow Members.

I want to select all the Rows with Grouping done by PARENTID and Max value in REVNR per GROUP.

I am able to get one MAX row per...

Johnny B (7/21/2015)

---

Hi,

I'm importing a multi tab spreadsheet using Import wizard, which I understand to use the same internals as SSIS. The total number of columns in the spreadsheet will...

Lynn Pettis (7/21/2015)

---

Stephanie Giovannini (7/21/2015)

---

Lynn Pettis (7/21/2015)

---

Stephanie Giovannini (7/21/2015)

---

Sean Lange (7/21/2015)

---

If this is a sql job, which I assume it is, just ask them for any built in function to...

rightontarget (7/21/2015)

---

... Now size shows 82.5G. I backed it up and backup size did not change. It tells me that there is a whole lot of space that needs to...

... Last question now. Which search engine did you use? Google or Bing?

😉

Luis Cazares (7/21/2015)

---

Why is that a problem? Tables are designed...

First, will GSplit correctly combine Excel files?

Using GSplit, if...

I should have said that the ideas I mentioned are not intended to be used by themselves, but can be used to find items that are potential matches. Soundex will...

A couple of things that may help.

First do a Google search for "Fuzzy SQL Match". Some of the results might be helpful.

Second, I've have to do something similar before. I...

What about using a calculated column for the total, instead of using a trigger, if the trigger proves to be performing poorly?

GilaMonster (7/17/2015)

---

And that's about all the patience I have this week for 'tell me how to do my job' type posts. At least today's going to be a short work...

For all years? Average over each year?

Lynn Pettis (7/16/2015)

---

s.raddy.89 (7/16/2015)

---

Hi I have a table like this

NameCostMonthYear

Dgjsdj384738740114

Dgjsdj3084895214

Dgjsdj64376482314

Now I want to calculate the relative average, meaning I go to Jan 2014, take the cost and divide it by...