Author |
Topic |
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-07-03 : 06:19:31
|
Bye bye(6.32pm)...off for 2 day with salaryGOOD LUCK TO ALL WHO FACED PROBLEM!AMITOFO+AMEN+YA ALLAH Hope the query works |
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-03 : 06:33:31
|
enjoy the weekend............ |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-03 : 07:11:08
|
waterduck is starting into weekend...Have a nice weekend and beware of waterduck hunters! No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-03 : 09:29:05
|
LOL Hopefully he will be back next week. Is it duck season ? KH[spoiler]Time is always against us[/spoiler] |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-03 : 09:46:05
|
ok bye guys happy weekend.....Your time is a valuable resource. |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-07-05 : 20:57:49
|
hahaha...back to work...khtan you free? got thing don't understand...AMITOFO+AMEN+YA ALLAH Hope the query works |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-05 : 21:11:54
|
just post your question as a new thread. KH[spoiler]Time is always against us[/spoiler] |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-07-05 : 21:17:48
|
posted AMITOFO+AMEN+YA ALLAH Hope the query works |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-07-06 : 16:24:42
|
quote: Originally posted by khtan LOL Hopefully he will be back next week. Is it duck season ? KH[spoiler]Time is always against us[/spoiler]
Not where I'm at but give it a couple of months - (later this year around October through December). Remember, the only good duck is a dead duck, braised in butter, breast-side down with some onion, celery, carrot, maybe some potato, bay-leaves, garlic....don't get me started! Terry-- Procrastinate now! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-06 : 18:15:19
|
stop it . . you are making me hungry KH[spoiler]Time is always against us[/spoiler] |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-07-06 : 21:32:23
|
Maybe you should take out water first PRINT right('waterduck',charIndex('r','waterduck') -1) +' braised in butter, breast-side down with some onion, celery, carrot, maybe some potato, bay-leaves, garlic'AMITOFO+AMEN+YA ALLAH Hope the query works |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-06 : 21:50:55
|
using replace() is much easier than the charindex method replace('waterduck', 'water', '') KH[spoiler]Time is always against us[/spoiler] |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-07-06 : 21:59:30
|
Yes boss....using function better than 'conca'+' braised in butter, breast-side down with some onion, celery, carrot, maybe some potato, bay-leaves, garlic'??btw. The only duck i ate is burn duck with fire only =.=""AMITOFO+AMEN+YA ALLAH Hope the query works |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-07-07 : 05:02:10
|
quote: Originally posted by khtan LOL Hopefully he will be back next week. Is it duck season ? KH[spoiler]Time is always against us[/spoiler]
RABIT SEASON!Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-07-07 : 09:32:10
|
Wabbit season maybe? http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-07-08 : 04:59:18
|
Mr.tan...my comp server din't install full text search...can't try the following code...are allowing?or must in dynamic sql?supervisor call me do a report bout full text search.SELECT * FROM TABLE01 WHERE CONTAINS(@variablea, '@variableb') |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-08 : 05:06:53
|
sorry, i don't have that installed also KH[spoiler]Time is always against us[/spoiler] |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-07-08 : 05:17:44
|
arrr...too bad...i scare i post as new topic will get shoot...cause like very lazy...haha |
|
|
|