While we're on the subject: I've been wanting to experiment with these [ code ] blocks for a while, as they don't always do what I expect.

SELECT

'blank line above',

'and below'

above...

It could just be that its off screen somewhere.

Not sure if this applies to you, but I worked on a laptop with extra monitor, and as any windows can be...

If you only have the URL to the file, then one method is writing a C# CLR procedure which accepts a URL, then goes to get the file, and either...

I had a short stint working for the marketing manager of a hospitality retailer. He often got free samples of the various offerings of breweries, wine merchants, cider makers...

I...

Another possibility is to create a table valued function instead of a stored procedure.

-- simple example as a stored procedure

CREATE PROC MyProc

@PARAM INT

AS

SELECT TOP(@PARAM) *

FROM sys.syscolumns;

GO

EXEC...

For the Anything that is NOT about SQL! forum, this thread has gotten a bit technical. I'm used to the light-hearted bits.

Time for a nice Merlot. 😀 as the...

I went through a similar exercise a long time ago - using SQL 2000. We listed all stored procedures, found all references to them in the application code (so...

John Rowan (6/17/2009)

---

I would favor the original query over the NOT EXISTS query. Your execution plan my look the same on this small example, but you'll see different results...

It depends on how your excel file is stored in sharepoint.

If its an item in a document library then it has its own URL, you should be able to...

Assuming your example is as you intended (it worked for me) I can't see a way of replacing the two joins on #tmp_code with a cte - but you could...

I wouldn't say its a requirement or a best practise

The answer is 'it depends' - on the data.

A Foreign key is used to enforce referential integrity - so you...

No, the SELECT statement is designed that way.

You can achieve what you want like this (its not good practise)

IF NOT EXISTS (SELECT * FROM products

WHERE productname = 'bob')

...

Grant Fritchey (6/15/2009)

---

Actually, I could care less about baseball too.

Hey, BBC...

I think what Jeff's getting at is doing a date range report, where the data you're querying has time a component.

So you want all June's Data - BETWEEN '2009-06-01' AND...