NEVER MIND

I figured it out:

(changed Type to L_Type) and...

UPDATE dbo.LOCATION

SET L_Type = CASE

WHEN L_Type IS null

...

I also have a NULL Column in the same table, and want to change the data to "RESIDENCE"

I tried:

UPDATE dbo.LOCATION

SET [Type] = CASE

...

I ***BOW ***TO YOU NOW :hehe:

HUGE THANK YOU!!!

-Dane

I GOT IT

THE TABLE:

CREATE TABLE [dbo].[CFS](

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

[SequenceDate] [date] NOT NULL,

[SequenceNumber] AS ('CFS-'+[dbo].[GetNextSequence]([SequenceDate],[SequenceId])),

[TEXT] [nchar](10) NULL,

CONSTRAINT [PK_CFS] PRIMARY KEY CLUSTERED

(

[SequenceId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...

What do you guys think?

USE [msdb]

GO

/****** Object: Job [CYCLE NUMBER] Script Date: 03/28/2011 08:01:05 ******/

BEGIN TRANSACTION

DECLARE @ReturnCode INT

SELECT @ReturnCode = 0

/****** Object: JobCategory [[Uncategorized (Local)]]]...

Reading now....:smooooth:

GilaMonster (3/28/2011)

---

Open up Books Online and read up on SQL Agent and jobs.

While you're there, read up about backups and integrity checks. SQL databases can go corrupt too, and...

Thanks again guys, you all have given me some additional homework and learning. I have no DBA, I am trying to create a database for use at work to...

What would I do without the internet?

You guys area great! 😎

So... What the hEcK do I do? LOL :hehe:

Please remember I am very green to SQL, I am...

Here is what I have so far:

My table currently references the Id column, which is ok,

but I need the number that follows the date to re-cycle every 24hrs back...

I am a complete n00b, could you explain how to do this?

please!!!!

You guys rock, thank you all for your valued suggestions, seriously!

i will try the assorted suggestions when i get home, hope my newb brain can figure out this SQL stuff......

Here is the rundown:

I run a security team, and well I am designing a dispatch log of sorts and a report system, Using Access 2010 as the front and SQL...