Palanivelrajan (6/17/2010)

---

Dear Lawrence Moore,

Let me explain in detail about my requirement.

I want to write a stored procedure which is used by any application

(mostly for help window / Pick...

:hehe:

You connected to your remote linked server from your local management studio ; the query you are executing, will that access data from remote server or your local server ?...

The description of the problem , the tables structure and the desired results are VERY WELL put by you! I have one recommendation though, please go through the following article...

Bull-Eye question ; But a nice starter about DEFAULTS!

This is certainly the correct place to ask this query ; no worries there !

For a first time poster, you have done a commendable job in explaining things, kudos there!

Now...

Fletcher, thanks for posting the data in readily consumable format; Here i am giving u a piece of code that will retreive the dimension values from the "Description" column. Please...

only4mithunc (6/16/2010)

---

You can do it like this

ALTER TABLE tablename ADD columnname AS CASE WHEN Bonus < 100 THEN 'Meager'

WHEN Bonus between 100 and 300 THEN 'Low'

WHEN...

Ah, excellent! 😎

Gianluca Sartori (6/16/2010)

---

ColdCoffee (6/16/2010)

---

Gian, we can write this also like this , right?

select @user-id = USerID

where

firstname = SUBSTRING(@@UserName, 1, CHARINDEX(' ', @@UserName) - 1)

...

Gian, we can write this also like this , right?

select @user-id = USerID

where

firstname = SUBSTRING(@@UserName, 1, CHARINDEX(' ', @@UserName) - 1)

and lastname =...

Fletcher, i know how to go about it ; but, but but, i would like to know HOW your original data looks like and how you want your data to...

lmu92 (6/15/2010)

---

Here's a solution that does all in one path.

However, you need to decide whether you really need the identical output several times just named different (especially the SUM(bibal) stuff)...

Side...

Hi there, please go through the following link ; i guess thats what you wnated exactly

Link : Paging and Versioning Using ROW_NUMBER() - Lawrence Moore

Ah, i was about to post the same code! 🙂