Grant Fritchey (10/11/2016)

---

What everyone else has said, plus.

If you're going to attempt to tune the query, you absolutely have to have the execution plans. There is no way you can...

Without visibility of your table structures, indexes, and actual query plans, it's difficult to look for the issues.

That said, that's quite a large query with a lot of UNIONs.

At a...

This should give you the results that you are looking for. However, if there are 2 countries in the same region with the same min population, then you will...

The following partial solution is dependant on PatExclude8K available here ... http://www.sqlservercentral.com/scripts/T-SQL/117890/

If your data is "adres=molenweg 9a" then you will need to strip out the "adres=" first.

DECLARE @SourceTable TABLE...

DECLARE @tblStr VARCHAR(MAX);

DECLARE @intCtr INT;

SET @intCtr = 1;

WHILE @intCtr <= 6

BEGIN

SET @tblStr = '

IF OBJECT_ID(''[dbo].[SomeTable' + CONVERT(VARCHAR(5), @intCtr) + ']'', ''U'') IS NOT NULL

BEGIN

...

Thank you Eirikur and Drew.

This is based on the RegistrationDate. You can modify it to work on...

DECLARE @today DATETIME = DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0); -- This is important to remove time from the equations

DECLARE @EndDate DATETIME = DATEADD(dd, -DATEPART(dw,...

Based on the data that you have supplied, the following SQL works

SELECT *

FROM #Test AS t

WHERE ISNUMERIC(ResultValue) = 1;

Eirikur Eiriksson (10/1/2016)

---

I know I'm splitting hairs but there are quite some differences between the different methods of producing inline tally or number sequences. The method DesNorton posted is quite...

First set up your data

CREATE TABLE #Required (

KeyHD INT --PRIMARY KEY CLUSTERED

, CountInserted ...

This code will dynamically

- add a suffix to each duplicated QuestionNo

- build SQL to pivot the data

UPDATE dbo.TestTable1

SET Identifier = upd.Identifier

FROM dbo.TestTable1 AS orig

INNER JOIN (

...

1 - You have not provided a key that groups all of the data for a specific person. Although, from your pivot code, it appears that Period may be...

SELECT *

FROM YourTable

WHERE 'False' IN (col1, col2, col3, col4, col5, col6, ... )

valeryk2000 (9/27/2016)

---

This is the fragment of the table

CREATE TABLE [dbo].[Readmission_Table](

[ID] [float] NULL,

[ArrivalDateTime] [datetime] NULL

) ON [PRIMARY]

GO

INSERT [dbo].[Readmission_Table] ([ID], [ArrivalDateTime]) VALUES (10000683, CAST(0x0000A66801716A50 AS DateTime))

INSERT [dbo].[Readmission_Table] ([ID], [ArrivalDateTime]) VALUES (10000683, CAST(0x0000A66900B9AB40...