Re: Sequential integer column in view

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 18:32:23 -0500

Also see some examples here
http://www.aspfaq.com/2427 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:eZ6T6N7BEHA.2576@TK2MSFTNGP11.phx.gbl...
> Duh.. Please excuse... CustomerID is an nchar... What would realoly help
me
> now would be an explanation as to how that works and under what condition
it
> will work... Does it require you to compare on a unique column...?
>
> "alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion>
wrote
> in message news:eLWHCM7BEHA.2060@TK2MSFTNGP12.phx.gbl...
> > Hi Karl,
> >
> > Thanks for your reply... Thats a very interesting example... It does
what
> I
> > had asked for... I'm not really sure what going on there but it seems
that
> > it requires an underlying identity column for the where clause (where
> > c1.CustomerID >= c2.CustomerID).. Is that correct...? How would this
work
> > say if your table had a char as a primary key...?
> >
> > "Karl Gram" <NOSPAMkarl@gramonline.nl> wrote in message
> > news:e%23qsQ%236BEHA.892@TK2MSFTNGP09.phx.gbl...
> > > Hi,
> > >
> > > Here's a sample using the Nothwind Customers table:
> > >
> > > Use NorthWind
> > >
> > > select c1.CustomerID, (
> > >  select count(*) as rownum
> > >  from customers c2
> > >  where c1.CustomerID >= c2.CustomerID)
> > > from customers c1
> > >
> > >
> > >
> > > -- 
> > > HTH
> > >
> > > Karl Gram
> > >
> > > "alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion>
> > wrote
> > > in message news:u089Xz6BEHA.2804@tk2msftngp13.phx.gbl...
> > > > I want to add a "Calculated" column to a view that basically auto
> > > increments
> > > > for every row returned from the view starting from 1 and
incremetning
> by
> > > 1,
> > > > does someone know if this can be done in a T-SQL statement... I was
> > > thinking
> > > > of maybe cast something as an "int identity" but I'm not sure what
to
> > > > cast... I don't want to create a temp table or anything like that...
A
> > > > sample would be AWESOME!! and very much appreciated...
> > > >
> > > > TIA....
> > > >
> > > > Dan
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Using console.perms
    ... original posting despite his follow up claim that it explains more ... I do agree with Karl that the man and info pages ... configuration files relating to the topic with no explanation at all ... If it contained proper explanations (any ...
    (Fedora)
  • Re: Using Index to Transpose, Update Reference Cells as you Drag D
    ... Thanks very much for the explanation too. ... As you copy across the COLUMNincrements by 1 and the result of the ... It works great when I drag across, transposing column data on another ... But how do I get it to work so when I drag the formula down to cell L10, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Sequential integer column in view
    ... CustomerID is an nchar... ... What would realoly help me ... now would be an explanation as to how that works and under what condition it ... >> Karl Gram ...
    (microsoft.public.sqlserver.programming)
  • Re: Auto shut off
    ... And if problem shows up in the security log, you see "Failure audit" ... Enquire, plan and execute ... Karl Snooks wrote: ... You will receive a brief explanation of the event. ...
    (microsoft.public.windowsxp.general)
  • Re: cups
    ... On Wednesday 08 August 2007 16:31:23 Chris Jones wrote: ... My guess is that Karl is under 10 years old, otherwise, there's no explanation ... Manuel Arostegui Ramirez. ...
    (Fedora)