Forum Replies Created

Viewing 15 posts - 721 through 735 (of 761 total)

  • RE: Copy a database, then test its restore...

    +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:

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 14, 2012 at 4:17 am

    #1473627

  • RE: columns in sql select statements affecting the number of rows

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 14, 2012 at 3:58 am

    #1473624

  • RE: Primary with Null value

    This link might help you:

    Creating and Modifying PRIMARY KEY Constraints

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 14, 2012 at 3:52 am

    #1473623

  • RE: Appending

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 14, 2012 at 3:46 am

    #1473620

  • RE: Looking for some help with constraints

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 14, 2012 at 3:35 am

    #1473617

  • RE: DATABASES

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 13, 2012 at 11:45 pm

    #1473605

  • RE: Need Help with the Error 'Subquery returned more than 1 value'.

    Grass (4/13/2012)

    The code I posted in my first post is in SQL Exexute Task from a SSIS package.

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

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 13, 2012 at 10:44 pm

    #1473604

  • RE: Update State

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 13, 2012 at 10:20 pm

    #1473603

  • RE: Looking for some help with constraints

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 13, 2012 at 10:16 pm

    #1473602

  • RE: Looking for some help with constraints

    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:...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 13, 2012 at 6:55 am

    #1473203

  • RE: I want to run a batch file from query window or from Trigger.

    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.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 13, 2012 at 2:38 am

    #1473092

  • RE: Need Help with the Error 'Subquery returned more than 1 value'.

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 13, 2012 at 2:34 am

    #1473089

  • RE: Update State

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

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 12, 2012 at 11:05 pm

    #1473024

  • RE: fetching date from 1 sp to another

    +1

    As the capn says....:-)

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 12, 2012 at 10:56 pm

    #1473023

  • RE: select statement

    Count me in for the record as well 😀

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 12, 2012 at 10:50 pm

    #1473022

Viewing 15 posts - 721 through 735 (of 761 total)