# | Date | Forum | Type | Thread | Post |
7 | 14 Nov 2011 @ 09:17 PST | Analytics | Topic | Date 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 ... |
6 | 12 Oct 2011 @ 07:26 PDT | Database | Reply | Random record selection in the subquery |
Thanks for the solution Dieter, It works as I need.
|
5 | 12 Oct 2011 @ 04:55 PDT | Database | Reply | Random 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... |
4 | 12 Oct 2011 @ 02:59 PDT | Database | Reply | Random 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
... |
3 | 12 Oct 2011 @ 01:29 PDT | Database | Reply | Random 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  ... |
2 | 11 Oct 2011 @ 05:32 PDT | Database | Topic | Random 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... |
1 | 07 Oct 2011 @ 12:39 PDT | Database | Topic | Reusing 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 ... |
|
|