If Gender is a non nullable column, it will work.

I'd usually go for something like this:

Delete T

FROM Event_Temp_Lead_Screen T

WHERE NOT EXISTS( SELECT 1 FROM member M WHERE ...

Variable lose scope inside the EXECUTE(), you would need to send them as parameters using sp_executesql or concatenate them in the string as I did.

Generally speaking, using parameters with sp_executesql...

YB already showed an example on how you should post sample data. For instructions on how to do it in a simple way, visit the following articles for 2 options:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

Here...

The problem is that DB_Type and DB_ENV don't have a data type assigned. Every column in your queries needs a data type defined.

Let's go step by step.

The following code generates 10 rows. I don't care about the contents, so it's a simple column with zeros.

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

Then I use a cross...

Here's a different idea. Remove the IF

SELECT @@servername AS Instance,

b.database_name...

Do you seriously have the dates stored as strings like that? Or that's the display used? Dates should be treated as dates. SSIS can identify a date/time value in the...

You can also define the columns as the Primary Key.

ALTER TABLE OrderDetails

ADD CONSTRAINT PK_OrderDetails PRIMARY KEY (InvoiceID, LineitemNumber);

Here are 2 options to get your desired results. There might be others available but these where the first I could think of.

--Option 1

SELECT m.keyvalue,

otherdata,...

Try by casting the literals in your second select statement. Another good idea is to use EXISTS for your condition.

IF EXISTS(select 1 from msdb..backupset)

BEGIN

select @@servername as...

Development/Testing/QA/Production

I'm not sure about the T, but the letters define the different environments used. The RTO and RPO will differ from environment to environment.

You'll need another ROW_NUMBER function.

WITH CTE AS(

SELECT *,

ROW_NUMBER() OVER ( ORDER BY DateTimePressed) - ROW_NUMBER() OVER ( PARTITION...

Ok, be sure to understand what's going on in here and ask any questions that you might have. You can't blame me if something goes wrong and you're not sure...

This problem and its solution is explained in here: http://www.sqlservercentral.com/articles/T-SQL/71550/

The only difference is that the article uses days instead of minutes.

CREATE TABLE #RedButtonPress(

Name ...

That's possible with minor changes to the code that I posted. Based on your OP, it could look like this:

CREATE TABLE dbo.tblReps(

id int

);

INSERT INTO tblReps VALUES(1),(2),(3),(4),(5);

DECLARE

@startDate...