Does the following help:

CREATE TABLE #TEST

(

COL1 VARCHAR(10),

COL2 VARCHAR(20)

)

INSERT INTO #TEST (COL1, COL2) VALUES ('Bed+Vat', 'Vat');

INSERT INTO #TEST (COL1, COL2) VALUES ('Bed+Vat', 'Cess');

INSERT INTO #TEST (COL1, COL2) VALUES ('Bed+Vat', 'BED');

INSERT INTO...

MyDoggieJessie (6/4/2013)

---

This is interesting - When you alter a column i.e.(increase the size) in SSMS using the GUI in it creates a temp table, locks the temp table, inserts all...

While this query is running in one SSMS tab, switch to another tab and run sp_who2. Is the spid running your stuck query blocked?

This is posted in a SQL Server 2008 forum, why not use MERGE?

I wouldn't assume Oracle unless I actually saw something that looked Oracle, like CREATE OR REPLACE. This was posted on a SQL Server forum with not (or actually any)...

HowardW (6/4/2013)

---

They're typically Oracle terms. SID would most closely relate to SPID in SQL Server and PID to the OS level process ID.

There's no direct correlation to SQL Server, as...

This trigger assumes that only one record will be inserted into the table [dbo].[BILL_TRN] at a time. Is this true?

Not sure what you are asking for here.

SteveEClarke (6/3/2013)

---

The easy bit -

SELECT

StockCode,

SUM(CASE TrnYear WHEN '2009' THEN InvoiceQty ELSE 0 END) AS Sales2009,

SUM(CASE TrnYear WHEN '2010' THEN InvoiceQty ELSE 0...

sj_prasad (6/3/2013)

---

INSERT INTO ACC_JVDTL_TRN ( FINYRTRN_ID, VRDT, LEDGER_ID, AMOUNT)

VALUES ((select i.FINYRTRN_ID from inserted i), (select i.BILLDATE from inserted i),

(select i.BILL_LEDG_ID from inserted i), (select i.BILLAMOUNT from inserted...

Try this:

INSERT INTO ACC_JVDTL_TRN ( FINYRTRN_ID, VRDT, LEDGER_ID, AMOUNT)

select

i.FINYRTRN_ID,

i.BILLDATE,

i.BILL_LEDG_ID,

i.BILLAMOUNT

from

inserted...

Actually, I knew that. I was just playing to it. Even if you have been gone awhile I still remember your...

IIRC, you can configure the maintenance plans so that they don't shrink the database or log files.

It has been so long since I used them I can't actually remember.

Works great for all types except the MAX...

Brandie Tarvin (6/3/2013)

---

Speaking of SQL_Variant, does anyone here actually use it?

I've never found a reason to use it or a need that made sense, so I'd love to hear...