Sergiy (10/12/2016)

---

Try this approach:

ALTER VIEW vSeedData

AS

SELECT RAND(CHECKSUM(NEWID())) Seed

GO

alter FUNCTION [GenerateRandomDateTime]

(

@MinimumDate DATETIME,

@MaximumDayDifference INT,

@MaximumSecondsFromMidnight INT

) RETURNS DATETIME

BEGIN

RETURN(SELECT TOP 1 DATEADD(DAY, Seed * ISNULL(@MaximumDayDifference, 365), @MinimumDate) + DATEADD(SECOND, Seed...

wendy elizabeth (10/11/2016)

---

I like your idea of using the output clause from the insert statement. However, I will still have the same problem of trying to obtain the unique lockid...

wendy elizabeth (10/11/2016)

---

The insert statements are on my original post. The example I showed you is an example of what I want the output to look like. Would you give...

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 (

...