I guess Paul is asking where is the problem?

I guess your SP needs a bit more work than that, would this help?

--Create the procedure

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[sp_GetMessageCount]

-- Add the parameters for the stored...

Jeff Moden (4/19/2010)

---

No problem....

Kris-155042 (4/18/2010)

---

The data type is bigint and does go down to the seconds. I've run that script and I now get no results.

Sorry to be such a pain but...

Jeff Moden (4/18/2010)

---

Nabha (4/15/2010)

---

Ummmm... I know it's just a guess, Nabha, but the TIMESTAMP data type has absolutely nothing to do with dates or times in SQL Server. The...

I am not completely sure 'bout using timestamp in my solution as my understanding of 'timestamp' on SS2K5 looks wrong. But you have also not mentioned 'how' you are storing...

I am guessing,

wo.COMPLETEDTIME >= Convert(bigint, convert(timestamp, getdate()))

and ofcourse

wo.COMPLETEDTIME < Convert(bigint, convert(timestamp, getdate() + 1))

Have a read for a comprehensive one! 🙂

http://www.sqlservercentral.com/Forums/Topic899000-338-1.aspx

DECLARE @String VARCHAR(8000)

SET @String = '======Heading========== some phrase

===============bottom line==============';

SELECT LTRIM(RTRIM(Replace(Replace(replace

...

:w00t: huh? :hehe: (ODBC yeah?)

Precisely as Graham says, its while building the d-SQL that you are having problems.

Can we see the schema of this table please?

ACCRUAL_SRP.dbo.MEI_AUTOMATION_GOAL

thanks and u r welcome.

Thanks mate.:-)

Thank you 🙂

How about this?

;With CTE as

(Select *, Row_number() OVER (partition by id order by value) as row_no

FROM #rowtrans)

Select ID,

max(CASe when Row_no = 1 THEN value ELSE ''...