Complete an utter stab in the dark. . .

SELECT DISTINCT

p.dbPatID,

p.dbpatfirstname,

...

Sample data: -

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment;

END;

--1,000,000 Random rows of data

SELECT TOP 1000000 IDENTITY(INT,1,1) AS ID,

RAND(CHECKSUM(NEWID())) * 30000 /*(Number of days in...

You dealt with the technical issues very well!

ChrisM@Work (1/23/2015)

---

SELECT MondaysThisMonth = DATEADD(DAY,n,MondayBeforeFOM)

FROM (

SELECT FirstOfMonth, MondayBeforeFOM = DATEADD(DAY,DATEDIFF(DAY,0,FirstOfMonth)/7*7,0)

FROM (SELECT FirstOfMonth = DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0)) d

) e

CROSS JOIN (SELECT 7 UNION ALL SELECT 14 UNION ALL SELECT 21 UNION ALL SELECT...

Something like this would work. . .

DECLARE @PassedInDate AS DATE;

SET @PassedInDate = GETDATE();

WITH CTE ( N )

AS...

Using the sample data provided by burfos: -

DECLARE @values TABLE

(

id INT,

id1 INT,

...

Sample data: -

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment;

END;

--1,000,000 Random rows of data

SELECT TOP 1000000 IDENTITY(INT,1,1) AS ID,

RAND(CHECKSUM(NEWID())) * 30000 /*(Number of days in range)*/ + CAST('1945' AS...

I'm not affiliated with RedGate. Have you thought of using SQL Compare[/url]?

It's pretty quick and will show you in a very simple UI any differences between the schema.

Shahzadi (11/6/2014)

---

I was returning result into grid but when i was clicking on blue xml it was throwing and error

Unable to show XML. The following error happenend.

Unexpteced end of...

Shahzadi (11/6/2014)

---

Oh, you are star, that's exactly what i wanted.. :).. one last thing, actually two 🙂 ... it is showing following characters end of each line & #...

Of course you can limit it...

OK, I've messed around with this over lunch and am reasonably confident that it does what you want. Please be extremely careful, execute in a test environment that is...

Eirikur Eiriksson (10/23/2014)

---

Quick solution, should get you passed this hurdle

😎

; --terminator, not begininator 😛

WITH LAST_TABLE AS

(

SELECT TOP(1)

T.object_id

...

Really?

Cadavre (9/10/2014)

---

This sort of formatting is always better in the presentation layer than it is in the database layer. What you're...

This...