using COALEASE in t-sql

So, you have text you want to select for all the rows of a table, almost similar to AVG function for numbers

Here is the solution I found, thanks Viper

DECLARE @AllNotes varchar(4000)

SELECT @AllNotes = COALESCE(@AllNotes + ', ', '') + (Notes + ' (added by ' + addedby + ')')

FROM   Ranking

WHERE  scholarshipID=52

PRINT @AllNotes

ASP.net 2.0 memberships issue

I was trying to install and run the memberships and roles DB from asp.net 2.0 and had the following error show up repeatedly

An error was encountered. Please return to the previous page and try again.

The following message may help in diagnosing the problem: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 5110 and the SqlException message is: The file "S:\APP_DATA\ASPNETDB_TMP.MDF" is on a network path that is not supported for database files. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Creating the ASPNETDB_1735c56c9fbe43928ee626f81923d937 database... at System.Web.Administration.WebAdminPage.CallWebAdminHelperMethod(Boolean isMembership, String methodName, Object[] parameters, Type[] paramTypes) at ASP.security_users_adduser_aspx.PopulateCheckboxes() in c:\Windows\Microsoft.NET\Framework\v2.0.50727\ASP.NETWebAdminFiles\Security\Users\addUser.aspx:line 28 at ASP.security_users_adduser_aspx.Page_Load() in c:\Windows\Microsoft.NET\Framework\v2.0.50727\ASP.NETWebAdminFiles\Security\Users\addUser.aspx:line 22 at System.Web.Util.CalliHelper.ArglessFunctionCaller(IntPtr fp, Object o) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

So, after hours of research and tonnes of googling, here is what resolved my issues

My web.config has following setup now

If you do this the SqlRoleProvider will be lost and cannot connect to the database. If you did this you have to supply a cutom role provider thru your web.config like this one,

< enabled="true" defaultprovider="CustomizedRoleProvider">
     <>
        < add name="CustomizedRoleProvider"
             type="System.Web.Security.SqlRoleProvider"
             connectionStringName="AnotherLocalServer" / >
     < /providers >
< /roleManager >

dekh lo Khvaab magar Khvaab kaa charchaa na karo

dekh lo Khvaab magar Khvaab kaa charchaa na karo
log jal jaayenge suuraj kii tamannaa na karo

vaqt kaa kyaa hai kisii pal bhii badal sakataa hai
ho sake tum se to tum mujh pe bharosaa na karo

kirchiyaan TuuTe hue aks kii chubh jaayengii
aur kuchh roz abhii aaiinaa dekhaa na karo

[aks = reflection]

ajnabii lagne lage Khud tumhen apnaa hii vajuud
apne din raat ko itnaa bhii akelaa na karo

Khvaab bachchon ke khilaunon kii tarah hote hain
Khvaab dekhaa na karo Khvaab dikhaayaa na karo

be-Khayaalii men kabhii uNgaliyaa.N jal jaayengii
raakh guzare hue lamhon kii kuredaa na karo

mom ke rishte hain garmii se pighal jaayenge
dhuup ke shahar men "Aazer ye tamaashaa na karo

इक इंतज़ार सा था अब नज़र में वो भी नहीं

इक इंतज़ार सा था अब नज़र में वो भी नहीं
सफर में मरने की फुर्सत थी घर में वो भी नहीं

ज़रा मलाल की ज़ुल्मत को टालने के लिए
कई ख़याल थे अब तो असर में वो भी नहीं

[malaal = sorrow/anguish; zulmat = darkness; asar = effect]

जो संग -ओ -खार थे मेरी ही गर्दिशों तक थे
मैं रह -गुज़र में नहीं रह -गुज़र में वो भी नहीं
[sang = stone; Khaar = thorn]

थे चश्म -ऐ -बाम नगर में अजब तुलू के रंग
वो इक निशात -ऐ -सहर था सहर में वो भी नहीं
[tuluu = dawn; nishaat-e-subah = happiness of dawn]

रहे न कुछ भी मगर ये कैफ क्या कम है
जिस आगही की कमी थी हुनर men वो भी नहीं
[kaif = intoxication; aagahii = forewarning; hunar = skill]

Apne man mein hi achanak yun safal ho jayenge

Apne man mein hi achanak yun safal ho jayenge
Kya khabar thi aapse milkar hum gazal ho jayenge
Yeh kise maloom tha woh waqt bhi aa jaayega
Ki aap meri zindagi ke rashifal ho jayenge
bhor ki pahli kiran ki tarah ek baar hum ko dekh lo
hum bhi khil kar muskura kar ek kamal ho jayenge

shayari

