Start with this and see where you might go from there.

Select

Person,

ProposedEvent,

DayField,

TimeField

from

...

Sean Lange (8/5/2015)

---

Ed Wagner (8/5/2015)

---

SQLRNNR (8/5/2015)

---

Sean Lange (8/5/2015)

---

Ed Wagner (8/5/2015)

---

Jack Corbett (8/5/2015)

---

I couldn't answer all the questions, but I don't expect to be able to answer every question...

Stephanie Giovannini (8/5/2015)

---

I want to return a BIT from an outer join. I want the result type to be BIT. However, the usage of ISNULL is forbidden by code standards....

WayneS (8/5/2015)

---

Lynn Pettis (8/4/2015)

---

SQLRNNR (8/4/2015)

---

Lynn Pettis (8/4/2015)

---

SQLRNNR (8/4/2015)

---

Steve Jones - SSC Editor (8/4/2015)

---

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting the questions/knowledge...

SQLRNNR (8/4/2015)

---

Lynn Pettis (8/4/2015)

---

SQLRNNR (8/4/2015)

---

Steve Jones - SSC Editor (8/4/2015)

---

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting the questions/knowledge that people lack...

SQLRNNR (8/4/2015)

---

Steve Jones - SSC Editor (8/4/2015)

---

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting the questions/knowledge that people lack in interviews published?...

bghad1 (8/4/2015)

---

are you sure that BI is not kinda restricted area of IT...

blossom_suki (8/4/2015)

---

Thanks you all for the feedback.

I would like to accomplish an automatic way of creating views with the same WHERE condition in more than 90 different tables.

The database...

How about this:

select * from #tReceive;

with basedata as (

select

rn = row_number() over (partition by JobNumberID, PONUMBER, DELIVNOTE, [DATE] order by ORDERKEY)

, JobNumberID

...

Since your UPDATE statement does not work correctly, what should the results be based on the sample data you provided?

ScottPletcher (8/4/2015)

---

SET Ansi_Nulls On;

SET Quoted_Identifier On;

GO

ALTER Procedure [dbo].[sp_ViewCreate]

@TableName varchar(100),

@Dist varchar(20)

AS

Set Nocount On;

Declare @SQLQuery AS nvarchar(4000)

Declare @ParamDefinition AS nvarchar(2000)

Declare @TSN AS...

Jacob Wilkins (8/4/2015)

---

Jacob Wilkins (8/3/2015)

Indeed. On a couple million rows, that typically shaves some tens of milliseconds from the duration compared doing the math on the date first. Prior to...

with base as (

select

...

blossom_suki (8/4/2015)

---

Actually, I need to create 20 views for each database, in the system we have more than 90 databases.

Thus, I was wondering if there is an automated way of...

I have to agree with Sean on all his points. Looking at your code, however, I see other problems as well.

You're not using sp_executesql correctly. Your invocation of...