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 - tsql

SqlCommand not inserting into table

This code seems like it should work, but simply doesn't. I've tried it various ways (with & without SqlDataAdapter) I have both the mdf and xsd selected as "Copy if newer" currently, an...
test-img

Charlotte

vb.net

visual-studio

winforms

tsql

Votes: 0

Answers: 0

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

How to Pivot/Unpivot data without column names, and only 1 row of data

I have a dataset, that is derived from a query. The easiest way to explain this issue is to show you what the data set looks like. Let's say I create this Table, and insert the data. Create table #te...
test-img

Shmewnix

sql

sql-server

tsql

Votes: 0

Answers: 2

Latest Answer

Fixing the typo in the #tempTable2 definition, using CROSS APPLY prevents you from having to scan the table N times, once for each Location column: SELECT y.Location, y.Amount FROM #tempTable2 AS t2 C...
test-img

Aaron Bertrand

Querying Json array column and other current table column

I have a table that has three columns from which I need to retrieve the data. One of the columns OtherNames contain an array of Json Objects. CREATE TABLE Persons ( NameID int, CurrentName var...
test-img

NoviceDeveloper

sql-server

tsql

sql-scripts

Votes: 0

Answers: 1

Latest Answer

As I mentioned in the comments, use OPENJSON against the column, not a scalar variable which contains the value of just one of your rows, and none of the other row data. SELECT P.NameID, ONs.[N...
test-img

Thom A

Posts

Questions

Blogs

Jobs