rjjh78 (3/14/2016)

---

Hello,

I have created the cursor below. The intent of my project is to automate the creation of user accounts.

What I am doing is creating the username,...

Jeff Moden (3/11/2016)

---

Ed Wagner (3/11/2016)

---

TheSQLGuru (3/11/2016)

---

Someone needs to benchmark the...

SQLisAwE5OmE (3/10/2016)

---

Sean,

If you don't mind, can you elaborate more on these steps.

Is the requirement that the email be sent real time?

Ans: No, I do not need it real time.

If not,...

You need to read up a lot about how triggers work. If you add a delay it is only going to delay the processing. That means your application will just...

SQLisAwE5OmE (3/10/2016)

---

Sean Lange (3/10/2016)

---

SQLisAwE5OmE (3/10/2016)

---

I am not trying to ignore you guys in terms fixing the code for multiple row inserts.....

But my trigger is not working as per my requirements,...

SQLisAwE5OmE (3/10/2016)

---

I am not trying to ignore you guys in terms fixing the code for multiple row inserts.....

But my trigger is not working as per my requirements, I am trying...

SW_Lindsay (3/10/2016)

---

I have a huge select statement that has to be repeated because the Group By changes at the four different levels. Is there a way to leave the...

SQLisAwE5OmE (3/9/2016)

---

I have modified my trigger to do a join with another table to get the Meeting(Class) code since it doesn't appear on dbo.order table, the meeting code is inserted...

SQLisAwE5OmE (3/9/2016)

---

Sean Lange (3/9/2016)

---

SQLisAwE5OmE (3/9/2016)

---

Sean Lange (3/9/2016)

---

No. That means that...

SQLisAwE5OmE (3/9/2016)

---

Sean Lange (3/9/2016)

---

No. That means that your program inserts...

No. That means that your program inserts the rows one...

SQLisAwE5OmE (3/9/2016)

---

Hi Sean\Martin,

Here is my revised code

USE [IMIS_TEST]

GO

/****** Object: Trigger [dbo].[Orders_Online_Reg] Script Date: 03/09/2016 09:29:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[Orders_Online_Reg]

ON [dbo].[Orders]

AFTER insert

AS

DECLARE @ORDER_NUMBER varchar(100)

DECLARE...

MMartin1 (3/8/2016)

---

SELECT @ORDER_NUMBER = i.ORDER_NUMBER, @ID = i.ST_ID, @Name = i.FULL_NAME, @Timestamp = i.ORDER_DATE

from inserted i

This above will fail whenever the application inserted more than one row as part...

Here is one such possibility. This will generate any number of empty columns with the name of the date using 2 date variables as the start and end values. This...

Give us something here. You just want 30 empty columns? Do...