Forum Replies Created

Viewing 15 posts - 646 through 660 (of 761 total)

  • RE: Snowflake Database design - Advice needed.

    flebber.crue (4/24/2012)

    My tables that I have setup are already very close to the layout you have described.

    Importantly the intersection table looks like it would resolve a lot of 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 24, 2012 at 9:52 pm

    #1478675

  • RE: Filtering rows from one table.

    Can you replace the "SomeText" in the tables with the actual text.....so that we get to have a look at what you are actually looking at.

    This would help us provide...

    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 24, 2012 at 6:53 am

    #1478094

  • RE: How to Merge two rows into one?

    shani19831 (4/24/2012)

    Sorry Guys i got it right

    Here is the query

    selectorig_branch_no,

    acct_no,

    amt,

    description,

    create_dt,

    charge_code,

    tran_code, (select t2.tran_code from history as t2

    where t2.tran_code in (157)

    and t2.description like '%DDAC%'

    and t2.create_dt = '20110802'

    and t2.acct_no = t1.acct_no) as 'Charge...

    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 24, 2012 at 6:28 am

    #1478070

  • RE: Filtering rows from one table.

    What is 'SomeText'?....Is it literally the String 'Sometext' or is it just a hypothetical representation of "some text that you have in your 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 24, 2012 at 6:23 am

    #1478067

  • RE: create defferent table for login

    david.alcock (4/24/2012)

    Is it OK practice to store user details in a database table, only asking as I strictly use sql logins or windows auth?

    I assume that you are talking about...

    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 24, 2012 at 6:06 am

    #1478056

  • RE: create defferent table for login

    vahid.arr (4/24/2012)

    vinu512 (4/24/2012)

    One table for User Details is fine. You just need to check if the data that the table houses is in Normalized Form.

    From what I understand you should...

    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 24, 2012 at 6:03 am

    #1478055

  • RE: create defferent table for login

    These might help you to learn Encryption:

    SQL Server Encryption

    SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script[/url]

    You could even do it from the client...

    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 24, 2012 at 4:26 am

    #1478009

  • RE: txt import

    andersg98 (4/20/2012)

    This is a job for SSIS.

    +1 seems like pure ETL. DTS Wizard would do this for you.

    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 24, 2012 at 4:21 am

    #1478007

  • RE: Snowflake Database design - Advice needed.

    When I start designing a database I divide everything in terms of entities.

    And then start designing master tables for every uniquely identifiable group of identities.

    Then I create other tables and...

    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 24, 2012 at 4:16 am

    #1478003

  • RE: Disk space when varchar to nvarchar change

    lol....that's a really good way of doing it.

    Nice 1 Eugine.

    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 24, 2012 at 3:44 am

    #1477992

  • RE: Handling Multiple transaction

    Please post DDL of the tables and some readily consumable Sample Data.

    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 24, 2012 at 3:38 am

    #1477990

  • RE: Disk space when varchar to nvarchar change

    I don't have a query for this but in normal circumstances nvarchar takes double the size as varchar.

    Storage Size

    Varchar - Actual Length (in bytes)

    NVarchar - 2 times Actual Length...

    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 24, 2012 at 3:19 am

    #1477986

  • RE: Need to gather the source process for a SQL server query

    Wouldn't a trace to check which query is doing what on which table help?

    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 24, 2012 at 3:04 am

    #1477978

  • RE: create defferent table for login

    One table for User Details is fine. You just need to check if the data that the table houses is in Normalized Form.

    From what I understand you should have another...

    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 24, 2012 at 2:58 am

    #1477975

  • RE: Column = anything

    Yea. the OP is not elaborate enough for us to know what the requirement actually is

    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 24, 2012 at 2:43 am

    #1477970

Viewing 15 posts - 646 through 660 (of 761 total)