Forum Replies Created

Viewing 15 posts - 2,716 through 2,730 (of 26,490 total)

  • RE: Are the posted questions getting worse?

    All I am going to say is this, some people shouldn't be allowed to work with databases without direct supervision.
    This could be related to certain posts here or to...

  • RE: Subroutines in TSQL

    dmeissner - Tuesday, August 15, 2017 10:54 PM

    Lyle, 

    I'm sorry you don't understand that this is a hypothetical example. There is no schema except that which the viewer chooses. Variables such as my_database,  my_table,  and my_column are clearly placeholders where one can simply swap out to match their schema. Nothing more. 

    I didn't feel it was necessary to include code for creating...

  • RE: Backup size and DB size are different.

    Well, let us see.  All you provided was the scripts (stored procedures).  Not really much we can tell from these alone.  Nothing tells us how these were invoked at the...

  • RE: t-sql 2012 selection based upon paramter value

    wendy elizabeth - Tuesday, August 15, 2017 7:50 AM

    I have the following t-sql 2012 that uses are union all statement to make...

  • RE: Special Characters and Unicode Characters

    No, there is no generic replace function that you can use for this, you have to write your own.  Also, if you know you are dealing with UNICODE data you...

  • RE: Subroutines in TSQL

    dmeissner - Monday, August 14, 2017 5:48 PM

    Not sure exactly what you are getting at.  This is an ad-hoc process  that can be used for any schema with minimal tweaking. Schema is relative. The user has asked for an example of how the functionality...

  • RE: Subroutines in TSQL

    dmeissner - Monday, August 14, 2017 4:07 PM

    Lynn Pettis - Monday, August 14, 2017 3:38 PM

    August 14, 2017 at 4:40 pm

    #1955237

  • RE: Subroutines in TSQL

    dmeissner - Monday, August 14, 2017 3:19 PM

    Code as requested. A little crude maybe, but it's not a Mona Lisa.

    ============================

    /*==================================================
    ...

  • RE: Subroutines in TSQL

    dmeissner - Monday, August 14, 2017 12:19 PM

    I already did. 

    "I did run across the thread searching for the same thing for an old mssql...

  • RE: Subroutines in TSQL

    dmeissner - Monday, August 14, 2017 7:57 AM

    Wow, triggered again.

    Dude, post your solution.

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Saturday, August 12, 2017 10:13 AM

    Off on Tech Outbounds SQL Cruise this week. I'll probably be very light on...

  • RE: Fantasy Football 2017

    roryp 96873 - Friday, August 11, 2017 10:05 AM

    Ray K - Friday, August 11, 2017 9:57 AM

  • RE: Simple Recovery Model and Checkpoint

    coolchaitu - Friday, August 11, 2017 10:20 AM

    GilaMonster - Friday, August 11, 2017 10:12 AM

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Thursday, August 10, 2017 11:09 AM

    Luis Cazares - Thursday, August 10, 2017 11:05 AM

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Wednesday, August 9, 2017 5:00 AM

    ThomasRushton - Wednesday, August 9, 2017 4:11 AM

    August 9, 2017 at 9:04 am

    #1954656

Viewing 15 posts - 2,716 through 2,730 (of 26,490 total)