http://www.funonthenet.in/component/option,com_smf/Itemid,36/action,profile/u,29683/sa,showTopics/start,40

Office is fun sometimes !!

I now know why people hate me...

Jason: I am going to Vaccuum my cubicle
Me: I will too

Abhi's Messanger Status - My cubicle is clean
Jason's Messanger Status - My cubicle is cleaner
Abhi's Messanger Status - Jason is a show-off
Jason's Messanger Status - Abhi's just jealous
Abhi's Messanger Status - its not jealousy its the fact
Jason's Messanger Status - Abhi's new name is stretch

So, thats when I walked to his cubicle and sprayed him with sarah jessica parker brand perfume....

Now..
Abhi's Messanger Status - Jason smells really nice
Jason's Messanger Status - Please join "I hate Abhi" club

diiwaanaa banaanaa hai to diiwaanaa banaa de

diiwaanaa banaanaa hai to diiwaanaa banaa de
warnaa kahii.n taqdiir tamaashaa na banaa de

aye dekhanewaalo.n mujhe ha.Ns ha.Ns ke na dekho
tum ko bhii mohabbat kahii.n mujh saa na banaa de

mai.n Dhuu.NDh rahaa huu.N merii wo shammaa kahaa.N hai
jo bazm kii har chiiz ko parwaanaa banaa de

aakhir koii suurat bhii to ho Khaanaa-e-dil kii
Kaabaa nahii.n banataa hai to but_Khaanaa banaa de

"Behzad" har ek jaam pe ek sajdaa-e-mastii
har zarre ko sang-e-dar-e-jaanaa.N naa banaa de

dukh fasaanaa nahii.n ke tujh se kahe.n

dukh fasaanaa nahii.n ke tujh se kahe.n
dil bhii maanaa nahii.n ke tujh se kahe.n

aaj tak apanii bekalii kaa sabab
Khud bhii jaanaa nahii.n ke tujh se kahe.n

ek tuu harf_aashnaa thaa magar
ab zamaanaa nahii.n ke tujh se kahe.n

be-tarah dil hai aur tujh se
dostaanaa nahii.n ke tujh se kahe.n

ai Khudaa dard-e-dil hai baKhshish-e-dost
aab-o-daanaa nahii.n ke tujh se kahe.n

tumhaarii anjuman se uTh ke diivaane kahaa.N jaate

tumhaarii anjuman se uTh ke diivaane kahaa.N jaate
jo vaabastaa hue tum se vo afasaane kahaa.N jaate

[anjuman = gathering; vaabastaa = related; afasaane = tales]

nikal kar dair-o-kaabaa se agar milataa na maiKhaanaa
to Thukaraaye hue insaa.N Khudaa jaane kahaa.N jaate

[dair = temple]

tumhaarii beruKhii ne laaj rakh lii baadaaKhaane kii
tum aa.Nkho.n se pilaa dete to paimaane kahaa.N jaate

[baadaaKhaanaa = tavern/pub]

chalo achchhaa huaa kaam aa ga_ii diivaanagii apanii
vagarnaa ham zamaane bhar ko samajhaane kahaa.N jaate

'Qateel' apanaa muqaddar Gam se begaanaa agar hotaa
phir to apane-paraaye ham se pahachaane kahaa.N jaate

patthar ke jigar vaalo.n Gam me.n vo ravaanii hai

patthar ke jigar vaalo.n Gam me.n vo ravaanii hai
Khud raah banaa legaa bahataa huaa paanii hai
phuulo.n me.n Gazal rakhanaa ye raat kii raanii hai
is me.n terii zulfo.n kii be-rabt kahaanii hai

[berabt=incongruous/not connected]

ek zahan-e-parenshaa.N me.n vo phuul saa cheharaa hai
patthar kii hifaazat me.n shiishe kii javaanii hai

[zahan=mind; pareshaa.N=troubled; hifaazat=protection]

kyo.n chaa.Ndanii raato.n me.n dariyaa pe nahaate ho
soye hue paanii me.n kyaa aag lagaanii hai
is hausalaa-e-dil par ham ne bhii kafan pahanaa
ha.Ns kar koii puuchhegaa kyaa jaan gavaanii hai

[hausalaa=courage; kafan=shroud; gavaanaa=to lose]

rone kaa asar dil par rah rah ke badalataa hai
aa.Nsuu kabhii shiishaa hai aa.Nsuu kabhii paanii hai
ye shabanamii lahajaa hai aahistaa Gazal pa.Dhanaa
titalii kii kahaanii hai phuulo.n kii zabaanii hai

[lahajaa=style; titalii=butterfly]

