Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 Punch card(out)

Author  Topic 

waterduck
Aged Yak Warrior

982 Posts

Posted - 2009-07-03 : 06:19:31
Bye bye(6.32pm)...off for 2 day with salary
GOOD 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............
Go to Top of Page

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.
Go to Top of Page

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]

Go to Top of Page

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-03 : 09:46:05
ok bye guys happy weekend.....





Your time is a valuable resource.
Go to Top of Page

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
Go to Top of Page

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]

Go to Top of Page

waterduck
Aged Yak Warrior

982 Posts

Posted - 2009-07-05 : 21:17:48
posted

AMITOFO+AMEN+YA ALLAH Hope the query works
Go to Top of Page

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!
Go to Top of Page

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]

Go to Top of Page

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
Go to Top of Page

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]

Go to Top of Page

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
Go to Top of Page

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 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page

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.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

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')

Go to Top of Page

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]

Go to Top of Page

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
Go to Top of Page
   

- Advertisement -