I'm glad we could help!

Having said that, now that cause of the error has...

I'm going to go out on a limb and guess this is the error you're getting?

If so, then most...

No worries, it's a fairly involved requirement, so...

Not all the other values were repeated. There were also two distinct values for XLO for that LOB

Jacob Wilkins (2/2/2016)

---

...

In the earlier posted results for LOB='MNS', for example, there were...

A little late to the party, but unless I'm missing something (always possible :-))the desired results you gave for J Livingston's sample data seem inconsistent with the desired results from...

DamianC (2/2/2016)

---

Hi

Won't resizing down to 1MB then growing back to 80GB every night slow the process down (especially with 100MB autogrow) and, from what I have read, cause serious fragmentation?

Is...

It's not actually executing the code in that block. The USE statement is checked at compile time (see https://msdn.microsoft.com/en-us/library/ms188366.aspx), so you can't get around this sort of thing with control-of-flow...

I've been through a few considerings. Went to undergrad planning on law school. Then I changed my mind and went to grad school studying formal logic, hoping to be a...

You can nest CASE statements. You only have an END for one of them, though.

Cheers!

EDIT: Heh, looks like this got pounced on before I posted. That's what I get...

abendigeri (1/29/2016)

---

Jacob,

Thanks and appreciate your help.

I have tried with eliminating the REPLACE function, but not much helpful.

Reason behind using REPLACE is Some are capturing Test Date time in different format...

According to the table definition, TestDTTM is already a datetime value, so the lowest-hanging fruit is to change the WHERE clause use the datetime values directly instead of converting to...

sqlnewbie17 (1/27/2016)

---

I can change the errorlog count (to 9)using this

USE [master]

GO

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', REG_DWORD, 9

GO

But how do I read the number of error logs.

I am trying to read...

From https://msdn.microsoft.com/en-us/library/ms186775.aspx, under "Remarks":

For a given identity property with specific seed/increment, the identity...

Hmm...the problem with those last two values is that they can successfully be cast as DATETIME, which is why ISDATE is returning 1 for them. I don't know of any...

If I'm understanding the requirements correctly, this should be a bit simpler than all that. Maybe something like this?

CREATE TABLE #test (UniqID int,

...