milta nahi koi shabd teri taareef ko

milta nahi koi shabd teri taareef ko
shayad ab nayi jubaan banani hogi
zameen par mumkin toh hogi nahi
farishton sey seekh kar aani hogi

*************************************************************
Baat sey baat banane ka, yeh andaaz kya achcha hai
phir chup sey muskane ka, yeh andaaz kya achcha hai ?

din bhar intezaar karao, yeh hame takleef nahi
khwaabon mai bhi satane ka, yeh andaaz kya achcha hai ?

doston sey kahtey ho key tum mere deewaney ho
par mujhsey yeh baat chupane ka, yeh andaaz kya achcha hai ?

kabhi toh aisa ho key tum bas hamse milne aa jao
sabsey dil milane ka, yeh andaaz kya achcha hai ?
*************************************************************
Dil Mein Naa ho Himmat, Tou Mohabbat nahiin miltee...
Khairaat mein itanii badee daulat nahiin miltee !!!

Kuchh log yuun hii, Shahar mein ham se bhii Khafaa hain,
Har ek se apanii bhii, tabiiyat nahin miltii, !!!

Dekhaa thaa jise maine, Koi aur thaa shaayad
Voh kaun hai jis se, terii surat nahiin miltii, !!!

Hanste huye cheharon se, Hai Duniya kii Zeenat,
Rone ko yahaan vaise bhii, Fursat nahiin miltee !
*************************************************************
Agar mai baat badal doo toh !!

Dost banogey tum mere kya
gar haalat badal doon toh
sun logey kya tum mujhko
gar mai baat badal doon toh

Pal tum bin hote hai mushkil
umr guzartey saal lagengey
kitna aasaan hoga mera jeena
gar jazbaat badal doon toh
gar mai baat badal doon toh

Naam tumhara likha tha dil par
aansoo aa kar mita gaye hai
khelogey kya phir iss dil sey
gar mai shah aur maat badal doon toh
gar mai baat badal doon toh

*************************************************************
chehrey pe mere zulf ko pheelao kisi din...kia rooz gharajtey ho baras jaoo kisi din!
mein apni her ik sans us rat ko dey don....ser rakh k seeney pe sooo jaoo kisi din!
*************************************************************
Kabhi Kuch Hay Kabhi Kuch Nahin

Kabhi kabhi mujhe najaney kyun
lagte ho tum ajnabeee

ajab sa hai
mere tumhare beech
kabhi kuch haiii...kabhi nahiin..

kabhi itne kareeb ke jall jayeiin
to kabhi itne hoo duur
kee aankheiin taras jayeiin..

Kabhi kabhi mujhe najaney kyun
lagte ho tum ajnabeee

mein samandar mein hooonn
kinaraaa dooo
saath chalna haii too
koiii too isharaa doo..

Kabhi kabhi mujhe najaney kyun
lagte ho tum ajnabeee

ajab sa hai
mere tumhare beech
kabhi kuch haiii...kabhi nahiin..

kabhi sub kuch haiii...kabhi kuch bhi nahiin..

ajab sa hai mere tumhare beech

*************************************************************
Pyar Kay Deep Jalany Walay,,
Kuch Kuch Pagal Hotay hain,,

Apni Jaan Se Janay Walay,,
Kuch Kuch Pagal Hotay hain,,


Jaan Se Pyare Logoon Se Bhi,,
Kuch Kuch Perda Lazim hai,,

Sari Baat Batanay Walay,,
Kuch Kuch Pagal hotay Hain,,,

*************************************************************
woh jo geet tum nay suna nahi meri umar bhar ka riaz tha
mere dard ki thee woh dastaan jisay tum hasi main ura gaye
Kitabon Say Daleelain Doon Ya Dil Ko Samney Rakhun
Woh Mujh Say Pooch Baithay Hain Mohabat Kis Ko Kehtay Hain
*************************************************************
socha karta tha aksar mai tumko kya likhu'
dil likhu ya mai tumko apni jaa likhu
insaa ko insaa toh likhte hai saare
aaj aao mai tumhe apna khuda likhu
suna hai mil kar tum bhool jaati ho
phir mujhey hi kyu itna yaad aati ho
yaad dilane tumhe meri
mai aaj apna naam pata likhu
yeh ajeeb see jo shaam hai
ussey kaisey akele bitao mai
tu ijazat dey agar
mai tujhey hi bas yaad kiya karu
sochta hu tujhey mai khuda likhu
iss zindagi key safar mai
koi aayega koi jayega
chaah bas ab itni hai
tujhey apna mai hamsafar rakhu
tujhey aaj mai apna khuda likhu
*************************************************************
aisaa lagataa hai zindagii tum ho
ajanabii jaise ajanabii tum ho


