Forum Replies Created

Viewing 15 posts - 1 through 15 (of 173 total)

  • RE: Today's Random Word!

    The Dixie Flatline (11/20/2012)


    pachyderm

    John Merrick

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: Creating a comma-separated list (SQL Spackle)

    Just a note of caution - if you plan to string together integers with a comma delimiter and subsquently dump the data into Excel, Excel will try to do funny...

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: Today's Random Word!

    Revenant (10/12/2012)


    crookj (10/11/2012)


    Daniel Bowlin (10/11/2012)


    Down the rabbit hole.

    through the looking glass...

    ... and it is getting curiouser and curiouser.

    and faster and furiouser

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: Display textboxes aligned at bottom of screen

    Andy Reilly (9/12/2012)


    Hi,

    What I need to do is very simple - I have a multi line text box on the bottom left of my report and a single line text...

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: Getting a count on 2 datasets in one table

    If you are looking to add counts from different datasets in a single expression:

    In the expression editor select Datasets in the Category box, select the dataset in the Item box,...

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: CONCATINATE 3 COLUMNS (int) INTO A WORKABLE DATE FORMAT

    Actually, it isn't. Take a closer look, it is actually subtracting 1 for the day or month entered in the table.

    I'm just too slow. Should have checked the post...

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: CONCATINATE 3 COLUMNS (int) INTO A WORKABLE DATE FORMAT

    Lowell (9/12/2012)


    personally, since you have integers, i'd stick with using the dATEADD() functions:

    /*

    2012-02-01 00:00:00.000

    2012-03-01 00:00:00.000

    2012-04-01 00:00:00.000

    */

    CREATE TABLE PS_TestForOnline

    (

    DAY_ INT,

    MONTH_ INT,

    YEAR_ INT

    );

    INSERT INTO PS_TestForOnline

    VALUES(1,1,2012);

    INSERT INTO PS_TestForOnline

    VALUES(1,2,2012);

    INSERT INTO PS_TestForOnline

    VALUES(1,3,2012);

    SELECT...

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: Exporting to excel

    Thanks. I found the way to name the worksheet tabs by setting the page break expression.

    You actually dynamically set the tab labels in <2008R2? Might I ask how you...

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: What is meant by set based programming?

    90% of the work is done for you

    How do I love thee SQL? Let me count(theWays)..

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: Calculated/Derived Column on existing table...please help

    dj1202 (8/10/2012)


    Hey guys, I have been going nuts over this issue for some time and I am seeking help.

    I have SQL Server table with values, as follows:

    Account - Date -...

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: Today's Random Word!

    SQLRNNR (7/11/2012)


    jasona.work (7/11/2012)


    EL Jerry (7/11/2012)


    SQLRNNR (7/11/2012)


    exploding grapes

    Exploding Gremlins

    "El" Jerry.

    Mogwai

    Gizmo

    Bright light!

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: Tablix - How to delete a header group header (or footer) after creating the group ?

    Right click the row and select Delete Rows. When asked if you want to delete just rows or rows and group, choose just rows.

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: Today's Random Word!

    SQLRNNR (7/9/2012)


    Cliff Jones (7/9/2012)


    Ray K (7/9/2012)


    Revenant (7/9/2012)


    rhythmk (7/9/2012)


    Brandie Tarvin (7/9/2012)


    Daniel Bowlin (7/9/2012)


    Heatwave

    Heatstroke

    Engine

    Piston

    V6

    V8

    HEMI

    Barracuda

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: tsql query - Count the number of spaces in a string

    That is why Jeff is SQL God

    +10

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • RE: Adding description to the report in BIDS

    View the properties pane, either click into the space around the report body, or select Report in the properties report items dropdown list. There is a property for Description....

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]

Viewing 15 posts - 1 through 15 (of 173 total)