Forum Replies Created

Viewing 15 posts - 7,786 through 7,800 (of 8,753 total)

  • RE: SQL Help

    p_shaw (7/17/2014)

    I have a Contract table with a CoverageCode column. I what pull 5 records for each CoverageCode. Currently I am doing this:

    SELECT TOP 5 * FROM Contract...

    July 17, 2014 at 12:55 pm

    #1730408

  • RE: Encrypt SSN Example (TDE)

    Now we do a step by step

    😎

    run this

    USE tempdb;

    GO

    IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES

    WHERE...

    July 17, 2014 at 12:49 pm

    #1730407

  • RE: Are the posted questions getting worse?

    Ed Wagner (7/17/2014)

    Lynn Pettis (7/17/2014)

    Lynn Pettis (7/17/2014)

    Lynn Pettis (7/17/2014)

    Eirikur Eiriksson (7/17/2014)

    SQLRNNR (7/17/2014)

    Eirikur Eiriksson (7/16/2014)

    Jack Corbett (7/16/2014)

    Eirikur Eiriksson (7/16/2014)

    No implied either, my respect on handling the situation! So far,...

    July 17, 2014 at 12:33 pm

    #1730398

  • RE: Encrypt SSN Example (TDE)

    Welsh Corgi (7/17/2014)

    Eirikur Eiriksson (7/17/2014)

    Welsh Corgi (7/17/2014)

    I did not open the Key in the new window.

    That was the problem.

    Thanks for all the help.

    Oooops! Hate to be the one to tell...

    July 17, 2014 at 12:26 pm

    #1730392

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/17/2014)

    Lynn Pettis (7/17/2014)

    Lynn Pettis (7/17/2014)

    Eirikur Eiriksson (7/17/2014)

    SQLRNNR (7/17/2014)

    Eirikur Eiriksson (7/16/2014)

    Jack Corbett (7/16/2014)

    Eirikur Eiriksson (7/16/2014)

    No implied either, my respect on handling the situation! So far, JC is...

    July 17, 2014 at 10:38 am

    #1730354

  • RE: Encrypt SSN Example (TDE)

    Welsh Corgi (7/17/2014)

    I did not open the Key in the new window.

    That was the problem.

    Thanks for all the help.

    Oooops! Hate to be the one to tell you but this is...

    July 17, 2014 at 10:32 am

    #1730350

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/17/2014)

    Eirikur Eiriksson (7/17/2014)

    SQLRNNR (7/17/2014)

    Eirikur Eiriksson (7/16/2014)

    Jack Corbett (7/16/2014)

    Eirikur Eiriksson (7/16/2014)

    No implied either, my respect on handling the situation! So far, JC is the only one that...

    July 17, 2014 at 9:04 am

    #1730313

  • RE: Are the posted questions getting worse?

    SQLRNNR (7/17/2014)

    Eirikur Eiriksson (7/16/2014)

    Jack Corbett (7/16/2014)

    Eirikur Eiriksson (7/16/2014)

    No implied either, my respect on handling the situation! So far, JC is the only one that has managed to rub...

    July 17, 2014 at 8:37 am

    #1730281

  • RE: Are the posted questions getting worse?

    SQLRNNR (7/17/2014)

    Eirikur Eiriksson (7/17/2014)

    Grant Fritchey (7/17/2014)

    Threadizens!

    Make sure we talk if you're Telford this week. The Red Gat Army is travelling up there this afternoon.

    Would that be this bunch?

    😎

    That looks eerily...

    July 17, 2014 at 8:20 am

    #1730266

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (7/17/2014)

    Eirikur Eiriksson (7/17/2014)

    Grant Fritchey (7/17/2014)

    Threadizens!

    Make sure we talk if you're Telford this week. The Red Gat Army is travelling up there this afternoon.

    Would that be this bunch?

    😎

    Where is...

    July 17, 2014 at 6:46 am

    #1730228

  • RE: Are the posted questions getting worse?

    Grant Fritchey (7/17/2014)

    Threadizens!

    Make sure we talk if you're Telford this week. The Red Gat Army is travelling up there this afternoon.

    Would that be this bunch?

    😎

    July 17, 2014 at 6:19 am

    #1730222

  • RE: SSIS XML file import to variable

    Quick thought, I would, if possible, use SSIS to pass the file name and path to an OPENROWSET on the SQL Server.

    😎

    July 17, 2014 at 6:12 am

    #1730220

  • RE: How do I secure the code of a stored procedure/function?

    Quick thought, have you looked into EXECUTE AS

    😎

    July 17, 2014 at 5:46 am

    #1730209

  • RE: Moving a database from sql server 2005 to a new VM

    Joy Smith San (7/17/2014)

    Hi Team,

    Currently we have a database in SQL Server 2005.

    Decided to move that DB into a new VM where we need to install sql server 2008 R2.

    We...

    July 17, 2014 at 3:52 am

    #1730169

  • RE: location of '-' in the comments Please Define Or Explain It To me

    Quick suggestion

    😎

    DECLARE @COMMENT NVARCHAR(200) = N'Work (210) 401-6838 for debtor(1) ''Guzman, Tarrasa'' status changed from Good to Bad';

    SELECT REPLACE(@COMMENT,N'-',N'') AS CLEAN_COMMENT

    Result

    CLEAN_COMMENT

    -----------------------------------------------------------------------------------

    Work (210) 4016838 for debtor(1) 'Guzman, Tarrasa' status changed from...

    July 17, 2014 at 3:48 am

    #1730165

Viewing 15 posts - 7,786 through 7,800 (of 8,753 total)