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...

You can. It's hard to work with what you posted so I created the following sample code to demonstrate how you would join two tables in the way you are...

As Sean said, you need an ORDER BY statement.

I created some sample data and a query that you could use for reference. I am a fan of using the...

My object naming needs to be cleaned up a little but I think you are looking for something like this:

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

DROP TABLE #tableDataPrep;

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

DROP...

You can do something like what I did below. I'm not 100% clear about what you are trying to do but this should help....

You would have an agent job run...