Forum Replies Created

Viewing 6 posts - 3,391 through 3,396 (of 3,396 total)

  • RE: database mail without cursors?

    Thanks for the catch Nigel... coming from baby database land (Access) where everything is pretty much in one database, this takes some getting used to!

  • RE: database mail without cursors?

    Cool, thanks! I can wait...

    Pieter

  • RE: database mail without cursors?

    Jeff Moden (8/30/2010)


    pietlinden (8/30/2010)


    Jeff Moden (8/30/2010)


    The only thing I'm missing is how YOU call the EXEC that sends an email for you. (Trying to give you a complete solution).

    I...

  • RE: database mail without cursors?

    Jeff Moden (8/30/2010)


    The only thing I'm missing is how YOU call the EXEC that sends an email for you. (Trying to give you a complete solution).

    I would call the...

  • RE: database mail without cursors?

    Staff--(1,M)---Protocol

    USE [SCRIDB]

    GO

    /****** Object: Table [dbo].[Staff] Script Date: 08/28/2010 15:54:14 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    SET ANSI_PADDING ON

    GO

    CREATE TABLE [dbo].[Staff](

    [StaffID] [int] IDENTITY(1,1) NOT NULL,

    [FirstName] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS...

  • RE: SQL for normalizing repeating groups in a text file

    If you're doing this in Access, just use the crosstab query wizard... 🙂

Viewing 6 posts - 3,391 through 3,396 (of 3,396 total)