Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 5,685 total)

  • RE: T-SQL Help Needed

    SomewhereSomehow (9/20/2012)


    Ha-ha-ha! I think you are joking about beating =)

    He's not, but we're talking a mideival training method.

    In Russia we have a proverb: "Every joke has a little bit of...

  • RE: generate multiple data flow tasks

    sqlfriends (9/20/2012)


    The reason I ask is I saw actually we have a ETL that seems generated somehow.

    In it there are about 30 data flows, from the format they look so...

  • RE: Number of natural\business keys in dimension tables

    Daniel Hallam (9/19/2012)


    Should the dimension have an excessive number of business keys if the source data warrants it?

    I would say more if the questions the users were asking of the...

  • RE: Help writing SQL Server development guide!

    I'm going to nitpick a bit about a few items here the others didn't mention (yet), as they concentrated on the huge issues.

    PiMané (9/20/2012)


    * Always create FK for...

  • RE: generate multiple data flow tasks

    sqlfriends (9/20/2012)


    Is there a way to generate multiple data flow tasks?

    We need to import data from 40 flat files to 40 SQL server tables, instead of manually create each data...

  • RE: A Database with 70 Table

    vahid.arr (9/18/2012)


    hi everybody

    I Have Database With 70 Tables and this my first time that i have alot table in my DB. I want Any Subject or Topic that is Good...

  • RE: Setting a Primary key to subsequential Data (Header - Line)

    dwain.c (9/18/2012)


    Now I'm fairly sure someone is going to think that I'm crazy and perhaps I am, but why not use XML for this?

    Let's set up the incoming data just...

  • RE: Are the posted questions getting worse?

    Sean Lange (9/18/2012)


    Lynn Pettis (9/18/2012)


    SQLRNNR (9/18/2012)


    Lynn Pettis (9/18/2012)


    Flat file, 150,000 columns, SQL Server only allows 1,024 columns per table. The flat file needs to be imported into Excel spreadsheets.

    I'm...

  • RE: Are the posted questions getting worse?

    Lowell (9/18/2012)


    Lynn Pettis (9/18/2012)


    SQLRNNR (9/18/2012)


    Lynn Pettis (9/18/2012)


    Flat file, 150,000 columns, SQL Server only allows 1,024 columns per table. The flat file needs to be imported into Excel spreadsheets.

    I'm not...

  • RE: unique patients from duplicate patient row entries

    boehnc (9/17/2012)


    this is basically the code...this join... left join UserView.vwEncounterDiagnosis d on d.VisitId=a.VisitId...will give me multiple rows per patient

    i might need help with the diagnosis order/code statements in the where...

  • RE: job for collecting data

    eh.shams (9/17/2012)


    I need a script to copy data from one table(source) to anotehr table (destination),

    i want to sheduling this task for every 5 minute , rows which data were copied...

  • RE: unique patients from duplicate patient row entries

    boehnc (9/17/2012)


    I need to bring back in a table unique patients where dxcode = 23 or 34.

    one patient can have 23 and 34..I just need to bring back whether they...

  • RE: SSIS error from flat file to table

    You're delivering to a unicode string (nVarchar) and your file source definition is most likely string instead of unicode. Modify the source to be unicode, or use the datatype...

  • RE: Are the posted questions getting worse?

    I was working on a massive threadizen post and... lost it due to the vagueries of IE 10.

    Short form: Is there a yearly threadizen gathering that I'm unaware of. ...

  • RE: Are the posted questions getting worse?

    SQL Kiwi (9/14/2012)


    Evil Kraig F (9/14/2012)


    He might have meant as far away from civilization as possible, in which case New Zealand might have been more accurate... 😛

    Noting all this down,...

Viewing 15 posts - 1,156 through 1,170 (of 5,685 total)