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...

I expect that the following extract will fail, as the max size of INT is 2,147,483,647 (10 Digits).

Even converting to BIGINT MAY fail, depending on the actual data, as the...

BOR15K (9/20/2016)

---

Hello,

Can one advise how to obtain file's details, please? Both xp_dirtree and xp_cmdshell return expected list of files, but I also need their properties: size and date.

Is it possible,...