Re: Sequential integer column in view
From: alien2_51 (dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion)
Date: 03/11/04
- Next message: Greg O: "Re: Persisting temp tables"
- Previous message: David Portas: "Re: A Query Question"
- In reply to: alien2_51: "Re: Sequential integer column in view"
- Next in thread: Louis Davidson: "Re: Sequential integer column in view"
- Reply: Louis Davidson: "Re: Sequential integer column in view"
- Reply: Aaron Bertrand [MVP]: "Re: Sequential integer column in view"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 11 Mar 2004 13:54:46 -0800
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
> > >
> > >
> >
> >
>
>
- Next message: Greg O: "Re: Persisting temp tables"
- Previous message: David Portas: "Re: A Query Question"
- In reply to: alien2_51: "Re: Sequential integer column in view"
- Next in thread: Louis Davidson: "Re: Sequential integer column in view"
- Reply: Louis Davidson: "Re: Sequential integer column in view"
- Reply: Aaron Bertrand [MVP]: "Re: Sequential integer column in view"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
