Forum Replies Created

Viewing 15 posts - 391 through 405 (of 543 total)

  • RE: load data into 3 separate tables using tsql .

    Thom A - Wednesday, November 8, 2017 12:24 PM

    You mention, in your post the "first" record/row. How do we determine row "1"...

    November 8, 2017 at 12:52 pm

    #1967241

  • RE: Encrypt a column in sql server?

    Hi Jeff.

    Thanks for valuable suggestions. This is just a POC kind of thing try on my local machine. This is not a prod implementation. Kind of learning...

    November 5, 2017 at 10:54 am

    #1966706

  • RE: Encrypt a column in sql server?

    So, in general how are we going to share the key? Is that by taking a backup and providing them the password to other person to decrypt??

    November 5, 2017 at 5:47 am

    #1966695

  • RE: Encrypt a column in sql server?

    Hi Thom,
    Thank you for the example. Now, assume that the data is encrypted, suppose If someone has to decrypt the data, what is that he needs to have??...

    November 5, 2017 at 4:20 am

    #1966692

  • RE: Encrypt a column in sql server?

    Sorry my bad. I want to encrypt and not masking the data. Editing the original post with correct expected output.

    November 5, 2017 at 12:53 am

    #1966683

  • RE: Compare 2 rows using tsql code

    below86 - Thursday, October 26, 2017 8:26 AM

    Here is what I set up as data:
    CREATE TABLE dbo.source_table
    (
        RecordId                        INT IDENTITY(1, 1),
        First_Name                        CHAR(50),
        Last_Name                        CHAR(50),
        Date_Of_Birth                    DATE,
        Age                                INT,
        Process_Date                    DATETIME,
        Yearly_Salary                    DECIMAL(13, 2)
    )
    ;

    INSERT...

    October 26, 2017 at 12:22 pm

    #1965369

  • RE: Compare 2 rows using tsql code

    Hi below86,

    Thanks for reply. But quite frankly I wasn't able to understand. Can you please demonstrate with an example?
    When I try to execute the code I get...

    October 25, 2017 at 11:40 pm

    #1965272

  • RE: Compare 2 rows using tsql code

    sgmunson - Wednesday, October 25, 2017 10:40 AM

    You're probably looking for the following:CREATE TABLE #test (
        c1 int,
        c2 char(10),
        c3 varchar(100),
        c4 float
    );
    INSERT INTO #test...

    October 25, 2017 at 11:17 am

    #1965194

  • RE: Compare 2 rows using tsql code

    John Mitchell-245523 - Wednesday, October 25, 2017 7:09 AM

    Sam

    So you're taking the whole set and comparing the value of each column in...

    October 25, 2017 at 11:14 am

    #1965191

  • RE: Compare 2 rows using tsql code

    John Mitchell-245523 - Wednesday, October 25, 2017 5:20 AM

    What results were you expecting?  Since no matter how you slice it, you have...

    October 25, 2017 at 5:59 am

    #1965099

  • RE: Compare 2 rows using tsql code

    TheCTEGuy - Saturday, September 30, 2017 5:54 AM

    Thom A - Monday, September 18, 2017 3:42 AM

    October 25, 2017 at 4:42 am

    #1965084

  • RE: Tsql help - usage of aggregate functions

    Thanks "Thom A" for the step - by - step approach of the problem. Didn't get what sgmunson was saying. But now I understood what you and he meant. Thanks...

    October 20, 2017 at 9:16 am

    #1964512

  • RE: How to get columns which has null's

    Thanks a lot a below86 for taking time. Will try it on my own and see how it works.  Many thanks.

    October 20, 2017 at 6:51 am

    #1964476

  • RE: How to get columns which has null's

    Thanks below86 for the correction. Can we make this dynamic script ? Should be able to pass on any number of tables but number of columns will be the same....

    October 18, 2017 at 12:14 pm

    #1964262

  • RE: How to get columns which has null's

    Hi Mike/CTEGuy,

    Assuming  the temp tables as  permanent  tables (i.e. t1, t2 , t3 ), how can we make the script as dynamic. I want to reuse the...

    October 18, 2017 at 4:12 am

    #1964170

Viewing 15 posts - 391 through 405 (of 543 total)