Steve Jones - SSC Editor (11/15/2010)

---

One trick that might work, not sure since you havent' provided much info, is to use the "Go trick".

Have smaller cross joins, or variable ones,...

LOL... Certification exam stuff is basically a total joke, in my opinion... but I have to do it...

I just found it odd that there's a ton of stuff on HOW...

Okay, I'm stupid. When, if ever, should you truncate the log file? Or should you just move parts of it to another log file? Funny, NONE of...

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!

Cool, thanks! I can wait...

Pieter

Jeff Moden (8/30/2010)

---

pietlinden (8/30/2010)

---

I...

I would call the...

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...

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