Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.sqlserver.programming > #31371

Re: CTE Query

Show key headers only | View raw

Bimith Kunhiraman (bimithgmc@gmail.com) writes:
> using with cte , i need to skip row when the mnmIPDetails column has
> null values which means each user login Ttime two rows will be added in
> this case i need only one row which containing mnmIPDetails. Below
> written script will fetch all records. 

WHERE mnmIPDetails IS NOT NULL?

Please keep in mind the people you are talking have no knowledge of your
table or business problem? If my out-of-the blue guess does not answer
your question, my advice is that you post 2) CREATE TABLE statements for
your table(s), 2) INSERT statements with sample data, enough to illustrate 
all angles of the problem. 3) The expected result given the sample data. 4) 
A short description of the business rules why you want result, 5) The output 
from "SELECT @@version" so that we know which version of SQL Server you are 
using.

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous in thread | Find similar

Thread

CTE Query Bimith Kunhiraman <bimithgmc@gmail.com> - 2020-10-08 01:45 -0700
  Re: CTE Query Erland Sommarskog <esquel@sommarskog.se> - 2020-10-08 19:56 +0200

csiph-web