Honestly I think you are doing this the hard way. You should not store the total of your cart, you should instead calculate it based on the items in your...

So now do you want to get rid of the cursor?

briancampbellmcad (7/8/2013)

---

Thanks in advance for any help... I am trying to build a query that will have as one of its resulting columns a hyperlink built from a site name...

You have some serious ' mismatches in your where clause.

Try this:

' WHERE ' + @ArchiveSourceDateField + ' <= ''' + cast(datepart(mm, @ArchiveCutOffDate) as varchar) + '/' + cast(datepart(dd, @ArchiveCutOffDate) as...

Take a look at this article. http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D

Make sure you follow the caveats if you decide to use this approach.

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...

Not much in the way of details to work with here. I took a shot in the dark. See if this gets you close.

select * from

(

select ROW_NUMBER() over(partition by...

You probably are not getting any replies because you have the rest of us at an extreme disadvantage here. We can't see your screen and we have no idea what...

What Gail posted will delete all rows from your table variable.

If you want to make your process a lot faster maybe you should consider getting rid of the cursor? Cursors...

Saujib (7/2/2013)

---

thank you very much.

What if, provider and service location address will change per claim.

Or the user while creating the claim should have the ability to modify provider and...

ulisseslourenco (7/2/2013)

---

Sean Lange (7/2/2013)

---

ulisseslourenco (7/2/2013)

---

Thanks for respond me.

I have a question: Is allowed use exec statement into a function? I ask that because I have to return...

So the expiration data in your example would NOT show up because it is further than 120 days. However, the...

Saujib (7/2/2013)

---

let me rephrase my requirement.

User is creating a claim for a patient/member (patient address) and provider is doctor(doctor billing address) and service location (where patient was treated).

address is common...

mcopa (7/2/2013)

---

That was my fear. If you already have code that will do this that would be great!!!! FYI-they don't want to delete/drop anything. They are working...

What an awesome graphic and corresponding article Lowell. That closely mimics my gut feeling about nearly everything I have ever written. I guess that means that on average 45% of...