Lynn Pettis (5/9/2012)

---

Putts (5/9/2012)

---

GilaMonster (5/9/2012)

---

Not at all. The only time that a procedure will need...

Okay, I know that there was a recent forum thread about upper and lower case keywords. The last post had a link to a site that could format sql...

Putts (5/9/2012)

---

GilaMonster (5/9/2012)

---

Not at all. The only time that a procedure will need refreshing if...

Sean Lange (5/9/2012)

---

WayneS (5/9/2012)

---

capn.hector (5/9/2012)

---

Lynn Pettis (5/9/2012)

---

riya_dave (5/9/2012)

---

hi

i have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it takes more...

Really not enough information to give a solid answer. The code itself, it could easily be vulnerable. The real question that we can't answer is if the vendor...

Not sure. We can't see what you see. Really need more information to give you an real answer.

Well, I'd have to touch stored procedures as I don't like using SELECT * in my code.

Here is what I would be concerned about, what if a developer, while making...

Check here: http://msdn.microsoft.com/en-us/library/ms162820(v=sql.100).aspx

My question is why are you looking at moving from views to table valued functions.

What is the business case for the move.

riya_dave (5/9/2012)

---

hi

i have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it takes more time than cursor.

I am calling 5-6...

It really comes down to what you want to do career wise and if the less money is doable for you at this time.

The BI position looks like it may...

Steve Jones - SSC Editor (5/9/2012)

---

WayneS (5/9/2012)

---

First of all, congrats to both of you for working together for this goal.

But secondly.... seriously? fun working in the barn? mucking it...

This:

select convert(varchar(2), month(getdate())) + '/' + convert(varchar(2), day(getdate())) + '/' + RIGHT(DATENAME(yy,GETDATE()),2);

Still waiting for you to post the DDL (CREATE TABLE statement) for the table(s) involved in your query along with the indexes defined on the tables. Could also use...

Congratulations and best of luck to your wife on...