Johnny B (2/8/2016)

---

Hi, I've worked on this for an hour or so... I'm not that good I think.

Date ...

There are so...

What kind of help do you need?

You're just sending a value that is not a valid date. If you're not sending the values with ISO format

(YYYYMMDD for dates YYYY-MM-DDThh:mi:ss.mssss for...

Why are we making it complicated?

SELECT TOP(1) WITH TIES

d.state,

vs.modelID As Model,

SUM(vs.totalSalesCount) As TotalCarsSold

FROM Dealerships d

inner join...

mw112009 (2/5/2016)

---

The output that I want is listed at the very end.

Can someone help me with a single SQL statement.

I don't mind using one or 2 CTEs ( Common Table...

curious_sqldba (2/5/2016)

---

I have a stored procedure which takes varchar type variable as an input, the variable should be able to loop through multiple values and execute for each value in...

I believe that you're looking for something like this:

=Avg(IIF(Fields!PrimaryGroup.Value = "Caims" AND Fields!Section.Value = "Dental",Fields!Payments.Value,Nothing))

ThomasRushton (2/5/2016)

---

Let's see... ...

Miami

This is basically your code, I just corrected the variable declaration and added the stored procedure DDL. It works as it is.

If it doesn't work, make sure that you're using...

What have you tried?

Michael L John (2/4/2016)

---

Grumpy DBA (2/4/2016)

---

Michael L John (2/4/2016)

---

GilaMonster (2/4/2016)

---

jasona.work (2/4/2016)

---

Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important...

You know the deal. Post DDL, sample data as INSERT statements and expected results based on that sample data.

Snow cone

Eric M Russell (2/4/2016)

---

TRY_CONVERT() is also useful for check constraints. For example, below we are requiring that "date" values stored in a VarChar column called FooDate can be casted as...