All changes to SQL Server require in depth testing of every application before the change is made live.

Without testing you're guessing that it'll all work. That's not good...

For those that want the code but don't want to download a .doc, here is the original query.

DECLARE @keydoc INT

SET @keydoc = 539428

SELECT DISTINCT a.keydoc, a.keyfreesiteaccess, a.keyfreesiteaccesspublishable

FROM objectviews..aisarticle a

LEFT JOIN...

beginnew2012 (3/14/2012)

---

I'm sorry but I don't see any create table statements?

I want my table to be stored in a separate database, let's call it myDB.

This code is very complex to...

I'll try an example that you can follow in your SQL window

First, set your results to text and...

Change all references to #testEnvironment into whatever table name...

Lowell (3/14/2012)

---

I like your example Cadavre, but there's a possbility of creating names that contain...

Yes. Do what ColdCoffee said in the first place.

Untested, but it should be something...

This will create 1,000,000 rows of pseudo-random unique firstName, secondName, e-mail address and mail address.

SET NOCOUNT ON;

IF object_id('tempdb..#testNames') IS NOT NULL

BEGIN

DROP TABLE #testNames;

END;

WITH t1(N) AS (SELECT...

If you insist on not using a calendar table, then this is better: -

WITH t1(N) AS (SELECT 1 UNION ALL SELECT 1),

t2(N) AS (SELECT 1 FROM t1 x, t1 y),

CTEMonth(MonNum)...

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DelimitedSplit8K]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))

BEGIN

DROP FUNCTION [dbo].[DelimitedSplit8K];

END

GO

CREATE FUNCTION [dbo].[DelimitedSplit8K]

--===== Define I/O parameters

...

Bit of a late reply.

--Your current code

SELECT *

FROM EBBReport

WHERE IsCurrent = 0

AND (Datediff(dd, @EFFdate, convert(VARCHAR, getdate(), 1)) <= 90 AND

Datediff(dd, @EFFdate, convert(VARCHAR, getdate(), 1))...

nilesh k (3/9/2012)

---

This is what i tried:

Option 1:

SELECT base.*

FROM table base

INNER JOIN (SELECT segment, MAX([PostedDate]) AS Max (PostedDate)

FROM...

Gail Shaw wrote about "Catch all" queries a while ago[/url].

Since then, whenever I've needed to do something like that I've always started with that article in my mind.

Eugene Elutin (3/7/2012)

---

Cadavre (3/7/2012)

---

Have you heard about solving SUDOKU in T-SQL?...

Eugene Elutin (3/7/2012)

---

Gentlemen, looks like you have a lot of free time...

Can some one come up with the reasonable idea for doing it in the first place?

I do not beleive...