I've looked at this, and I have lots of questions. Specifically, it looks like a_site_id should be part of the primary key, but it is not used in any...

Both of these tables contain a foreign key to a table that you did not provide a definition for, so they will not run as written. You really need...

Part of the problem was that you didn't use...

mcfarlandparkway (1/4/2017)

---

we have a job(ssis package) where it load data from different source and destination is temp table. from temp table I have to move to main table.

selecting rec from...

Lynn Pettis (1/5/2017)

---

select memberid,...

Luis Cazares (1/5/2017)

---

Rasmus Remmer Bielidt (1/5/2017)

---

Both options have their uses for sure.

I didn't see anybody making this point, but COALESCE() absolutely needs a non-null argument or it will throw an...

Another option is to use the OFFSET function that introduced in SQL 2012 and was specifically designed for paging.

DECLARE @page_size INT = 500, @page_num INT = 1

WHILE @page_num > 0

BEGIN

SELECT...

Luis Cazares (1/4/2017)

---

drew.allen (1/4/2017)

---

But...

SQL Server is a database tool, not a reporting tool.

SSIS is an ETL tool, not a reporting tool.

SSRS is a reporting tool. Use the correct tool for the job.

Drew

Your expected results don't match your sample data. Specifically, 08400124 and 15512890 should be included and there is no record with 15507086, so that cannot appear in the results.

Here...

I treated this as a variation on the gaps and islands problem. This following works for your (extremely small) sample data.

;

WITH usernames AS (

SELECT *, ROW_NUMBER() OVER(PARTITION BY un.username...

dndaughtery (1/4/2017)

---

I have the following query where a column A can be the same but I have an order in which I want them returned based on values in a...

This can be accomplished with a ROW_NUMBER().

DECLARE @cities TABLE (

city VARCHAR(25),

stCHAR(2)

)

INSERT @cities(city, st)

VALUES

('Danville', 'KY')

,('Danville', 'FL')

,('Danville', 'TN')

,('Marthasville', 'KY')

,('Marthasville', 'FL')

;

WITH cities AS (

SELECT c.city, c.st, ROW_NUMBER() OVER(PARTITION BY c.city ORDER BY s.state_priority)...

Brandie Tarvin (1/4/2017)

---

drew.allen (1/4/2017)

---

But...

Thom A (1/4/2017)

---

Brandie Tarvin (1/4/2017)

---

Thom A (1/4/2017)

---

I'm a little confused,on one part. You stated that "a hyphen is only allowed after the first character", however that the value "ABC-1245Z" is...