ab ko_ii aarazuu nahii.n baakii
justajuu merii aaKhirii tum ho


mai.n zamii.n par ghanaa a.Ndheraa huu.N
aasamaano.n kii chaa.Ndanii tum ho

*************************************************************
log dil vaalon ki baat khoob samajhate hongey
chand kahate hai kisse Khoob samajhate hongey

itni milatii hai mere shero se surat teri
log tujhako meraa mahaboob samajhate honge

mai samajhataa tha muhabbat kii zabaan Khushbu hai
phool se log ise Khoob samajhate honge

bhul kar apanaa zamaanaa ye zamaane vaale
aaj ke pyaar ko khoob samajhate ho.nge

*************************************************************
Mujhay ik baat kehni thi ,, tumhein itna batana tha
k meri zindagi ho tum ,,

Tumhein he sochta hon mein


Buhat masrof rehta hon ,, buhat say kaam hain mujh ko
magar tum say nahin ghafil ,,

Tumhein he sochta hon mein


Buhat say log miltay thay ,, magar jab say tumhein dekha
na janay kia howa mujh ko ,,

Tumhein he soochta hon mein


Mujhay auroon say kia lena ,, mera logon say kia rishta
meri dunya ho tum hi tum ,,

Tumhein he soochta hoon mein


Nigahoon mein basi ho tum ,, khayaloon mein samai ho
sukoon-e-dil ho tum mera ,,

Tumhein he soochta hoon mein

Buhat mushkil hai ye jeena ,, tumharay bin mera rehna
k meri saans mein ho tum ,,

Tumhein he sochta hon mein


Kabhi tanhai main betho ,, agar tanhai mein tum ho
tou itna yaad ker laina ,,

Tumhein he soochta hoon mein
*************************************************************
Ankhon main raha dil main uter k nahe dekha..
kashti k musafir ne kabhi samunder nahe dekha...
Pathar mujhe kehta hai meray chahney waala...

Main moom hon us ne mujhe chu k nahe dekha..
*************************************************************
dil ki chokhat pe jo ik deep jala rakha hai...tere loat aney ka imkan saja rakha hai...
sans bhi nahi letey thumein sochtey waqat...is kkam ko bhi hum ney kal per utha rakha hai...
rooth jatey ho to kuch or hi haseen lagtey ho..hum ney yeh soch k tum ko khafa rakha hai..
rota huwa choor gaye they ik din..hum ney us sham ko seeney se laga rakha hai..
chan nahi deta kisi bhi terhan mujhey..teri yadon ney jo tufan utha rakha hai
*************************************************************

Haal Dukh Dega to Maazi Pe Nazar jaayegi

Haal Dukh Dega to Maazi Pe Nazar jaayegi
Zindagi Haadsa Ban Ban ker Guzer jaayegi

Tum Kisi Rah Se Aawaz Na Dena Mujh ko
Zindagi itne Sahare Pe Thahar jaayegi

Tere Chehre Ki Udaasi Pe Hai Duniya Ki Nazar
Mere Haalat pe Ab Kis Ki Nazar jaayegi

Tum jo ye Mashwara-e-Tark-e-Wafa Dete Ho
Umr Ek Raat Nahi Hai jo Guzar jaayegi

tum khwaab jalaty rahy ham aaj tak chup thy

tum khwaab jalaty rahy ham aaj tak chup thy
ab dil k yoon jalny par sabar kar nahi sakty


yeh aankh andheroon main hoi pyaas ka sehra
is noor k darya par nazar kar nahi sakty


har chand k meri aankh main aansoo hain larazty
jalty hoy sholay es par asar kar nahi sakty


ab chahin bandh lain gay tumhin apni nazar say
ham is liye khuda say khafa ho nahi sakty

Mare Sabar Ka Na Lay Imtihaan,

Mare Sabar Ka Na Lay Imtihaan,
Mare Khaamoshi Ko Sadaa Na Day,
Jo Tare Baghair Na Jee Sake,
Use Jeene Ki To Duaa Na Day,

To Azeez Dill-o-nazar Se Hai,
To Qareeb Rag-o-jaan Sai Hai
Mare Jism-o-jaan Ka Yeh Faasla,
Kaheen Waqt Aur Barhaa Na Day,

Tujhe Bhool Ke Na Bhulaa Sakoon,
Tujhe Chah Ke Bhi Na Paa Sakoon,
Meri Hasratoon Ko Shumaar Kar,
Meri Chahatoon Ka Silaa Na Day,

