#DateForumTypeThreadPost
714 Nov 2011 @ 09:17 PSTAnalyticsTopicDate gap analysis Hi All, I am trying to find out the records with dates overlapped or continous and then making it as a single record with the minimum date to the max date. Here is the example of what i ...
612 Oct 2011 @ 07:26 PDTDatabaseReplyRandom record selection in the subquery Thanks for the solution Dieter, It works as I need.
512 Oct 2011 @ 04:55 PDTDatabaseReplyRandom record selection in the subquery Hi Mac, The Above query produces random number of records. Sometimes it's not producing any and some times multiple records are coming. But I need only one value for Cust_type_CD and...
412 Oct 2011 @ 02:59 PDTDatabaseReplyRandom record selection in the subquery I have written SP to pass the parameters of the table and column for which the data and from which the sample record will be sent back to the calling procedure. Like the below   ...
312 Oct 2011 @ 01:29 PDTDatabaseReplyRandom record selection in the subquery Hi MAC,   Thanks for the reply. Here is the sample data that I am trying to achieve. TABLE A Cust_id     Cust_type_CD  Cust_Location 1      ...
211 Oct 2011 @ 05:32 PDTDatabaseTopicRandom record selection in the subquery Hi All, I am writing SP to generate dynamic SQL query which creates insert statements. I want for a particular column the data should be fetched from another table. I have tried sample a...
107 Oct 2011 @ 12:39 PDTDatabaseTopicReusing the code Snippet in SPROC Hi All, Is there any way I can create function like strcture to keep my reusage SP code and can be called multiple times. I tried two difference Stored Procedure but is there any simple way ...