BOR15K (10/15/2014)

---

Apologies for the complete blunt question.

I have created Countries_View and placed the problematic CASE within the view and then JOINT Cities A table with Countries_View B

and all works like...

Congratulations Grant!

😎

Quick thought, you cannot execute the 2K5 function on the 2K server, the execution has to be in the scope of the 2K5 only. A workaround could be in the...

Quick question, why are you using the nolock hint?

😎

Quick note, for a...

Quick thought, this is in essence an unpacking of a period, either a calendar table or a tally table (virtual calendar table) will do the job. For the latter it...

Quick SQL Server 2000 solution, both limited and cumbersome but works

😎

USE tempdb;

GO

SET NOCOUNT ON;

CREATE TABLE #SAMPLE_DATA

(

SD_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED

...

Quick cross-tab solution.

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(DOG,Name,Color,Age) AS

( SELECT * FROM (VALUES

('Boxer' ,'BO' ,'Fawn' ,1)

...

Quick thought, run both queries in the same query window with "Include Actual Execution Plan" turned on. Then compare the two plans and tell us what the difference is.

😎

Luis Cazares (10/14/2014)

---

That sounds like a good and bad news. And the good news sound great.

Thank you for the update, Steve.

In an unrelated topic, have you ever seen a code...

Further on Lynn's request, the actual execution plans?

😎

Another quick solution, less flexibility but only a single table scan

😎

USE tempdb;

GO

IF (SELECT OBJECT_ID(N'dbo.example')) IS NOT NULL DROP TABLE dbo.example;

create table dbo.example

( a int null,

b varchar(100) null,

c varchar(100) null,

d varchar(1000)...

Initial request is slow, subsequent requests are fine

😎

Quick thought, use the OUTPUT clause in the stored procedure to insert into the audit table.

😎

Quick question, can you post the full DDL of the table and the indices?

😎