+1

We do it the same way:

1. Take Backup.

2. Archive/Zip it.

3. Copy the compressed zip folder to the server.

4. Unzip it.

5. Restore. :hehe:

Please give us DDL of your tables and some sample data. I couldn't understand your problem by just looking at your query.

For better and quick solutions please check out...

This link might help you:

Creating and Modifying PRIMARY KEY Constraints

From what I understand this might be what you are looking for:

Insert Into tbl_year

Select * From tbl_Jan

Union All

Select * From tbl_Feb

Union All

Select * From tbl_March

Union All

Select * From tbl_April

Union All

Select...

webbies (4/14/2012)

---

Vinu512 is on the right track, and there are ways that you can set up these tables better to resolve your issue, but a better understanding of the scenario...

Seems like ETL to me. The various branches can accumulate the data in XML form or in the form of Excel sheets. This data can then be mailed to the...

Fine, I got the code. Now, please post the correct DDL and some...

capn.hector (4/13/2012)

---

jitendra.padhiyar (4/13/2012)

---

Yes, I am asking question. I have not observe it before but i attended an interview and inverviewer asked me this question " What is update state?"

So i...

Gabe T. (4/13/2012)

---

What does this data represent? Are Categories of items a store carries? Are Subcategories as it sounds, subcategories of Categories?

Vinu512 is on the right track, and there are...

First thing you do while working with tables is to NORMALIZE the data. Check out this link:

Normalization

To Normalize the data in your case, you need to have three different tables:...

Is the package visible when you explore the location(where the package is saved) using Explorer??....If its visible then it should be showing in SSMS as well.

Grass, you need to do a few things right so that we know what the problem is and can head into the right direction.

1. Do what Lynn said in his...

Haven't heard about Update State before. Are you asking about "Update Statistics"???

+1

As the capn says....:-)

Count me in for the record as well 😀