rootfixxxer (4/16/2014)

---

Looking to the things like that, it looks very easy...

But it's not handling the 50% interval duration, neither it's capable of it, for example if i have 1...

Not giving...

Inverse, whatever you want to call it. gbritton basically gave you the answer already. A very minor tweak to his/her...

rootfixxxer (4/16/2014)

---

Yes i need.

I'm currently using/testing in the 2008 version, but i need that the code works in the 2005 version too...

Just posted in this section because i thought...

rash3554 (4/16/2014)

---

insert into empaddr_tobeverified('1','1 main st, salem,pa,USA','JOE STILTON');

insert into empaddr_tobeverified('2','200 Baker st, salem,pa,USA','JIMMY WU');

insert into empaddr_verified('1','1 main st, salem,pa,USA | 100 WHITE Terr, Acton,MA USA',1)

-- means that...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Lynn has a some excellent date routing from his blog. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

I would recommend not using the logic here for LastDayPreviousMonthWithtimeStamp. I assume you are using this in a where clause...

rash3554 (4/16/2014)

---

Hi everyone.

Is it possible to have a procedure like this

create procedure usp_test

(@EMPObj As [testdb].[EMPTBL] Readonly, @ADRObj as [testdb].[AddressTBL] readonly)

-- using cursor I iterate thro table

-- insert into employee select...

rootfixxxer (4/16/2014)

---

Thanks for the replies...

This chunk of code it's a requirement inside a bigger sp, the table it's a table that contains some fields a start date, duration (days), and...

badOedipus (4/15/2014)

---

OK, so I figure I need to use a cursor or some advanced windowing functions, to get what I'm after but I'm not seeing it. Could someone assist?

So...

Are you planning on storing this data in a persistent table? Reason I ask, is the fine solution posted by gbritton1 will not work in all cases. What happens when...

daniness (4/15/2014)

---

Thanks for your input, all. So, I tried using the Group By and Order By at the end of the query, but now it's returning a "Column 'dbo.ACCTING_TRANSACTION_HISTORY.ath_stlmnt_instr_id' is...

Here is my last shot in the dark. This may or may not produce the results you are looking for.

with MySortedRows as

(

SELECT

rsh.Client_ID,

rs.STARTTIME,

rs.OID,

ROW_NUMBER() over (Partition by rsh.ClientID order...

You can read all...

Still nothing solid to work with...why can't you just create ddl and sample data? It isn't that tough.

Is it possibly this simple? You might end up with more than 1...