You'll find detailed instructions in this article

Determining space used for each table in a SQL Server database[/url] by: Greg Robidoux

😎

Jeff Moden (4/5/2014)

---

print concat('drop table ',@tablename);

I just can't help it. CONCAT seems so much less natural and less obvious and more difficult to read than...

print 'drop table ' +...

The problem is that you cannot pass sql identifiers such as table names...

Assuming that you have...

naresh0407 (4/5/2014)

---

Basically i have Header and DetailRow table seperalty.So need to transfer H row to header table and D row to DetailRow.

Can i acheve this without scriptask?

I have one...

This code creates a polygon and 200 points (lat/lon) and then selects the points that are inside the polygon

😎

DECLARE @POLIGON geography;

SET @POLIGON = geography::STPolyFromText('POLYGON ((5 5, 10 5, 10...

What's next, business holidays and weekends? 😀

Just for the sake of completion:

SELECT Eventdate,Status

INTO #AP_DATA

FROM (VALUES

('2014-01-20 18:00', 0)

,('2014-01-20 18:30', 0)

,('2014-01-20 19:00', 1)

,('2014-01-20 19:30', 0)

,('2014-01-20 20:00', 1)

,('2014-01-20 20:30', 0)

,('2014-01-20 21:00', 0)

,('2014-01-20 21:30',...

ado-712642 (4/5/2014)

---

SSC thank you for your reply. I just tried using this in my table and am a bit confused. If my table structure is like this, what...

J Livingston SQL (4/5/2014)

---

are these just for 2012?

I "thought" that UNBOUNDED PRECEDING/FOLLOWING was introduced in 2012...so not available in 2008?

may well be wrong.

nevertheless it provide a solution...

I wonder what is...

Here is the code 😎

DECLARE @POLIGON GEOMETRY;

/* ms sample from BOL */

SET @POLIGON = geometry::STPolyFromText('POLYGON ((5 5, 10 5, 10 10, 5 5))', 0);

;WITH NN1(N) AS (SELECT NM.N FROM...

Lets do both with the same solution

😎

/* SAMPLE DATA */

SELECT

X.NUM

INTO #MY_NUMBERS

FROM

(

...

Join the two tables and use ISNULL/COALESCE to replace NULLs

😎

DECLARE @TABLE_A TABLE

(

SNO INT ...

AndrewSQLDBA (4/4/2014)

---

Hello Everyone

Happy Friday

I am dealing with what I believe is Oracle that is the source of a SQL View.

I am seeing a data type of Integer in the View,...

This can be done by shifting each point on the line by x and y (@OFFSET_X/Y in the code)

😎

DECLARE @line geometry = 'LINESTRING(1 1, 2 2, 3 3, 4 4,...

Use a CTE or a table with the additional email addresses to be added, cross join to a filtered set with code replacement and union the result to the original...