Eric M Russell (6/13/2016)

---

Consider something like this instead:

UPDATE SomeTable

SET SomeText = @SomeText

WHERE WHERE ID = @ID;

IF @@ROWCOUNT = 0

...

Group of indexes merged into a cluster?

Correct?

colin.frame (6/8/2016)

---

This logic doesn't quite match what's given - the pm.pdenddate=pt.pdenddate part excludes all lines where one side only of...

Here is the...

1. SQL 2000

2. Topic from 2007.

which change is presented by these 2 rows:

23

22

3 --> 2 or 2 --> 3?

Yes, of course.

It's pretty much Numbers table, but instead of numbers it contains dates:

Select DATEADD (dd, Number, 0)

From Tally

Where Number < 256*256

It will cover full range of SMALLDATETIME dates

You can even have a query for all the dates ever:

SELECT DATENAME(MONTH, MonthStart) + ' ' + DATENAME(YY, DT.MonthStart) ReportMonth,

WeekNo, MIN(Date) FromDate, MAX(Date) ToDate

FROM (

SELECT DATEADD(mm, DATEDIFF(mm, 0, bc.Date),...

DiabloSlayer (6/13/2016)

---

Hi Sergiy,

In this case, it would be like the following:

STARTDATE ENDDATE ...

DiabloSlayer (6/13/2016)

If we chose 6/1 as the Start Date which is Wednesday then it goes from 6/1 to 6/7 etc. whereas it should go from Wednesday till Saturday (6/1 to...

Use temp table instead.

#Table created in outer query is available within the scope of your dynamic SQL.

You may simply remove the table parameter then.

It's much better way to pass tables...

Man, I can only say - you're dealing with some seriously screwed people. 🙂

Of course, I cannot know how you define the atmosphere on your interviews, how do you recognise...

krypto69 (6/2/2016)

---

Agreed Jeff.

The trigger(s) caused a huge series of updates to several tables, logging, auditing, etc.

This was a one time update. We are a really busy shop..so 30G...

stricknyn (6/10/2016)

---

Hi Drew,

Thanks for your response. Unfortunately no. The other process is designed that way because there are other processes (much like this stored procedure) that will be...

Jeff Moden (6/10/2016)

---

And, remember, the first question is always "How do you get the current date and time using T-SQL?" whether it's for a DBA or an Developer...