Forum Replies Created

Viewing 15 posts - 1,246 through 1,260 (of 2,894 total)

  • RE: Union Query with 'duplicates'

    SELECT f1, COUNT(*) AS CountOfQ6_BRANCH

    FROM (

    SELECT format(WEEK_DATE, "YYYYMM") as f1 FROM TBL_AML_ERRORS

    WHERE Q6_BRANCH...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 11, 2012 at 7:43 am

    #1536232

  • RE: diffeence between .&..

    Brandie Tarvin (9/11/2012)

    They are both incorrect syntax. You will get an error if you try to use either of them.

    .

    Until

    in case #1: Select * from table.col

    "table"...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 11, 2012 at 5:01 am

    #1536153

  • RE: Max Degree of parallellism

    lianvh (9/11/2012)

    Good Day, we received instruction from a large developing company to set the cpus to max degree of parallellism to 1 on an SQL Server 2008R2 64 bit Ent...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 11, 2012 at 4:19 am

    #1536115

  • RE: Brain freeze join issue.

    Looks like you are looking for "Dynamic Pivot":

    http://www.sqlservercentral.com/articles/Crosstab/65048/

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 11, 2012 at 4:12 am

    #1536111

  • RE: Regarding row size

    Googling it out would give you the answer quite easily:

    http://msdn.microsoft.com/en-us/library/ms186981(v=sql.105).aspx

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 11, 2012 at 4:06 am

    #1536108

  • RE: T-SQL Help Needed

    CELKO (9/10/2012)

    We do not use IDENTITY for a key in RDBMS. Why do you think that the count of physical insertion attempts to one disk on one machine is an...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 11, 2012 at 4:01 am

    #1536100

  • RE: How to insert empty row

    CELKO (9/10/2012)

    I need to insert empty row in a temp table within a stored procedure.

    Where is the DDL? There is no such concept in RDBMS.

    ...

    What kind of...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 11, 2012 at 3:39 am

    #1536087

  • RE: Conversion failed when converting character string to smalldatetime data type.

    One of the column you return in one of your "selects" (I think it's a first one

    ) is of smalldatetime data type (we don't know which column exactly, as you...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 11, 2012 at 3:30 am

    #1536081

  • RE: weird update statement

    dwain.c (9/11/2012)

    Sean Lange (9/10/2012)

    You know simply repeating a vague description does nothing to help me understand it.

    "Insanity is doing the same thing over and over again and expecting different results."

    --...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 11, 2012 at 3:20 am

    #1536075

  • RE: Incrementing a column without seting Identity property

    I have gt this idea suggest me if i can do it in a better way .........

    The much better way would be to contact DBA (if you cannot change it...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 11, 2012 at 3:11 am

    #1536069

  • RE: Order by a column keeping the families together

    ScottPletcher (9/7/2012)

    1. Columns are fields!

    Technically they are not.

    But in practice, many people refer to SQL columns as "fields", so you just have to accept that and move on.

    What do...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 10, 2012 at 3:49 am

    #1535586

  • RE: UPDATE when the values are the same

    ...

    Galileo was the only one which tried to oppose the common knowledge about geocentric model of the Universe.

    So, who was wrong and who was right?

    I cannot believe you are comparing...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 7, 2012 at 3:19 am

    #1534948

  • RE: Order by a column keeping the families together

    Columns are not fields. Did you learn anything? Have you looked up ISO-11179 or read a book on basic data modeling yet? Why did you fail to follow minimal Netiquette...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 7, 2012 at 2:56 am

    #1534934

  • RE: Order by a column keeping the families together

    CELKO (9/6/2012)

    [ "Granite! Use big hunks of granite!". I would add also: polish it first!

    It's cheaper than a screwdriver, and from performance point of view it can be much faster......

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 7, 2012 at 2:42 am

    #1534925

  • RE: Order by a column keeping the families together

    Luis Cazares (9/6/2012)

    CELKO (9/6/2012)

    Most of the work (80-95%) in SQL is done in the DDL. Messy, complicated DML is almost always the result of poor DDL. This is what...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    September 6, 2012 at 10:56 am

    #1534637

Viewing 15 posts - 1,246 through 1,260 (of 2,894 total)