SQL_Enthusiast (5/10/2013)

---

AND maybe it would help if I gave you a table to insert into...???

CREATE TABLE [dbo].[TEMP_COMMENT]

(

[GUID] [varchar](32) NULL

,...

AnnA-607068 (5/10/2013)

---

If I used an instead of trigger, and deleted records on the table that has an instead of trigger from the instead of trigger, then the instead of trigger...

AnnA-607068 (5/10/2013)

---

I am rewriting a FOR DELETE trigger. The current trigger, written in 2004 when we were still on SQL Server 2000, assumes only one row will be deleted...

zulmanclock (5/10/2013)

---

Figured it out. Had to do some string manipulation but i got it:) Would have been easy if i wasnt working with data that came from Unix.

SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,Cast(Field1...

ssmith 29602 (5/10/2013)

---

One day I'll learn to give you all the information at the first go.

There are more different stages then just Bus_Written and I need to include them...

ssmith 29602 (5/10/2013)

---

Sorry, here the the complete statement

Select

oppo_opportunityref

,oppo_stage

,oppo_closed

From

Opportunity

Where

Case Oppo_stage When...

Revenant (5/10/2013)

---

jasona.work (5/10/2013)

---

14 days and change until I start my 2 week vacation...

18 days and change until I'm touching down in Jamaica for that vacation...

18 days and a bit more...

ssmith 29602 (5/10/2013)

---

This is probably very simple but I can't get it to work.

If trying to write this

Case Oppo_stage When 'Bus_Written' Then (oppo_closed is null or Oppo_Closed >= GETDATE() -7)

but...

memymasta (5/10/2013)

---

I'm having trouble creating a simple derived table. It is so simple to create a derived table with multiple columns with:

SELECT 1,2,3

Feels like it shouldn't be much more...

Need a VB programmer here.

j2cagle (5/9/2013)

---

It's just a string variable in VB. There is no " or ' choice. It works fine when you just pass in "ABC", but when a space is introduced...that's...

Try it with this: 'ABC...

j2cagle (5/9/2013)

---

I'm wanting to send a string into a stored procedure, but only use the first characters up to the first space.

For example, if I pass in:

"ABC DEF GHI"

I'm only...

Evil Kraig F (5/9/2013)

---

Lynn Pettis (5/9/2013)

---

Because you have the table alias in the wrong place:

select...

Straight from BOL:

http://msdn.microsoft.com/en-us/library/ms188629(v=SQL.90).aspx

Also here:

http://msdn.microsoft.com/en-us/library/ms189121(v=sql.100).aspx