Forum Replies Created

Viewing 15 posts - 3,391 through 3,405 (of 8,731 total)

  • RE: Query on Using DB Snapshots

    DB Snapshots use the database as the main source of data and only store pages that get modified. That means that querying against the snapshot is probably going to impact...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 8, 2016 at 11:28 am

    #1857199

  • RE: Building DATETIME from two strings

    Johnny B (2/8/2016)

    Hi, I've worked on this for an hour or so... I'm not that good I think.

    Date ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 8, 2016 at 10:05 am

    #1857175

  • RE: CHARINDEX

    Anthony Ganley (2/8/2016)

    Hello, can you help with this.

    I have list of 1000's of ID's - example below.

    100||6||201203121235

    100||7||201308271807

    1000||1||200502050454

    1000||2||201202030803

    1000||3||201506152138

    100001||6||200803100908

    100001||23||201001290936

    100001||25||201003292252

    100005||4||200703311333

    100005||16||201206141824

    I want to find and replace so the output looks like

    100-6

    100-7

    1000-1

    1000-2

    1000-3

    100001-6

    100001-23

    100001-25

    100005-4

    100005-16

    There are so...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 8, 2016 at 8:54 am

    #1857152

  • RE: sql error

    What kind of help do you need?

    You're just sending a value that is not a valid date. If you're not sending the values with ISO format

    (YYYYMMDD for dates YYYY-MM-DDThh:mi:ss.mssss for...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 8, 2016 at 8:00 am

    #1857141

  • RE: Getting the MAX() of COUNT() aggregates

    Why are we making it complicated?

    SELECT TOP(1) WITH TIES

    d.state,

    vs.modelID As Model,

    SUM(vs.totalSalesCount) As TotalCarsSold

    FROM Dealerships d

    inner join...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 8, 2016 at 7:14 am

    #1857130

  • RE: Syntax Help Please

    mw112009 (2/5/2016)

    The output that I want is listed at the very end.

    Can someone help me with a single SQL statement.

    I don't mind using one or 2 CTEs ( Common Table...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 5, 2016 at 1:42 pm

    #1856960

  • RE: Loop procedure through multiple values

    curious_sqldba (2/5/2016)

    I have a stored procedure which takes varchar type variable as an input, the variable should be able to loop through multiple values and execute for each value in...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 5, 2016 at 11:39 am

    #1856949

  • RE: How to do Avg and IIF Statement together

    I believe that you're looking for something like this:

    =Avg(IIF(Fields!PrimaryGroup.Value = "Caims" AND Fields!Section.Value = "Dental",Fields!Payments.Value,Nothing))

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 5, 2016 at 8:59 am

    #1856903

  • RE: Are the posted questions getting worse?

    ThomasRushton (2/5/2016)

    jasona.work (2/5/2016)

    Or I can order one of these from the UK[/url] to replace the brute, I'll get nearly the same performance (although a few less CPU cores)

    Let's see... ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 5, 2016 at 8:54 am

    #1856899

  • RE: Today's Random Word!

    Ed Wagner (2/5/2016)

    crookj (2/5/2016)

    Grumpy DBA (2/5/2016)

    djj (2/5/2016)

    Smile

    The Beach Boys (recorded in '66 - '67)

    Campbell (Glenn - An early fill-in for the Beach Boys)

    Heat

    Miami

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 5, 2016 at 8:41 am

    #1856889

  • RE: IF or WHILE statements with Stored Procedures

    This is basically your code, I just corrected the variable declaration and added the stored procedure DDL. It works as it is.

    If it doesn't work, make sure that you're using...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 5, 2016 at 8:36 am

    #1856882

  • RE: Total time jobs run on a day

    What have you tried?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 4, 2016 at 1:51 pm

    #1856680

  • RE: Are the posted questions getting worse?

    Michael L John (2/4/2016)

    Grumpy DBA (2/4/2016)

    Michael L John (2/4/2016)

    GilaMonster (2/4/2016)

    jasona.work (2/4/2016)

    Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 4, 2016 at 12:32 pm

    #1856645

  • RE: Total time jobs run on a day

    You know the deal. Post DDL, sample data as INSERT statements and expected results based on that sample data.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 4, 2016 at 11:52 am

    #1856630

  • RE: Today's Random Word!

    Grumpy DBA (2/4/2016)

    djj (2/4/2016)

    Ed Wagner (2/4/2016)

    crookj (2/4/2016)

    Snowcation (3 day city closed due to snow)

    Snowplow

    Snowbunny

    Snowboard

    Snow cone

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 4, 2016 at 11:50 am

    #1856629

Viewing 15 posts - 3,391 through 3,405 (of 8,731 total)