Abhilasha Sharma says:
Wo Tarap Jo Shula-e-jaan Main Thi,
Mere Tan Badan Se Lipat Gayi,
Jo Bujha Sake To Bujha esey,
Na Bujhaa Sake To Hawaa Na De,

Tujhe Agar Milein Kabhi Fursatein,
Mere Shaam Phir Se Sanwaar Day,
Agar Qatal Karna Hai To Qatal Kar ,
Yoon Judaaiyoon Ki Sazaa Na Day,

अब तो मज़हब कोई ऐसा भी चलाया जाए

अब तो मज़हब कोई ऐसा भी चलाया जाए
जिसमे इंसान को इंसान बनाया जाए

आग बहती है यहाँ गंगा में झेलम में भी
कोई बतलाये कहाँ जा के नहाया जाए

मेरा मकसद है महफ़िल रहे रोशन यूँ ही
खून चाहे मेरा दीपो में जलाया जाए

मेरे दुःख दर्द का तुझ पर हो असर कुछ ऐसा
में कहूँ खा और तुझसे भी न खाया जाए

जिस्म दो हो के भी दिल हो एक अपने ऐसे
मेरा आंसू तेरी आँखों से उठाया जाए

गीत गुमसुम है ग़ज़ल चुप है रुबाई है दुखी
ऐसे माहोल में नीरज को बुलाया जाया

चमन को देख धूल पात न देख

चमन को देख धूल पात न देख
खिलाडी पहचान सिर्फ़ बिसात न देख
मेरी डोली की गरीबी को हसने वाले
मेरी दुल्हन को देख लौटती बरात न देख

haadase kyaa kyaa tumhaarii beruKhii se ho gaye

haadase kyaa kyaa tumhaarii beruKhii se ho gaye
saarii duniyaa ke liye ham ajanabii se ho gaye

[haadasaa=incident]

gardish-e-dauraa.N, zamaane kii nazar, aa.Nkho.n kii niind
kitane dushman ek rasm-e-dostii se ho gaye

[gardish-e-dauraa.N=passage of time]

kuchh tumhaarii gesuuo.n kii barahamii ne kar diyaa
kuchh a.Ndhere mere ghar me.n raushanii se ho gaye

[gesuu=hair; barahamii=scattering]

yuu.N to ham aagaah the saiyaad kii tadbiir se
ham asiir-e-daam-e-gul apanii Khudii se ho gaye

[aagaah=alert; saiyaad=hunter; tadbiir=plans]
[asiir=prisoner; Khudii=own ego]

har qadam "Sagar" nazar aane lagii hai.n ma.nzile.n
marhale tay merii kuchh aavaaragii se ho gaye

[marhale=destinations; aavaaragii=wanderlust]

सदमा तो है मुझे भी की तुझसे जुदा हूँ मैं

सदमा तो है मुझे भी की तुझसे जुदा हूँ मैं
लेकिन ये सोचता हूँ की अब तेरा क्या हूँ मैं

बिखरा पडा है मेरे ही घर में तेरा वजूद
बेकार महफिलों में तुझे ढूण्ढता हूँ मैं

मैं खुदकशी के जुर्म का करता हूँ ऐतराफ़ (I agree with the crime of suicide)
अपने बदन की कब्र में कबसे गडा हूँ मैं

किस -किसका नाम लूँ ज़बान पर की तेरे साथ
हर रोज़ एक शख्स नया देखता हूँ मैं

ना जाने किस अदा से लिया तूने मेरा नाम
दुनिया समझ रही है के सब कुछ तेरा हूँ मैं

ले मेरे तजुर्बों से सबक ऐ मेरे रकीब
दो चार साल उम्र में तुझसे बड़ा हूँ मैं

जागा हुआ ज़मीर वो आईना है "क़तील"
सोने से पहले रोज़ जिसे देखता हूँ मैं

mushkil kitna mushkil hai tera intezaar

aankho mai neend na dil mai karaar
mushkil kitna mushkil hai tera intezaar
pal mai dil roye pal mai bekaraar
mushkil kitna mushkil hai tera intezaar


karu kuch mai hota hai kuch aur hi
lagta hai tum ho..par tum ho nahi
kaisa ajab sa yeh chaaya khumaar
mushkil kitna mushkil hai tera intezaar

khidki se dekhu darwaazie par jaaon
phir saare ghar mai mai chakkar lagaon
rasta mai dekhu tera baar baar
mushkil kitna mushkil hai tera intezaar

saanon mai khushboo aur nazar mai hai surat
mujhe bas teri ab teri hai zarurat
tu hi hai mera ab toh solah singaar
mushkil kitna mushkil hai tera intezaar