Hi David,

how to find count of the records for dates between today()-31 and today()-60?

Actually I am looking for something like "Between" operator in transact query... in short

select count(*) from table where CAST(submitteddate AS DATE) between '2015-02-02' and '2015-01-01'

Not sure if my below code...

Its working 🙂

OK.. my bad.

My earlier query is somethig like this and i want to acomodate maxposteddate in this query:

...

This is what i tried:

Option 1:

SELECT base.*

FROM table base

INNER JOIN (SELECT segment, MAX([PostedDate]) AS Max (PostedDate)

FROM EBBReport

...

both the options are giving syntax error 🙁

I want to grab many of the columns including 'posted D/T' column from this table and i do not want to write individual column name in select query.

It has to...

Thanks for the reply.

What if there are n number of columns n table with ID as primary key?

Select * , MAX[Posted D/T] from MyTable

It is giving me below error:

Column 'MyTable.ID'...

oops ...i framed it wrong.

i need record set based on lateset post D/T

I have limitation not to handle it in front end.

It should be like:

123,456,78

Hi,

I have managed to create below query:

SELECT * From Report WHERE IsCurrent=0 AND (DATEPART(y,EffDate) = DATEPART(y,@EffDate)) AND EffDate > DATEADD(dd, -90, getdate())

Let me know if there is any way to...

Thanks For this.:-)

I have tried one more approach

CREATE TRIGGER [dbo].[TriggerTestforDelete]

ON [dbo].[TriggerTest]

FOR DELETE

AS

DECLARE @ID int

DECLARE @Price money

DECLARE @OldPrice money

DECLARE @NewPrice...

COldCoffee (4/8/2010)

---

You can get all the 4 deleted records. As said by Dave, query the "Deleted" table to get your deleted records..

Here is sample test code

IF OBJECT_ID('TEST') IS NOT NULL

DROP...

Lowell (4/5/2010)

---

that is not true; I can understand how it might...