That's a very unambiguous message. What do you not understand about it? What statement are you running to get the error?

John

Why are you creating the table at runtime? Does it change from one run to the next? Indexes will slow down inserts, yes, although not necessarily by a...

Yes, you'd need to use dynamic SQL, something like this:

DECLARE @sql nvarchar(200)

SET @sql = N'Select * from #emps Where EN IN (' + @names + N')'

EXEC sp_executesql @sql

John

Careful, Chris. That doesn't work if you use values explicitly defined as time.

DECLARE @TimeTable table (StartTime time, EndTime time)

INSERT INTO @TimeTable

SELECT * FROM (VALUES

('09:00', '17:00'),

('09:00', '15:00'),

('09:30', '17:30'),

('12:00', '17:00'),

('13:00',...

Ooh yes, I take it back. I assumed it would be available in BI Edition also, but it isn't.

John

OK, the simplest way would be to do the calculation as normal, and use your CASE expression to test whether start is greater than end. If it is, then...

Start by looking up the syntax for RESTORE DATABASE. But what do you mean by "secondary server which is located in main server"?

John

Sounds like you need a CASE expression, although you don't give many details. What are your expected results?

John

Mirroring is deprecated. You should use AlwaysOn Availability Groups if you're upgrading to SQL Server 2012 or later.

John

The quickest way to find out is to type DATEDIFF into your favourite search engine. Yes, it works with the time data type. Here's an example; I'll leave...

Have you looked at the DATEDIFF function?

John

Damian

The "?" placeholder isn't used by all providers. Check your connection manager to see what provider you're using to connect to the database, then check the documentation to see...

Kim Crosser (12/8/2015)

---

In similar situations, I found the following to work pretty well:

SELECT PatientID, ...

from dbo.MDTest tbl1

where tbl1.IndexEndDate > @dParamDate

and not exists (select 1

from dbo.MDTest tbl2

...

That doesn't return the result set that the OP requires. He appears to want the cumulative count to show 0 unless there is actually a value in the corresponding...

SELECT

IndividualDate

,ClosedDate

,OpenDate

,CASE

WHEN ClosedDate IS NULL THEN 0

ELSE COUNT(ClosedDate) OVER (ORDER BY IndividualDate ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

END AS CumClosedDate

,CASE

WHEN OpenDate IS NULL THEN 0

ELSE COUNT(OpenDate) OVER (ORDER BY...