#DateForumTypeThreadPost
1411 Nov 2009 @ 01:13 PSTToolsTopiccomrpess columnDoes the compressed column play an impact in query execution, when it is involved in a left outer join? the column is compressed to a value for eg: '$'-Thank you
1311 Nov 2009 @ 12:54 PSTDatabaseTopiccompress columnDoes the compressed column play an impact in query execution, when it is involved in a left outer join?the column is compressed to a value for eg: '*'
1228 Oct 2009 @ 05:36 PDTDatabaseTopicGlobal temporary tableHow to create a GTT from another tableis it likecreate global temporary table as (sel * from employee)on commit preserve row;if i do this, the syntax error: something expected between ')' and 'on'w...
1113 Oct 2009 @ 01:09 PDTDatabaseReplyCOALESCEJimm,thanks for the reply.here the problem is i need to pick the not null value between ---> COALESCE (db_1.appl_no, db_2.appl_no)but the db_1.appl_no itself has three possibilites ---> N...
1012 Oct 2009 @ 07:53 PDTDatabaseTopicCOALESCEI need to write a query, so that it returns the non-null value like the following,COALESCE (db_1.appl_no, db_2.appl_no) as Appl_nbrBut, db_1.appl_no has both '?' and ' ' here the coalesce function ...
905 Oct 2009 @ 05:33 PDTDatabaseTopicSubquery returns more than one valueI need to join two tables that have no direct relation.so another table has to be taken to join themfor ex:Sel col_12, col_34from table_a Ainner join table_b Bwhere B.col_sd= (sel C.col_sdfrom tabl...
801 Oct 2009 @ 05:31 PDTDatabaseReplyStored proceduresince the view has already been created..can i do this..REPLACE PROCEDURE Proc_Name()BEGINsel * from view_nameEND;
701 Oct 2009 @ 05:17 PDTDatabaseReplyStored procedureOk sure i will get back sooner with exactly what i need....even i got doubts at my end..wil get back once im clear about it ...thanks for your tremendous help...appreciate it!
601 Oct 2009 @ 04:15 PDTDatabaseReplyStored procedurehere i need to create a new stored procedure ...for which the view is available...in that case do i need to create a new sp?? i think what have u given is including a DDL statement in a already exi...
530 Sep 2009 @ 06:00 PDTDatabaseTopicStored procedureHello i need help on creating a Stored procedure from the followinghere is the view that is available please help me to create store procedure out of it......Replace view view_nameassel col_1, col_...
430 Sep 2009 @ 01:39 PDTDatabaseReplyDifference between select * from table & select individual columns from tableYou can use sel top10* from table to get quicker result sets, instead of going for sel * from table , if you want to check the columns and their names, for one instance. Fetch time will be minimized.
329 Sep 2009 @ 02:26 PDTDatabaseTopicGlobal temp OR Derived tablethe query which im executing is very big..so i need to create a global temp table or derived table...how do i do it...do i need to include the database name before the table name??for example...for...
229 Sep 2009 @ 02:10 PDTDatabaseReplyLike - Wildcardthank you both!!related to this i also got another doubt..the query which im executing is kinda big..so i need to create a global temp table or derived table...how do i do it...do i need to include...
129 Sep 2009 @ 01:07 PDTDatabaseTopicLike - WildcardIs there anything like Like all or Like any command...if we include more than one field inside the sql.for eg:wherefirst_name like ('ad%', 'w%', 'e%')Do we need to include ANY OR ALL....first_name...