Ed Wagner (8/20/2014)

---

Sean Lange (8/20/2014)

---

Are others having problems with SSC today? It seems that almost every topic has some bizarre html comment added to the title. The forums list stops...

cajun_sql (8/20/2014)

---

Sean Lange (8/20/2014)

---

cajun_sql (8/20/2014)

---

Thanks.

Why does the SQL INSERT statement succeed where the Recordset...

Are others having problems with SSC today? It seems that almost every topic has some bizarre html comment added to the title. The forums list stops part way through. The...

It is...

Why not just change your hidden field to be strSP_VersionYear="2014-01-01"? That should work for you.

Let me know if you run into any issues...

dirk.dromgoole (8/20/2014)

---

I have thought about a table valued function or trigger or something like that which will automatically update the date to end of day. The inserts will be...

dirk.dromgoole (8/20/2014)

---

I suppose there are probably better ways to modify the query. Basically, the WHERE clause of the query is:

WHERE (GETDATE() - 1 <= EndDate)

If EndDate has a time...

dirk.dromgoole (8/20/2014)

---

I need to add a check constraint on a field that checks the time of the date to make sure it is 23:59:59.997. When records are inserted the...

Let's start by formatting this sql so we can read it.

SELECT COALESCE(sum(A.AmountGiven), 0) AS AmountGiven

,A.YearToDate

,A.EndDate

FROM (

SELECT (

SELECT SUM(AmountGiven)

FROM [Production].[dbo].[DB1]

WHERE Year(DATE) = Year(Startdate)

AND EmployeeID = rf.EmployeeID

) AS 'AmountGiven'

,(

SELECT MAX(DATE)

FROM [Production].[dbo].[DB1]

) AS...

You're welcome. Hope it makes sense. 🙂

JKSQL (8/19/2014)

---

Yes, you have shown me my question was not clear. The question I have is a CTE would be lighter than a TVP Insert/Delete correct? If so...

JKSQL (8/19/2014)

---

The stored procedure accepts a TVP table as a parameter. Will something like this work?

BEGIN

;with tree(Id) as

(

...

Here is yet another way. I have a view in my system called cteTally. It is nothing but a view that has the numbers 1 - 10,000. Makes this kind...

djj (8/19/2014)

---

Something like:

WITH cte AS (SELECT DogBreed, COUNT(*) as HowMany FROM myTable)

SELECT a.DogBreed, b.HowMany, ROW_NUMBER() (PARTITION BY a.DogBreed ORDER BY a.DogBreed) AS cnt

FROM myTable a

INNER JOIN cte b ON...