ChrisM@home (1/14/2012)

---

In the meantime, you will get some mileage from this

SELECT custid, store, Amount

FROM Table_1 t1

WHERE NOT EXISTS (SELECT 1 FROM table_2 t2 WHERE t2.store = t1.store AND t2.product...

Second option:

DECLARE @Example TABLE

(

CusNo char(6) PRIMARY KEY,

Amount money NOT NULL

)

INSERT @Example

(CusNo, Amount)

VALUES

...

This is one way to do it:

DECLARE @Example TABLE

(

CusNo char(6) PRIMARY KEY,

Amount money NOT NULL

)

INSERT @Example

...

A quick educated guess, before the requested details turn up:

CREATE VIEW dbo.T2V

WITH SCHEMABINDING AS

SELECT

t.product,

t.store,

COUNT_BIG(*) AS...

It's one of those new ones with 3x128GB and 1x1GB RAM chips installed :laugh:

Jack Corbett (1/14/2012)

---

I'd actually recommend doing both a function and this constraint. I'd do the function to verify data BEFORE the insert or update into the table...

I was curious to see how difficult it would be to implement a table and indexed view combination that would allow you to do all the things you require. ...

This is a good option, so long as the temptation to use a scalar function in the constraint definition is resisted. Write the condition out in full in the...

Set up a VM on your existing machine, install a supported version of...

For more information and details:

Online Index Operations for indexes containing LOB columns[/url]

Online non-NULL with values column add in SQL Server 11[/url]

If you are looking for a way to also read the contents of a file directory from SQL Server, you could use xp_cmdshell. Another way is to use a...

As Sean says, FILESTREAM is an option, as is storing just the path in SQL Server and keeping the images themselves in the file system. Storing images in the...

I see Lynn posted while I was writing that. In an attempt to add some value, here's a possible procedure implementation. I don't like this as much overall:

CREATE...

Jack Corbett (1/13/2012)

---

You do have to be careful with functions because they can be hidden RBAR (loops) and not truly set-based so I don't use a ton of...

Sean Lange (1/13/2012)

---

I have to say this whole situation has left me feeling extremely reluctant to post on just about anything for fear that I come across as "one of...