Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 6,676 total)

  • Reply To: Query single column data into three columns

    You are looking at a cross-tab or pivot of the data:

     Select EmpNo
          , Sales = sum(Case When JobNo = 'Sales' Then...

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

    May 5, 2020 at 9:16 pm

    #3749088

  • Reply To: Automating restore of a database that is part of an availability group

    Are you saying your DEV system is setup with an availability group and you need to refresh the DEV database(s) from production on a daily basis?

    I see no reason to...

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

    May 5, 2020 at 4:04 pm

    #3748995

  • Reply To: Convert VBA function to SQL function

    frederico_fonseca wrote:

    OP using SQL 2014 - m0st likely syntax used won't work

    Are you referring to 'Drop Table If Exists'?

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

    May 4, 2020 at 6:34 pm

    #3748757

  • Reply To: SQL login without a user (after a restore)

    How was this system created - is it a new system where you restored the databases from backups?  If so - check the owner of the database and change it...

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

    May 4, 2020 at 6:27 pm

    #3748754

  • Reply To: Convert VBA function to SQL function

    I pulled the list of viet character encodings from http://vietunicode.sourceforge.net/charset/

    Using that list to build the table you can then use that table to convert to/from multiple character encoding.  The function...

    • This reply was modified 6 years, 1 months ago by Jeffrey Williams.
    • This reply was modified 6 years, 1 months ago by Jeffrey Williams. Reason: Updated insert into table to use unicode prefix on the strings to insure correct character representation
    • This reply was modified 6 years, 1 months ago by Jeffrey Williams.

    Attachments:
    You must be logged in to view attached files.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

    May 3, 2020 at 4:27 pm

    #3748461

  • Reply To: Two 'for each file' loops and one data flow task

    I am not sure about the full process you are attempting here - but it looks to me like a situation that might work better as a master package and...

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

    May 1, 2020 at 7:43 pm

    #3748215

  • Reply To: Object naming

    SQL Espo wrote:

    I have a pretty "dumb" question, but I want to get the consensus on this

    I have a table that is going to store Location data (address, geocoding, etc). Location...

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

    April 29, 2020 at 9:55 pm

    #3747498

  • Reply To: SQL Server HA

    Your steps are correct for AlwaysOn - you install stand-alone instances on each server in the cluster and then configure an availability group.

     

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

    April 29, 2020 at 9:40 pm

    #3747492

  • Reply To: SSIS Not writting all records to OLE DB Destination

    I would not use a lookup here - I would load the full file into a staging table.  From there you can perform a merge or upsert (update/insert) from the...

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

    April 29, 2020 at 9:38 pm

    #3747491

    • Viewing 15 posts - 1,846 through 1,860 (of 6,676 total)