Forum Replies Created

Viewing 15 posts - 1,231 through 1,245 (of 15,381 total)

  • RE: Are the posted questions getting worse?

    Luis Cazares (9/23/2016)

    Someone needs a course on how to write basic DML. Or maybe I'm just grumpy this week.

    You might be grumpy but good grief. That code was horrible.

    September 23, 2016 at 1:46 pm

    #1902920

  • RE: Getting Ready for R

    Ed Wagner (9/23/2016)

    Thanks for a good question. There's actually grumblings of getting SQL 2016 here, even though we still have a SQL 2005 instance. Why not, right? ...

    September 23, 2016 at 7:10 am

    #1902771

  • RE: Msg 245, Level 16, State 1, Line 2 Conversion failed when converting the varchar value 'F' to data type int.

    Holy what the???? There are so many issues with that code it is hard to know where to start. First of all...you are storing more than 1 value in a...

    September 22, 2016 at 1:23 pm

    #1902632

  • RE: How do I initialise a sql variable to 0 in stored-procedure ?

    Smendle (9/22/2016)

    Eirikur Eiriksson (9/22/2016)

    For a variable inside the procedure use this

    😎

    DECLARE @MY_INT_VAR INT;

    SET @MY_INT_VAR = 0;

    i could be confusing this with a .NET programming environment but doesn't that initialize the...

    September 22, 2016 at 12:13 pm

    #1902600

  • RE: Updating the View or the table?

    H Laforest (9/20/2016)

    But there is no data in the table. There is at that point to EmpID = 2 or 1 for that matter

    The presence of data makes no difference...

    September 22, 2016 at 10:54 am

    #1902557

  • RE: How do I initialise a sql variable to 0 in stored-procedure ?

    Smendle (9/22/2016)

    Eirikur Eiriksson (9/22/2016)

    For a variable inside the procedure use this

    😎

    DECLARE @MY_INT_VAR INT;

    SET @MY_INT_VAR = 0;

    i could be confusing this with a .NET programming environment but doesn't that initialize the...

    September 22, 2016 at 10:52 am

    #1902554

  • RE: Complex foreign key

    I knew the answer but for the life of me I couldn't figure out why I needed to choose 4 answers. For some reason my brain did not understand that...

    September 22, 2016 at 10:48 am

    #1902552

  • RE: Nested Arrays!!

    hegdesuchi (9/21/2016)

    Hi,

    Thank you!!

    My reference file also has array format and not generic collection format. I am not sure if I can use list when we have output as an array

    I...

    September 21, 2016 at 12:14 pm

    #1902261

  • RE: Isolation level inside stored procedures

    river1 (9/21/2016)

    Dear all,

    I have this stored procedure that has inside:

    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

    The goal is to decrease the isolation level to the lowest possible. It seems to be...

    September 21, 2016 at 8:20 am

    #1902184

  • RE: Are the posted questions getting worse?

    BLOB_EATER (9/21/2016)

    Earlier in the year I applied for a PFE role which I didn't get but reached the last round. I was wondering if you guys think it would be...

    September 21, 2016 at 7:45 am

    #1902164

  • RE: Nested Arrays!!

    hegdesuchi (9/19/2016)

    Hi All,

    I am new to c# and I am stuck with logic for nested arrays.

    Below is my example and I am not sure how to do it. The value...

    September 21, 2016 at 7:30 am

    #1902152

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/19/2016)

    I'm normally very tolerant when it comes to noobs but this one only leaves me three choises

    😎

    1) deaf

    2) daft

    3) dumb

    I think that is only two choices as daft...

    September 19, 2016 at 2:26 pm

    #1901743

  • RE: need to extract text from given string

    You need to get in the habit of posting information in a consumable format.

    create table #Something

    (

    SomeValue varchar(100)

    )

    insert #Something

    select 'Day20ReminderCampaign2016_09_15_13:46:57' union all

    select 'Day3ReminderCampaign2016_09_19_02:28:39'

    From there is it is fairly trivial to...

    September 19, 2016 at 9:47 am

    #1901662

  • RE: VALUES limit

    Ed Wagner (9/16/2016)

    Sean Lange (9/16/2016)

    I had to look this one up but much as I suspected....the limit is far greater than you would normally encounter. The exception being places where...

    September 16, 2016 at 12:38 pm

    #1901452

  • RE: Rows to Columns

    erouse (9/16/2016)

    Can somebody please help? Is there a fairly simple way to do this?

    This is my data now.

    LABORLC

    152685A B C D E

    152969A B

    This is what I would like...

    September 16, 2016 at 12:20 pm

    #1901445

Viewing 15 posts - 1,231 through 1,245 (of 15,381 total)