Forum Replies Created

Viewing 15 posts - 2,416 through 2,430 (of 15,381 total)

  • RE: CTE within a stored proc

    mar.ko (8/28/2015)

    I don't care what anyone says, CTE's are temporary views and should persist for the life of a stored proc.

    I am sure Microsoft could have made that possible.

    They did...

    August 28, 2015 at 1:17 pm

    #1823146

  • RE: select statement with derived order status

    Assuming you know how to write the sql to get all the details for the order and details for any related orders this is actually pretty simple.

    case when max(case when...

    August 28, 2015 at 1:05 pm

    #1823144

  • RE: Error Msg

    Ed Wagner (8/27/2015)

    I'm glad I'm not the only one who notices the sp_ prefix to the procedure name and knew what it meant. 😛

    It will slow you down because SQL...

    August 27, 2015 at 2:28 pm

    #1822926

  • RE: Error Msg

    ramana3327 (8/27/2015)

    Hi,

    Under sql server errors, I am seeing frequently

    The activated proc 'sp_name' running on queue 'TestDB.dbo.SP_name' output the following: 'The current transaction cannot be committed and cannot support operations...

    August 27, 2015 at 1:21 pm

    #1822898

  • RE: Unable to run the Stored procedure in OLEDB Source

    komal145 (8/27/2015)

    I am trying to run the Stored procedure by passing parameter value in oledb source "SQL Command":

    Something like below. I know that the same stored procedure when i ran...

    August 27, 2015 at 1:18 pm

    #1822896

  • RE: Varchar parameter Tinyint search criteria

    Jason A. Long (8/27/2015)

    Also, get rid of the "WITH (NOLOCK)"s...

    I agree but without an explanation it doesn't make any sense.

    Here is an article that discusses this hint. There are plenty...

    August 27, 2015 at 10:52 am

    #1822860

  • RE: get max and min date corresponding values

    asranantha (8/26/2015)

    I have two tables.

    Emp:

    id | Deptno | sdate | edate ...

    August 26, 2015 at 10:35 am

    #1822550

  • RE: max not giving the latest one

    Jacob Wilkins (8/26/2015)

    Sean Lange (8/26/2015)

    A bit late to the party and surprised nobody else commented on this yet. The reason you are having this problem in the first place is...

    August 26, 2015 at 10:15 am

    #1822541

  • RE: PINTABLE

    TomThomson (8/26/2015)

    Sean Lange (8/26/2015)

    Great question.

    I have always laughed when I saw this because it is all caps it is not exactly clear when reading where the word breaks are. I...

    August 26, 2015 at 10:13 am

    #1822540

  • RE: max not giving the latest one

    A bit late to the party and surprised nobody else commented on this yet. The reason you are having this problem in the first place is because you have two...

    August 26, 2015 at 8:48 am

    #1822514

  • RE: PINTABLE

    Great question.

    I have always laughed when I saw this because it is all caps it is not exactly clear when reading where the word breaks are. I have always read...

    August 26, 2015 at 8:38 am

    #1822507

  • RE: merge below 2 select statements

    Ed Wagner (8/26/2015)

    Going off the post about this query at http://www.sqlservercentral.com/Forums/Topic1714385-391-1.aspx#bm1714502, this is something called Firebird SQL.

    Interesting. As much I would be willing to help I think I will walk...

    August 26, 2015 at 7:41 am

    #1822472

  • RE: merge below 2 select statements

    chindilog (8/25/2015)

    SELECT

    part.num, woitem.qtytarget AS woitemqty,

    (SELECT LIST(wo.num, ',')

    ...

    August 26, 2015 at 7:18 am

    #1822457

  • RE: How to give a name instead of an IP adress to a webbportal

    de 33643 (8/26/2015)

    Hi all,

    we have a server (Windows server 2008 R2 Standard) that runs a hyper V manager.

    The Hyper V manager runs 2 virtual servers.

    One of the virtual servers uses...

    August 26, 2015 at 7:16 am

    #1822456

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/25/2015)

    Alvin Ramard (8/25/2015)

    Ed Wagner (8/25/2015)

    I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently. I had...

    August 25, 2015 at 1:18 pm

    #1822307

Viewing 15 posts - 2,416 through 2,430 (of 15,381 total)