Quick question, (and piling on the previous questions) can you tell us what you mean...

Further on Gail's answer

😎

DECLARE@SortOrder VARCHAR(100),

@SortDirection VARCHAR(100)

SELECT @SortDirection = 'ASC'

SELECT @SortOrder = 'ExpirationDate' --'DocumentName' --NULL --'DocumentName'

--SELECT @SortOrder = '[Year]'

--SELECT @SortDirection = 'ExpirationDate'

IF OBJECT_ID(N'tempdb..#TEST') IS NOT NULL DROP TABLE #TEST;

CREATE TABLE #TEST

(

DocumentName...

Still waiting for an answer to the question Why?

😎

Another approach, not perfect but not bad either;-) Additional metrics can be used to enhance the logic.

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH BASE_DATA AS

(

SELECT

...

Jeff Moden (5/14/2015)

---

Interviewer: What makes you think you're a good <<any job title here>>?

Candidate: I don't. It's just that everyone else sucks so bad that I end up...

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL, DB2, Couchbase, DocumentDB, Hadoop, Redshift,...

snoqualmiewa (5/16/2015)

---

Hi,

The insert statement in page 294 fails (SQL Server 2014 Integration Services text by Brian Knight). Any Ideas what data should be entered for the PACKAGE ID? Thanks

INSERT INTO...

Quick note, the SQL Server Data Tools is the replacement for BIDS and provided as a separate downlod.

😎

Very good points there Steve and the in a nutshell the reason why I tell the DBAs to register at SQL Server Central.

😎

snoqualmiewa (5/16/2015)

---

Hi,

The insert statement in page 294 fails (SQL Server 2014 Integration Services text by Brian Knight). Any Ideas what data should be entered for the PACKAGE ID? Thanks

INSERT INTO...

Further on Steve's reply, probably the best gain would be in spreading the tempdb data files.

😎

Jeff Moden (5/15/2015)

---

Oddly enough, I've seen the "query builder" generate such code a whole lot in my early days and it worked just fine. There are places where it...

Scott Coleman (5/15/2015)

---

If an OPENQUERY statement could make use of the @EndDate parameter, he wouldn't need dynamic SQL in the first place.

I have a lot of code that references our...

born2achieve (5/14/2015)

---

Hi Eirik,

I am into trouble now about some street names having names city name and the current logic removed the the street name as well

ex:

address = '555 Manhatten...

Sapen (5/14/2015)

---

Hello,

I am using sql2012 se and we want to use couchbase to store some data as documents. So the database will be Hybrid(partly SQLServer and Partly couchbase). However the...