You could do something like this:

IF OBJECT_ID('tempdb..#indexInfo') IS NOT NULL

DROP TABLE #indexInfo;

SELECT TOP 0

t.TABLE_CATALOG AS db,

t.TABLE_SCHEMA AS SchemaName,

OBJECT_NAME(i.OBJECT_ID) AS TableName,

...

TheSQLGuru (7/30/2013)

---

Fortunately for you SQL 2012 has much better Windowing Function support. Look into the PERCENTILE_CONT function. I also HIGHLY recommend you purchase Itzik Ben-Gan's SQL Server 2012...

dkschill (7/30/2013)

---

Is this an effective way to find median?

CREATE TABLE #T (i TINYINT);

GO

INSERT INTO #T

SELECT ABS(CHECKSUM(NEWID())) % 250

GO 1000

;WITH t AS (SELECT i, ROW_NUMBER() OVER (ORDER BY i) AS n,...

I have nothing to add to this thread...

Using this sample data:

--Adjust for the number of days of sample data you would like

DECLARE @days int = 1000;

IF OBJECT_ID('tempdb..#sales') IS NOT NULL

DROP TABLE #sales;

CREATE TABLE #sales

(sale_id int identity primary...

I asked this same question a few months back and got some good replies; just thought I'd share this:

http://www.sqlservercentral.com/Forums/Topic1397471-391-1.aspx

Check this out:

SELECT CAST(REPLICATE(CAST('' AS int),10) AS char(10)) AS...

Tobar (7/25/2013)

---

Anyone point me to the documentation, or explain why you would expect these results?

DECLARE @d DATETIME = '07/25/2013 10:11:12.345';

SELECT FORMAT ( @d, 'yyyy dd mm hh mm ss')

2013 25...

Eugene Elutin (7/25/2013)

---

Alan.B (7/24/2013)

---

I...

I say it would...

This would do the trick:

SELECT

CASE

WHEN ISNULL(rate,100)=100 THEN 1

ELSE 0

END AS Rate

FROM {yourtable}

Erland Sommarskog (7/24/2013)

---

SELECT substring(list, 1, len(list) - 1)

FROM (SELECT list =

(SELECT DISTINCT name + ','

...

A couple techniques:

SELECT RIGHT(abc_col1,len(abc_col1)-2)

FROM tableA

SELECT REPLACE(abc_col1,'SH','')

FROM tableA

Here's another way... it's kind of a "Quirky-Coalesce":

-- sample data

DECLARE @Production_Product TABLE (name varchar(10));

INSERT INTO @Production_Product VALUES ('aaa'),('bbb'),('ccc'),('ccc');

DECLARE @listStr varchar(max)='';

SELECT @listStr=@listStr+

CASE

WHEN @listStr='' THEN ''+name

ELSE ','+name

END

FROM (SELECT DISTINCT name FROM...

NineIron (7/24/2013)

---

I need to create 5 test databases by copying the live db's. There are many stored procedures in each db. Each sp is told which db to use, Use...

You can get around that doing something like this (using my own sample code...