Click here to Skip to main content
15,921,660 members
Home / Discussions / Database
   

Database

 
GeneralRe: Please help - can't update screen while waiting for SP in C#. Pin
Colin Angus Mackay2-Jul-04 15:34
Colin Angus Mackay2-Jul-04 15:34 
GeneralRe: Please help - can't update screen while waiting for SP in C#. Pin
unRheal2-Jul-04 16:39
unRheal2-Jul-04 16:39 
GeneralRe: Please help - can't update screen while waiting for SP in C#. Pin
Mike Dimmick4-Jul-04 6:52
Mike Dimmick4-Jul-04 6:52 
GeneralRe: Please help - can't update screen while waiting for SP in C#. Pin
Colin Angus Mackay4-Jul-04 7:16
Colin Angus Mackay4-Jul-04 7:16 
GeneralRe: Please help - can't update screen while waiting for SP in C#. Pin
unRheal4-Jul-04 13:42
unRheal4-Jul-04 13:42 
GeneralDTS Package Pin
Member 11509011-Jul-04 2:41
Member 11509011-Jul-04 2:41 
GeneralMaster in SQL please Help Pin
irshu1-Jul-04 1:05
irshu1-Jul-04 1:05 
GeneralRe: Master in SQL please Help Pin
Xiangyang Liu 刘向阳1-Jul-04 1:12
Xiangyang Liu 刘向阳1-Jul-04 1:12 
irshu wrote:
from the table like this i have to retrive distinct records where

delted = N

eg: in the above table after executing query result should be

ID Status Deleted

3 Repeat N
7 SUBMIT N
9 Pending Y


The query does not seem to be complicated, but it is not clear what you want. You said "deleted = N" and your result set has a record with "deleted = Y". Please explain.





My articles and software tools





GeneralRe: Master in SQL please Help Pin
irshu1-Jul-04 18:53
irshu1-Jul-04 18:53 
GeneralRe: Master in SQL please Help Pin
Xiangyang Liu 刘向阳2-Jul-04 3:59
Xiangyang Liu 刘向阳2-Jul-04 3:59 
GeneralRe: Master in SQL please Help Pin
Xiangyang Liu 刘向阳2-Jul-04 4:03
Xiangyang Liu 刘向阳2-Jul-04 4:03 
GeneralRe: Master in SQL please Help Pin
Anonymous4-Jul-04 20:05
Anonymous4-Jul-04 20:05 
GeneralRe: Master in SQL please Help Pin
irshu4-Jul-04 20:06
irshu4-Jul-04 20:06 
GeneralThank you, Pin
irshu4-Jul-04 20:06
irshu4-Jul-04 20:06 
GeneralMS SQL Server date format Pin
spn30-Jun-04 20:26
spn30-Jun-04 20:26 
GeneralRe: MS SQL Server date format Pin
michanne4-Jul-04 17:48
michanne4-Jul-04 17:48 
GeneralRe: MS SQL Server date format Pin
spn6-Jul-04 19:51
spn6-Jul-04 19:51 
GeneralACCESS DB to SQL Pin
youssef30-Jun-04 12:02
youssef30-Jun-04 12:02 
GeneralRe: ACCESS DB to SQL Pin
Colin Angus Mackay30-Jun-04 14:04
Colin Angus Mackay30-Jun-04 14:04 
GeneralRe: ACCESS DB to SQL Pin
youssef30-Jun-04 21:51
youssef30-Jun-04 21:51 
GeneralRe: ACCESS DB to SQL Pin
RichardGrimmer30-Jun-04 22:40
RichardGrimmer30-Jun-04 22:40 
GeneralRe: ACCESS DB to SQL Pin
youssef1-Jul-04 1:31
youssef1-Jul-04 1:31 
GeneralTRIGGER with a VIEW from a Linked Servers Pin
youssef3-Jul-04 13:19
youssef3-Jul-04 13:19 
GeneralODBC apparently has a statement length limit... Pin
CherezZaboro30-Jun-04 9:53
CherezZaboro30-Jun-04 9:53 
GeneralRe: ODBC apparently has a statement length limit... Pin
Steven Campbell30-Jun-04 13:38
Steven Campbell30-Jun-04 13:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.