Good thing I fixed it.. thanks folks.

The problem was the lowest level nesting order wasn't set.

I looked at Azure first but according to this:

http://msdn.microsoft.com/en-us/library/windowsazure/ff394115.aspx

(Summed up...)

The following features that were new to SQL Server 2008 R2 are not supported by Windows Azure SQL Database:

SQL Server Utility

SQL...

SIZE

Specifies the size of the file defined in the <filespec>. When a SIZE parameter is not supplied in the <filespec> for a primary file, SQL Server uses the size of...

I know it's an old post but it's still relevant, I believe.

http://www.dotnetobject.com/Thread-difference-between-latch-and-lock

Hey Chris, does SQL Server consider that type of command a pass-through?

sharonsql2013 (7/8/2013)

---

I have a header table and a reporting table

(In Header table)If the product code selected is "health"

then In reporting table

ID should populate as H1

...

Don't we have to work on the assumption that enddt is never going to be null? If that's the case (no pun intended) then the case statement will return null...

Am I missing something? This seems straight forward...

Case WHEN CONVERT(varchar(8), dischargedate, 112) > CONVERT(varchar(8), enddt,112) OR dischargedate IS NULL THEN CONVERT(varchar(8), enddt, 112)

ELSE CONVERT(varchar(8), dischargedate, 112)

END AS dd...

Nevermind. I misread the post. 🙂

I think Alan and I had the same idea but he's just a little quicker on the keyboard. 🙂

select *

from

(

select tablename, avg(datediff(ms,starttime,endtime)) over (partition by tablename) averageMS from timetest...

Always a good thing...

Something like this might get you started:

declare @strSQL as varchar(max)

set @strsql = (select 'select COL1_D as ' + col1_h +

', COL2_D as ' + col2_h +

', COL3_D as '...

edited

Thanks, Sean..

I can use them to generate 20,000 9 digit numbers too...

select * from (values ('4'),('5'),('6')) as Ssn(dig)

cross apply

(select * from (values ('1'),('2'),('3')) as Ssn(dig))...

You're also going to need a reference (either for yourself but definitely for us) of what actual dates fall into which trnMonths and trnYears. We don't have a way to...