Forum Replies Created

Viewing 15 posts - 1,201 through 1,215 (of 3,061 total)

  • RE: How to define Relationship between 3 tables of unique records

    ironoverload (2/2/2011)

    My Scenario is this:-

    4 Tables t1-t4, t1-t3 each have unique records that when entered into 3 fields in t4 produce a combined unique record.

    t1

    Field1(PK)

    t2

    Field1(PK)

    t3

    Field1(PK)

    t4

    t4.Field1=t1.Field1

    t4.Field2=t2.Field1

    t4.Field3=t3.Field1

    The result of...

    February 4, 2011 at 8:07 am

    #1282490

  • RE: Select Records between time stamps

    yasirbc (2/3/2011)

    I just figured it out, I had to use this format

    (TimeStamp >='2011-01-03 010:00:00' AND TimeStamp <='2011-01-03 012:00:00')

    I do prefer the "between" notation but that's just me 🙂

    February 3, 2011 at 12:50 pm

    #1282110

  • RE: Help with the sql

    varunkum (2/2/2011)

    Thank you now i understand. My code is actually right.

    Indeed but, report may be showing there is a procedural issue in some place in the organization - business has...

    February 3, 2011 at 12:46 pm

    #1282106

  • RE: Replication error: "field size too large"

    Roust_m (2/1/2011)

    I've got two databases on the same server and replicate some tables from one database to another.

    The replication is configured so not to drop the table if it exists,...

    February 1, 2011 at 9:30 pm

    #1281234

  • RE: DB and Translog Backups

    odeonkreel (2/1/2011)

    I run a Full backup on all databases on my SQL 2008 Server. I do this once a week.

    My question is, should I be backing up the TransLogs too?

    It...

    February 1, 2011 at 4:02 pm

    #1281180

  • RE: database design for social networking site

    shitaljagtap610 (1/30/2011)

    thanks for suggesting for ER-DIAGRAM.but i already have drawn it..in my system i am going to store videos,photos,documents such as pdf,xls,doc,ppt ,profile info, friends,all that are used for social...

    January 31, 2011 at 9:52 am

    #1280490

  • RE: Enterprise or Standard Edition?

    jared-709193 (1/29/2011)

    I was under the impression that Standard Edition is "departmental" which meant to me that 1 or 2 applications is what it is built for. I assumed that...

    January 29, 2011 at 8:40 pm

    #1280153

  • RE: Creating a table in a single file

    prassu.ibm (1/29/2011)

    Creating a table in a single file

    define "file"...

    ...is it the file where you store your ddl script?

    ...is it file as in filegroup?

    ...etc, etc, etc...

    ...what is it?

    January 29, 2011 at 4:44 pm

    #1280146

  • RE: Enterprise or Standard Edition?

    jared-709193 (1/28/2011)

    I know for many it is easy to make this decision based on the features. However, we do not need most of the features (data driven subscriptions being...

    January 29, 2011 at 4:41 pm

    #1280145

  • RE: database design for social networking site

    shitaljagtap610 (1/28/2011)

    hello to everyone, i want to design database for a small social networking site which i am developing in ASP.NET and C#.please help me for designing the structure of...

    January 29, 2011 at 3:07 pm

    #1280137

  • RE: "ORA-00936: missing expression" w/64bit R2 & OraOLEDB.Oracle provider

    knight.randy (1/27/2011)

    Try wrapping your Oracle statement in BEGIN END. This will pass it off to the PL/SQL parser. I have had success doing this with a variety of...

    January 28, 2011 at 8:48 am

    #1279740

  • RE: Multiple GetDate()

    I'll run a single select getdate() populating a local variable then use that local variable during insert. Less overhead and you will ensure value is the same in all affected...

    January 26, 2011 at 1:56 pm

    #1278777

  • RE: How to test a Backup without an extra server?

    tomiboy59 (1/26/2011)

    ... I think testing backups is something good to (do) from time to time anyway.

    ... and you are absolutely correct.

    How to do it? Follow Lowell's guidelines then open "sandbox"...

    January 26, 2011 at 1:53 pm

    #1278773

  • RE: How do I update an Oracle table using SSIS from a flat file source

    Resender (1/26/2011)

    Nevermind found the solution

    Good for you! would you mind in sharing? other people may benefit from it 🙂

    January 26, 2011 at 8:56 am

    #1278534

  • RE: creating fact table and surrogate keys

    veena.jokhakar (1/18/2011)

    Problem 1:

    I have a database that contains industrial data. Now there are 2 tables

    1st: Aim_chemistry : that contains act amount of elements that should be used like...

    January 25, 2011 at 11:18 am

    #1278037

Viewing 15 posts - 1,201 through 1,215 (of 3,061 total)