It looks like you need

SELECT IDENT_CURRENT('dbo.tablename')

rather than IDENT_SEED.

You need to be more selective than that. Any reference to the column will turn the "UPDATE flag" on, even if the value is the same. Maybe something...

myzus2004 (10/3/2015)

---

Thanks scott for your feedback. Appreciate it .

The clustered index on InformationOverride table cannnot be changed as the composite index on these 3 columns have unique data.

I am...

I think this might do it, if I understand correctly what you need:

SELECT cast(0 as bit) as 'Escolha',data, contado , ollocal ,origem, ousrdata,ousrhora

...

Can we see the actual code you used to do the split and column assignment? Maybe there is something there.

You can check to see if the cursor exists before you DECLARE it. I added "LOCAL" to the cursor declaration so that you know for sure that it's local...

Sounds like you need a really fast splitter. Check out DelimitedSplit8K.

Might a job have run and hit that db but using a different user?

Lynn Pettis (10/1/2015)

---

ScottPletcher (10/1/2015)

---

You should get rid of the INSULL() in the WHERE clause, as always. Just NEVER use ISNULL() in a WHERE or JOIN. But it's esp....

You should get rid of the INSULL() in the WHERE clause, as always. Just NEVER use ISNULL() in a WHERE or JOIN. But it's esp. important if that...

No, you can't use EXISTS to return data.

As to performance, the non-clustered index on the vcv (InformationOverride) table would have to INCLUDE the vote column to be useful.

Better would very...

You could put values into a table and do a lookup.

You could also use a CROSS APPLY to assign an alias name to the result of the first CASE statement,...

I wondered about that too, but I noticed there's an odd character before "wrap" that looks like a blank, but really isn't. When you copy it in the SSMS...

Here's the code if a month's weeks start in the prior month:

SELECT

WeekStartDate,

WeekEndDate,

LEFT(DATENAME(MONTH, WeekEndDate), 3) + '_Week' +...

The WeekName logic contradicts itself. If:

8/30/2015 9/5/2015 = Sep_Week1

then shouldn't:

9/27/2015 10/3/2015 = Oct_Week1 rather than "Sep_Week5"

It's impossible for that week to be both Sep_Week5 and Oct_Week1 ... or...