beebkhan (10/17/2012)

---

you need to find the table that is referencing the data in your rolemaster table and remove it before you remove it. otherwhilst you will have a lot of...

pwalter83 (10/17/2012)

---

robert.gerald.taylor (10/16/2012)

---

pwalter83 (10/16/2012)

---

I have a requirement to create a CASE statement for the following condition:

SUM of NCV_BL.TEU where NCV_BL.POL_LOCATION_CD or NCV_BL.POD_LOCATION_CD is not present in MG_VSLVOY_SCHEDULE.PORT_CD for the SAISAN_VESSEL_CD,...

jon.wilson (10/17/2012)

---

I want to select a field that has a value of 0 or 1. I want to select that field but have it print

FALSE for a value...

dallas13 (10/17/2012)

---

DECLARE @lClub_group_joined_test varchar(20)

SELECT @lClub_group_joined_test = club_group_id

FROM dba.t_club_group

WHERE acct_id = @iAcctid

UPDATE #temp_ticket ...

Why are you inserting the data again to the same table? You have effectively created an endless loop. There is no need to insert the data to the same table...

briancampbellmcad (10/17/2012)

---

"Start by using the INSERTED table (which will have exactly the same columns as the table the

trigger is on) to identify what rows were affected by the insert"

I'm...

Jeff Moden (10/16/2012)

---

Wow... recent interview of a Web Developer interviewee just set a new record. Interviewee claimed 14 years experience in SQL (mostly Oracle) and 5 years recent experience...

jasona.work (10/17/2012)

---

Brandie Tarvin (10/17/2012)

---

dwain.c (10/16/2012)

---

Perhaps he was so focused on the future he's never interested...

Can you provide some sample data (insert statements) and an explanation of what you want the trigger to do?

briancampbellmcad (10/17/2012)

---

That last part makes sense...

I'm thinking an "IF" condition on transaction_type may be a step in the right direction (?):

USE [TrackIT]

GO

CREATE TRIGGER [dbo].[trDecrementBulkPurchases]

ON [dbo].[tblTransactions]

AFTER INSERT

AS

BEGIN

IF Transaction_Type = 'From...

Temp tables are created in tempdb. That is how it works. Easy enough to demonstrate.

create table #MyTable ( ID int )

select * from tempdb.sys.objects

where name like '#MyTable%'

drop table #MyTable

Did you read my post? You need to refer to the INSERTED table which in your code you still don't. The way you have it coded is that it will...

Check out this article from Phil Factor. http://www.simple-talk.com/sql/t-sql-programming/temporary-tables-in-sql-server/%5B/url%5D

Actually that probably would not get items that are not yet returned. You probably need something like this to accommodate a NULL in Date_in.

select * from #mytable

where Date_out <= @TargetDate...

Thanks for the ddl and sample data.

Something like this?

declare @TargetDate datetime = dateadd(dd, datediff(dd, 0, getdate()) - 2, 0) --this will get a date 2 days ago

select @TargetDate

select * from...