You need to use a numbers or tally table as the main table in your query. Check out this article on the topic. http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/url%5D

TomThomson (12/10/2014)

---

One thing I would never attempt is...

Eirikur Eiriksson (12/10/2014)

---

I know it´s not perfect, the dynamic is just to contain the whole thing in a single batch, took it from an old code of mine which took...

Eirikur Eiriksson (12/10/2014)

---

Quick solution using a calculated column

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('dbo.TBL_ROWNUM') IS NOT NULL DROP TABLE dbo.TBL_ROWNUM;

IF OBJECT_ID('dbo.UDF_COUNT_ROWS') IS NOT NULL DROP FUNCTION dbo.UDF_COUNT_ROWS;

DECLARE @COUNT_FUNC NVARCHAR(MAX) = N'

CREATE FUNCTION...

TomThomson (12/10/2014)

---

That's rather easy to do. ...

Yeah it was down for about 15 minutes or so it seems.

davoscollective (12/10/2014)

---

Xavon (12/10/2014)

---

paul.knibbs (12/10/2014)

---

Emil Bialobrzeski (12/10/2014)

---

i saw lots of people on social sites having problems with:

most of the answers was 1. So saying Simple may apply differently to...

JKSQL (12/9/2014)

---

Sorry, I can give more information.

In the parent the table is a table that has a PK on the guid (non clustered). The table is empty.

the Child...

Alan what you posted is almost exactly what I had envisioned. I refrained from posting simply because this seems so much like homework. Let's hope the OP reads this and...

JKSQL (12/9/2014)

---

I ran into a performance issue the other day and was really confused.

The stored procedure filled a temp table with the parent objects. If the particular...

Port1433 (12/9/2014)

---

Can some one tell me what should be the OUTPUT format of this query: I was expecting some average number and then the phrase' the average is less than...

DSNOSPAM (12/9/2014)

---

Sean Lange (12/9/2014)

---

Here is where I am going to disagree with Gail and Grant. I have worked on a system that had many procs nested like this and it...

cbrammer1219 (12/9/2014)

---

Yes it is straight forward...Using the web tools is it a violation of use if I just use the tools for validating addresses, for such smart individuals, you like...

Emil Bialobrzeski (12/9/2014)

---

cbrammer1219 (12/9/2014)

---

Ok I have a fairly straight forward question, wondering if anyone knows the answer. I have been tasked to use USPS Address tools to validate our clients...

cbrammer1219 (12/9/2014)

---

Ok I have a fairly straight forward question, wondering if anyone knows the answer. I have been tasked to use USPS Address tools to validate our clients addresses, we...