python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - view

Stored procedure to create view with dynamic ID based on another table

I have a little problem with creating view based on another table. My first approach was to create variable and assign length of the table to variable, then create view and in loop insert dynamically ...
test-img

Wilk Rafał

sql

sql-server

tsql

stored-procedures

view

Votes: 0

Answers: 1

Latest Answer

Sounds to me like Row_Number() is what you are looking for. Try using this to create your view. CREATE view myView AS SELECT Row_Number() OVER(ORDER BY ID) ID, Name FROM dbo.table_1
test-img

Austin557

Can i use DECLARE within a view -sqlserver or CTE?

I tried various approaches to get the view created with the dynamic variable at the time of creation of the view. DECLARE @Test VARCHAR(64)='ABC'; // <==== attempt SELECT TOP 10 U.ID ,X.NA...
test-img

Alpha

sql

tsql

join

view

common-table-expression

Votes: 0

Answers: 1

Latest Answer

You cannot declare a variable in a view. Why would you not create the view and then SELECT from the view using the string in the WHERE clause? CREATE VIEW TESTVIEW AS SELECT TOP 10 -- Wouldn't rec...
test-img

Edward Radcliffe

Reset view position, android

In my android app I let the user move some views. I implemented the moving by adding an OnTouchListener to the views (v.setX()/v.setY()). Now I want the user to reset the views positions on button cli...
test-img

Created

android

view

position

Votes: 0

Answers: 1

Latest Answer

You can use translation instead of coordinates and then to reset simply do: view.setTranslationX(0); view.setTranslationY(0); Then your code would be: public class OnTouchCardListener implements View...
test-img

Jan Rozenbajgier

How do I get my CreateAPIView to recognize the &quot;validate&#39; seciton of my serializer?

I'm using Django 3.2 and Django rest framework 3.12.2 and have django.contrib.auth installed. I would like to create an endpoint to create users, so I have set this up in my views ... class CreateUse...
test-img

Dave

django

serialization

django-rest-framework

view

django-serializer

Votes: 0

Answers: 1

Latest Answer

You can check with: def validate(self, data): errors = {} # required fields required_fields = ['username', 'password', 'email'] for field in required_fields: if field not ...
test-img

Willem VO supports mod strike

Posts

Questions

Blogs

Jobs