Hi and welcome to SSC! It is really hard to figure out what you are trying to do here based on your description. Can you please try to reword what...

You're welcome. Glad that worked...

Lynn Pettis (2/7/2013)

---

Sean Lange (2/7/2013)

---

Lynn Pettis (2/7/2013)

---

Everything looks orderd to me. I wouldn't use a while loop to populate the table dbo.Time2 and you really should not use Date...

Of course it is possible, but it would be...

Lynn Pettis (2/7/2013)

---

Everything looks orderd to me. I wouldn't use a while loop to populate the table dbo.Time2 and you really should not use Date as a name for...

wafw1971 (2/7/2013)

---

Evening All

I wonder if you can help me, I have created a table but when I query the data I don't get the results in the right order:

Period 1

Period...

wafw1971 (2/7/2013)

---

I would like to say thank you for all you help, I have now created the table (the wrong way). And now have another task to complete (See other...

ChrisM@Work (2/7/2013)

---

Sean Lange (2/7/2013)

---

I am not...

I am not sure if I...

Jason-299789 (2/7/2013)

---

Sean, I've alread shown a simle proof for Tally vs Loop on this thread (http://www.sqlservercentral.com/Forums/Topic1416507-1292-1.aspx) on

Unfortunately hes been told to use the While loop by his boss. ...

wendy elizabeth (2/6/2013)

---

USE [DEV]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TRIGGER [dbo].[update_trigger]ON [dbo].[Transaction_Tracking]

AFTER UPDATE

AS

BEGIN

INSERT

INTO [dbo].[eRPT_Transaction_Audit]

( Package_ID, Received_Date, Start_Date,Operation, TriggerTable)

SELECT i.Package_ID, i.Received_Date, i.Start_Date,'U', 'I'

FROM inserted i

INNER...

Just to demonstrate how incredibly inefficient cursors can be. Take a look at this insert. It uses the tally table which can be found here. http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/url%5D

This code will insert...

And also since you say you are learning. You need to avoid using reserved words for object names. Tables named Time and columns named Date will cause you untold pain...

wafw1971 (2/7/2013)

---

Morning Everyone,

I have just started training on SQL and was wondering if you could help with a problem I have encountered.

I have populated a column...

The issue there is you have passed a string as the datetime because you wrapped your variable with tick marks.

Try this instead.

SELECT Datepart(YEAR, @StartDate) AS CalendarYear)