-
How do I make the query ?
scope of my work is
my select statement is having null value in a column as shown below,
1 first
2 NULL
3 2nd
4 NULL
5 NULL
6 NULL
what i want if there is any null value found previous column will be placed to current row... the result of my query should be like this
1 first
2 first
3 2nd
4 2nd
5 2nd
6 2nd
what i was thinking to use a udf function where I can place value in Context_Info, if there is value found in row calling the function and set this value in Context_Info otherwise null value found set the column data from Context_Info.
Unfortunately, udf can't change the state out of the world...
help out plz..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|