Forum Replies Created

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

  • Reply To: What to build the first time 

    Well, I have made this for a start:

    please correct me if im Wrong
    note: all of this data is just example and not Real

    Answers:
    --1.A CREATE DATABASE FIRST

    USE [master]
    GO

    CREATE...

    May 30, 2021 at 4:13 pm

    #3889941

  • RE: HOW TO GET FIRST DATE

    Tom Van Harpen - Tuesday, October 16, 2018 2:09 PM

    I would first tell her about SQL and show how an Over clause...

    October 21, 2018 at 6:03 pm

    #2010528

  • RE: HOW TO GET FIRST DATE

    Jeff Moden - Sunday, October 14, 2018 6:53 AM

    Deny_Christian - Monday, September 17, 2018 12:54 AM

    October 15, 2018 at 4:25 am

    #2009551

  • RE: HOW TO GET FIRST DATE

    John Mitchell-245523 - Monday, September 17, 2018 4:23 AM

    Did you try running that?  It won't work, because you don't have a GROUP...

    September 18, 2018 at 12:37 am

    #2006079

  • RE: HOW TO GET FIRST DATE

    John Mitchell-245523 - Monday, September 17, 2018 1:49 AM

    And your question is?

    Allow me to preempt.  You don't need a cursor - instead,...

    September 17, 2018 at 4:08 am

    #2005927

  • RE: Delete Old Tables

    Knut Boehnert - Friday, September 14, 2018 7:32 AM

    This is procedural code instead of set-based code. This will work.

    What I mean...

    September 15, 2018 at 6:09 am

    #2005865

  • RE: Delete Old Tables

    andycadley - Wednesday, September 12, 2018 12:55 PM

    Something like:

    Insert Into TableB
    (
       TableName,
       cola,
       colb,
       colc,
       user_name,
       action,
       deletion
    )
    Select
       TableName,
     ...

    September 14, 2018 at 4:41 am

    #2005727

  • RE: Delete Old Tables

    Jeff Moden - Tuesday, September 11, 2018 5:42 AM

    unas_sasing - Tuesday, September 11, 2018 2:13 AM

    September 11, 2018 at 9:32 pm

    #2005358

  • RE: Delete Old Tables

    ScottPletcher - Monday, September 10, 2018 8:24 AM

    Jeff Moden - Monday, September 10, 2018 8:04 AM

    September 11, 2018 at 2:13 am

    #2005194

  • RE: Delete Old Tables

    Joe Torre - Friday, September 7, 2018 11:33 AM

    Please post create table script and insert script with sample data, you've provided what...

    September 9, 2018 at 8:42 pm

    #2005006

  • RE: ALIGNMENT

    Jason A. Long - Thursday, December 14, 2017 7:43 AM

    unas_sasing - Wednesday, December 13, 2017 8:10 PM

    December 14, 2017 at 8:43 pm

    #1972233

  • RE: ALIGNMENT

    GilaMonster - Wednesday, December 13, 2017 11:36 PM

    https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql

    thank you GilaMonster

    December 14, 2017 at 1:49 am

    #1972080

  • RE: ALIGNMENT

    Jason A. Long - Wednesday, December 13, 2017 1:57 PM

    Try this...
    SET QUOTED_IDENTIFIER ON;
    GO
    SET ANSI_NULLS ON;
    GO
    CREATE PROCEDURE dbo.usp_Align
    /* =================================================================================================================================
    12/13/2017 JL,...

    December 13, 2017 at 8:10 pm

    #1972062

  • RE: ALIGNMENT

    aaron.reese - Wednesday, December 13, 2017 6:46 AM

    My next question would be WHY?

    This feels like it is a presentation issue and should...

    December 13, 2017 at 7:59 pm

    #1972061

  • RE: PRIME NUMBERS

    Jeff Moden - Wednesday, December 13, 2017 5:27 AM

    unas_sasing - Tuesday, December 12, 2017 7:54 PM

    December 13, 2017 at 5:57 am

    #1971931

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