Skip to search.
sqlcon

Group Information

  • Members: 779
  • Category: SQL
  • Founded: Feb 23, 2004
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Messages

  Messages Help
Advanced
Messages 6677 - 6711 of 6711   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
6677 sunil john
suniljk7 Offline Send Email
Jun 27, 2011
7:51 am
Join is efficient way of coding, but below both queries will give diff output. Best Regards Sunil John ________________________________ From: W...
6678 ramakrishna_e2 Offline Send Email Jun 27, 2011
9:56 am
In General. A subquery is equivalent to a joinThe reason being that the biggest problem with joins is ordering them correctly and making the best use of...
6679 W
wzkmafi Offline Send Email
Jun 28, 2011
10:39 pm
Ok, Maybe i should have asked this this way :-) What would be the Most efficient code for this query? SELECT USER_ID FROM USER WHERE USER_ID NOT IN (SELECT...
6680 W
wzkmafi Offline Send Email
Jun 28, 2011
11:38 pm
What would be the Most efficient code for this query? SELECT USER_ID FROM USER WHERE USER_ID NOT IN (SELECT USER_ID FROM VACATION)...
6681 Gigme Chittayath
gigmepc Offline Send Email
Jun 29, 2011
2:17 am
Best method is using a left join. select a.user_id from user a left join vacation b on a.user_id=b.user_id where b.user_id is null ...
6682 ravindhar Bonagiri
bonagiri_ravi Offline Send Email
Jul 24, 2011
3:58 pm
Hi Senthil, &nbsp; You can access the objects across the databases using Linked Server concept. Create linked server and use the syntax like select * from...
6683 SARADADEVI
sv_39 Offline Send Email
Aug 1, 2011
3:51 am
Requirement:-Do dev db refresh by using prod db backup. I don’t want to lose existing privileges in devdb. Environment :SQL2005. For that what need to be...
6684 mohd rizwan
mo2riz Offline Send Email
Aug 4, 2011
5:57 am
Krishna,   You can follow below steps to achive this..   1)Script out all Users,Roles, Schemas & permission of DEV database and save it. 2)Take backup of...
6689 sunil john
suniljk7 Offline Send Email
Sep 13, 2011
6:59 am
using not exists is also a good method.   Best Regards Sunil John ________________________________ From: Gigme Chittayath <gigmepc@...> To:...
6690 Senthil Kumar T R
trsenthilkumar Offline Send Email
Sep 30, 2011
7:57 am
Hi All,     Here is what we need:     1. All possible TimeZones with UTC offset     2. DST info (ie. when DST starts and ends for next 20 years and...
6692 SARADADEVI
sv_39 Offline Send Email
Oct 25, 2011
12:41 am
version :9.00.4266.00 productlevel:SP3 edition :Standard Edition (64-bit) Hi Team,   Could  please let me know whether SQL2005database is UTF-8 complaint or...
6693 Vish
VISHNAT Offline Send Email
Oct 25, 2011
6:15 pm
Looks like it provides limited support to UTF 8 .The best you can do is write some .net routine to convert it . From article...
6694 SARADADEVI
sv_39 Offline Send Email
Oct 26, 2011
10:31 pm
Hi Team,   In server xxxxxx-sql5a, databases: FIN,PAPare showing restoring state from the last 48 hours.       Below is the message I got it from email.  ...
6695 SARADADEVI
sv_39 Offline Send Email
Oct 26, 2011
10:49 pm
Hey guys.   How to fix Below SQL job failure.   This job has been failing since October 17th.   below is the escalation from my manager.    Can we make...
6696 s manikanth
s_manikanth Offline Send Email
Nov 22, 2011
3:46 pm
<p>Hey Friend!<br>literally for your sake do not pass this chance of a lifetime by<br><a...
6697 s manikanth
s_manikanth Offline Send Email
Nov 27, 2011
3:50 pm
<p>Hola Friend...<br>i'm more humble now<br><a href="http://keywaysinc.com/profile/80KevinMorris/">http://keywaysinc.com/profile/80KevinMorris/</a><br>see you...
6698 niranjana
niruhsd Offline Send Email
Nov 30, 2011
9:12 am
Hi happily stay fit with healthy http://www.niranji.com...
6699 s manikanth
s_manikanth Offline Send Email
Dec 5, 2011
12:40 pm
<p>hola.<br>I had tried everything this was my opportunity knocking at the door ive finally reached the top youll see what I mean<br><a...
6700 abd elmohsen
abd_elmohsn Offline Send Email
Dec 7, 2011
7:21 am
good morning every body I have a big problem in sql server 2000 database ,am making update in an table and i have no backup to restore this table to the...
6701 SARADADEVI
sv_39 Offline Send Email
Dec 7, 2011
11:50 pm
  There is no way to restore previous state if you have no backup. With SQL default tools.   ________________________________ From: abd elmohsen...
6702 s manikanth
s_manikanth Offline Send Email
Dec 14, 2011
3:36 pm
<p>hey there.<br>it truly is an amazing opportunity to fortune in the current economic climate<br><a...
6703 s manikanth
s_manikanth Offline Send Email
Jan 31, 2012
8:01 am
<p>Hola!<br>I feel like ive been distant lately I was able to regain my independence using this it was time to start a new chapter<br><a...
6704 SARADADEVI
sv_39 Offline Send Email
Feb 11, 2012
4:22 am
Hi Family, Could you please let me know the difference between SQLServer2008R2 in SAP environment and Non-SAP environment? Thanks and regards, Krishna ...
6705 s manikanth
s_manikanth Offline Send Email
Mar 1, 2012
2:41 pm
<p>Hello<br><br>ive never had anything come easy to me my life would still be miserable without this nobody was much help to me...<br><a...
6706 Santhosh
san_spy Offline Send Email
Apr 17, 2012
6:20 pm
Immediately need 24 profiles for Gulf resource requirements. This is for our client for 2 years contract. We have to send profiles by 3:00PM IST this Thursday...
6707 robert sackey
papsac Offline Send Email
Apr 24, 2012
12:56 am
<p>Making Real Money Online has never been so easy!<br><a...
6708 KRBR Chowdary
rbr_chowdary Offline Send Email
May 3, 2012
6:48 am
Sorry I didn't inform you about my trip to Spain  for a Program, Unfortunately for me all my money along with my bag where my passport and valuable things...
6709 Himanshu
kr_himanshu Online Now Send Email
May 9, 2012
5:39 am
<p>No technical knowhow necessary, you earn money fast using the amazing 20 minute payday system!<br><a...
6710 Himanshu
kr_himanshu Online Now Send Email
May 12, 2012
6:43 am
<p>Make Money? Super EASY<br><a...
6711 niranjana
niruhsd Offline Send Email
May 16, 2012
12:54 pm
SSLC Results 2012 karnataka http://www.niranji.com/sslcresults.html...
Messages 6677 - 6711 of 6711   Oldest  |  < Older  |  Newer >  |  Newest
Add to My Yahoo!      XML What's This?

Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help