Based on the limited information you've provided I have no idea what you really need for output as the new query you've provided with the UNION doesn't makes sense to...

I doubt this is exactly what you are looking for, but I think it'll get you moving it the right direction.

USE test;

GO

DECLARE @workers TABLE

(

...

mcfarlandparkway (4/30/2014)

---

Thank you for the reply tried your sql code the problem is that the amounts are varying in free column and dollars column?

Before that in free column for particular...

I don't know of a way to remove the "+" when you set a toggle item, but you can use an expression in the hidden property of the items being...

You need to convert your Month and Year to strings in order for the "+" to be concatenation and not addition and you can't add a string and integers.

You can...

Based on the information you have provided I would do this:

SELECT

SCH.SystemID,

SCH.ProgramID,

SS.SystemName,

CASE WHEN SCH.ProgramName =...

As Sean has said it would be much easier to provide a workable answer with additional information.

Here's an idea on how to do it (I have no way of knowing...

I think joining to a date table would probably be the easiest way to solve the problem.

A couple of questions:

What do you mean by retired time?

Is the end date considered...

Good opening article and I look forward to the rest of the stairway. I'm in the process of trying to get my current workplace to get databases in to...

gbritton1 (4/17/2014)

---

Something to consider:

select datediff(m, '0001-01-01', '9999-12-31')

returns 119987

That is the largest difference in minutes between the earliest and latest dates handled by SQL Server. The earliest date it can...

I'd probably handle this by making the query for Select Employee From List Parameter an expression something like this:

=IF(Parameters!EmployeeID.Value = String.Empty, "Select ID, Name From dbo.Employee where Name Like '%'"...

What is the base date? 1900-01-01, 1970-01-01. The basic idea is:

DATEADD(Minute, Integer, BaseDate)

SQLBill (4/8/2014)

---

Ville-Pekka Vahteala (4/8/2014)

---

SQLBill (4/8/2014)

---

Jack Corbett (4/6/2014)

---

So on Thursday I was asked to help analyze a batch process for a third-party product that originally took 2 hours and...

So on Thursday I was asked to help analyze a batch process for a third-party product that originally took 2 hours and is now 19+ hour process that sometimes fails....

Andrew,

Here's my explanation for pluralization. Because the table doesn't contain a car it contains cars. The row is a car the table is a set of cars. ...