Forum Replies Created

Viewing 15 posts - 3,571 through 3,585 (of 8,731 total)

  • RE: osql command

    Do you get an error?

    Do you run them one by one? Are they in a batch file?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 8, 2016 at 10:22 am

    #1850588

  • RE: ideas for file import and process

    If these are flat files, you could also create stored procedures using bulk insert.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 8, 2016 at 10:15 am

    #1850584

  • RE: ideas for file import and process

    If names and schedules (possibly format/columns) are different, why don't you create 2 packages with the correspondent schedules?

    For the names, just set the connection string as an Expression and use...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 8, 2016 at 10:14 am

    #1850583

  • RE: osql command

    You need to run it multiple times or if the output is the same, just copy the file.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 8, 2016 at 10:04 am

    #1850578

  • RE: Table Creation - Tool

    SQL!$@w$0ME (1/8/2016)

    Hi Guys,

    What tool should I use to create tables as part of a db design(from logical/conceptual model). I'm new to development/design.

    DB model has been created on Visio 2010.

    Please...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 8, 2016 at 7:35 am

    #1850528

  • RE: Are the posted questions getting worse?

    Ed Wagner (1/8/2016)

    Brandie Tarvin (1/8/2016)

    rodjkidd (1/8/2016)

    Brandie Tarvin (1/8/2016)

    Here's a funny. The notification algorithm sent me an email from askssc.sqlservercentral.com telling me that I'd been mentioned in someone's query. But I...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 8, 2016 at 7:29 am

    #1850521

  • RE: How to insert data in a column in a certain condition

    guy 1966 (1/7/2016)

    I try this :

    UPDATE `categories` SET `parent_id`= 0 [2055] WHERE `sort_order`= 1

    the 2055 is the value to try to applie, but I have error syntax... I use...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 7, 2016 at 1:02 pm

    #1850330

  • RE: Syntax help on UPDATE Please

    Here are 2 options. Analyse them, test them and choose.

    UPDATE t

    SET PROV_NBR = x.PROV_NBR

    FROM PARTB t

    CROSS APPLY ( SELECT TOP (1) p.PROV_NBR

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 7, 2016 at 12:40 pm

    #1850321

  • RE: How to insert data in a column in a certain condition

    guy 1966 (1/7/2016)

    So here I would like to insert a value X in a column that `parent_id` conditionally called in the column which is called` sort_order` the value 1 is...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 7, 2016 at 12:16 pm

    #1850311

  • RE: Semaphore timeout period has expired

    You might have some problems with your network making you lose connectivity with the server or someone (or something) is killing your connection.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 7, 2016 at 9:43 am

    #1850246

  • RE: Dynamic Backup Script

    I agree on staying with tested solutions. However, I just wanted to leave an idea on how it can be done by using a starting date (I chose the first...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 7, 2016 at 8:39 am

    #1850214

  • RE: Are the posted questions getting worse?

    ChrisM@Work (1/7/2016)

    Phantom forum post!

    Go to this thread

    Click on the Quote button

    Scroll down to view earlier posts (click on the [+] icon if necessary)

    I've seen that several times. It happens with...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 7, 2016 at 6:29 am

    #1850164

  • RE: the use of CTEs

    Sergiy (1/6/2016)

    Lynn Pettis (1/6/2016)

    Unfortunately you failed to recreate the function as originally coded. You are relying on the existence of a tally table in the database. The original...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 6, 2016 at 4:29 pm

    #1850074

  • RE: ***SPOILER FREE*** Star Wars: The Force Awakens

    chrisn-585491 (1/6/2016)

    http://www.computerworld.com/article/2915904/it-outsourcing/fury-rises-at-disney-over-use-of-foreign-workers.html

    Unfortunately, they're hiring people from India instead of the southern neighbors. However, I always remember a meme about this: http://i.imgur.com/shDmF0L.jpg

    I hope I don't offend anyone in here.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 6, 2016 at 4:25 pm

    #1850073

  • RE: the use of CTEs

    Sergiy (1/6/2016)

    Luis Cazares (1/6/2016)

    I'll just want some help from those who prefer subqueries over CTEs to transform one of our favorites functions.

    You know, people been splitting delimited lists for many...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 6, 2016 at 4:17 pm

    #1850071

Viewing 15 posts - 3,571 through 3,585 (of 8,731 total)