Duh... Here's a few more :hehe:

http://www.sqlservercentral.com/Forums/Topic1519856-824-29.aspx#bm1522006

patrickmcginnis59 10839 (12/9/2013)

---

peter-757102 (12/9/2013)

---

Charles Kincaid (12/9/2013)

---

So let's take an example of a SELECT that does not make any use of indexes.

RBAR fetches more rows from the table. False. ...

bhw0006 48811 (12/9/2013)

---

This is awesome ya'll are doing this

if object_id('tempdb..#table') is not null drop table #table

go

select first_name, last_name, age

into #table

from (

select 'Chuck' as first_name, 'Norris' as last_name, '32' as...

Dwain Camps posted a great article on Performance of the SQL MERGE vs. INSERT/UPDATE[/url].

Here's a good article by Robert Sheldon with some examples:

Working with Window Functions in SQL Server[/url]

Plagiarism stinks.

...on that note, here's an ITVF that uses ROW_NUMBER() for calculating the longest common substring.

-- (1) Function to find the longest common substring

CREATE FUNCTION CommonSubstrings(@s1 varchar(8000),@s2 varchar(8000))

RETURNS...

dwain.c (12/3/2013)

---

GordonLiddy (12/3/2013)

---

This article is a complete ripoff from Itzik Ben-Gan's book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions! Nowhere is there any credits to the original author...

This should get you what you need:

WITH

xxx AS

(

SELECTpe.IPCode AS pe_ip,

pr.IPCode AS pr_ip,

pr.ID,

DENSE_RANK() OVER (PARTITION BY pr.IPCode ORDER BY ID) AS x

FROM Person pe

CROSS APPLY [Profile] pr

WHERE pe.IPCode=pr.IPCode

),

qualifiers...

Jeff Moden (11/20/2013)

---

Alan.B (11/20/2013)

---

clayman (11/20/2013)

---

Jeff Moden (11/19/2013)

---

BWAAAA-HAAAA!!!! Sure it's easy to get to the...

Operating under the assumption that items beginning with L are children:

DECLARE @lines TABLE

(line_no int,

code varchar(3) not null,

account_no varchar(10) not null)

INSERT @lines

SELECT Line_no = 123,...

clayman (11/20/2013)

---

Jeff Moden (11/19/2013)

---

BWAAAA-HAAAA!!!! Sure it's easy to get to the moon. All...

pietlinden (11/19/2013)

---

If you're fairly new to SQL, I would do this in SSRS, because you can get SSRS to do pretty much all the hard work for you (sorting, grouping,...

No

This could do this trick:

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

CREATE TABLE ##ssrs_candidates (c_id int identity, ssrs_db varchar(100));

EXEC sp_msforeachdb'

INSERT INTO ##ssrs_candidates

SELECT TABLE_CATALOG

FROM [?].information_schema.columns

WHERETABLE_NAME =''Catalog''

ANDCOLUMN_NAME =''ItemID''

ANDORDINAL_POSITION =1

ANDDATA_TYPE=''uniqueidentifier''

'

SELECT * FROM...

krish.sett (8/3/2011)

---

Thanks for the info.....so basically i need to create a XSLT file for my XML file so that i can use XML Task Editor for the conversion.

This is really...