Database

Mycroft Holmes wrote:

I just hope you are not working with one of those old EIS systems as well!

Ennis Ray Lynch, Jr. wrote:

Is there a simple method (other than Import Data and Bulk insert type operations) to detach the file groups (ok, maybe not detach they will be read-only) and copy the table, file group, and file into another database on a completely different server.

sp_attach_db [ @dbname= ] 'dbname'
    , [ @filename1= ] 'filename_n' [ ,...16 ] 

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Ennis Ray Lynch, Jr. wrote:

your method requires that the other database have the tables and files and file groups already created and requires the DB to be taken offline in order to add the new files and file groups which contain the table data.

Ennis Ray Lynch, Jr. wrote:

What I am looking for is some black magic

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

CREATE TABLE enumEquipment([Label] VARCHAR(10) PRIMARY KEY)
 INSERT INTO enumEquipment (Label) VALUES ('Tank'), ('Suit'), ('Fins'), ('Mask'), ('Snorkel');

CREATE TABLE someTableUsingTheEnum
(
  Id INT IDENTITY(1,1) PRIMARY KEY,
  EnumValue VARCHAR(10) REFERENCES enumEquipment (Label)
)
 INSERT INTO someTableUsingTheEnum (EnumValue) VALUES ('Tank') -- works
 INSERT INTO someTableUsingTheEnum (EnumValue) VALUES ('Micky') -- fails
 
 SELECT * FROM someTableUsingTheEnum -- shows 1 record, with 'Tank'
 
DROP TABLE someTableUsingTheEnum
DROP TABLE enumEquipment

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

ALTER TABLE EQIPMENT
ADD CONSTRAINT EQUIPMENTTYPE_CHK CHECK (DIVEKIT IN ('Tank', 'Suit', 'Fins', 'Mask', 'Snorkel')

Jörgen Andersson wrote:

the OP only wanted to limit the items in a column

SELECT  [Guid] ,
        UserGuid ,
        ReferenceGuid ,
        ReferenceID ,
        [Event] ,
        Comments ,
        [Time] ,
        IPAddress
FROM EventLogs AS elog
INNER JOIN (
    SELECT [Guid]
    FROM EventLogs elog1
    INNER JOIN (
        SELECT [Event], MAX([Time]) AS MTime
        FROM EventLogs
        GROUP BY [Event] ) AS t ON elog1.[Event] = t.[Event] AND elog1.[Time] = t.MTime
) AS elog3 ON elog.[Guid] = elog3.[Guid]

SELECT  [Guid] ,
        UserGuid ,
        ReferenceGuid ,
        ReferenceID ,
        [Event] ,
        Comments ,
        [Time] ,
        IPAddress
FROM     EventLogs
WHERE   ( [Guid] = ( SELECT TOP ( 1 )
                            [Guid]
                   FROM     EventLogs AS elog
                   WHERE    ( ReferenceGuid = EventLogs.ReferenceGuid AND Event=EventLogs.Event)
                   ORDER BY Time DESC
                 ) )

with cte as (
    SELECT  [Guid] ,
            UserGuid ,
            ReferenceGuid ,
            ReferenceID ,
            [Event] ,
            Comments ,
            [Time] ,
            IPAddress,
            rn = ROW_NUMBER() OVER (Partition By Event Order By Time Desc)
    FROM     EventLogs
)
select * from cte where rn = 1