Not knowing the possible values in PlusFour, try this:

SELECT (ZIP + case when PlusFour is not null then '-' + PlusFour else '' end) AS FullZIP

FROM Address

Snippy some people can be.

ddicecca (6/29/2009)

---

Seriously...? That's your help? I have Googled this for a good hour already. Hence...

Hmm,...

First, to help we will need additional information. We need the DDL (CREATE TABLE statements) for the tables involved, both source and destination. Sample data in a readily...

Mark Eytcheson (6/29/2009)

---

I usually create two datasets:

1. StartDate

SELECT CAST((CONVERT(varchar(10), GETDATE()-9, 101)) AS DATETIME) AS StartDate

2. EndDate

SELECT CAST((CONVERT(varchar(10), GETDATE()-2, 101) + ' 23:59:59') AS DATETIME) AS EndDate

Then set the parameters @StartDate...

You already have a thread for this here.

Please post any responses on thread linked above.

Rod at work (6/29/2009)

---

Lynn Pettis (6/29/2009)

---

Why not just restore the latest backup as a new database? It may not be current, ie up to the minute, but it would...

You can't modify the structure or content of the system tables.

1. Yes

2. Read Books Online (the SQL Server Help System). You can access it from SSMS (SQL Server Management Studio) by pressing the {F1} function key.

Curious, but shouldn't this:

DECLARE noteID_curs CURSOR FOR

Select NoteID from BugNotes where BugID=@IncidentID and ProjectID=@ProjectID

come after this:

Select @ProjectID = (Select ProjectID from Inserted)

Select @IncidentID = (Select BugID from Inserted)

??

And Absolute Power corrupts Absolutely! 😉

I am assuming you are attempting to connect from a separate system. What version of SQL Server was installed?

Why not just restore the latest backup as a new database? It may not be current, ie up to the minute, but it would be close.

You can't.