Forum Replies Created

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

  • RE: Is the following line ok?

    Is it quicker to use OBJECT_ID?  If so, any idea how much quicker?

  • RE: Ethics and Honor

    ON MY honor as a student, I have neither given nor received aid on this assignment or exam

    Surely this is a bit extreme.  I think that for many subjects this...

  • RE: Size of table created on the fly is limited

    I'm not really sure what you mean.  But if it can speed up the application I'll like to try.  Please can someone expand on this idea.

  • RE: Size of table created on the fly is limited

    I am not really referring to a #temp table.  But it is a table that is created at the beginning of the run and then dropped at the end of...

  • RE: Use of temp table

     

    The full context of the loop is:

     

    DECLARE @Counter_temp INT

    SET @Counter_temp = 1

    While @Counter_temp <= (SELECT MAX(Key_m) FROM Time_definition_SPLIT) begin 

     DECLARE @Instance_tag varchar

     SET @Instance_tag = (SELECT T.Instance_tag FROM Time_definition_SPLIT T WHERE T.Key_m =...

  • RE: Smart Companies

    Mike,

    Sometimes it is too late to be reactive (9/11).  However, proactive government has not been mastered in the West yet (Iraq).

  • RE: Smart Companies

    Michael,

    The fact that you can say that without fear or intimidation suggests that NHS England is smart because views are freely expressed and problems must surely then be open for...

  • RE: Zettabyte

    It is probably worth considering that it is not the data it is what you do with it that counts.  My boss keeps reminding me that they managed to fly...

  • RE: Placeholders in EXEC statements

    Sounds interesting.  But I'm not sure I understand what you are showing me.  I suppose the questions that I originally posted should have been: Firstly, does MS SQL Server support placeholders...

  • RE: Ten Ways To Lose Your DBA Job

    I think that social interactions are really important.  That is why I wear industrial strength ear protectors when I work.

  • RE: Ten Ways To Lose Your DBA Job

    I think that social interactions are really important.  That is why I wear industrial strength ear protectors when I work.

  • RE: How do I cast the figure 2000.00 to the integer 2000?

    CAST(ROUND(year, 0) AS int) AS Expr1

    is an alternative solution

  • RE: Data Migration : Step by Step

    I think that it was a worthwhile attempt to set out procedures for a task like this.  But, honestly, I found it a bit difficult to follow.  Every case is...

  • RE: Replace all ful stops in all records with nothing

    Sorry, I didn't leave enough display space open on my result viewer.

  • RE: Replace all ful stops in all records with nothing

    Thanks for the test script.  I don't want to remove the number after the full stop.  I just want to remove the full stop.  (I am pleased that you did...

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