I have a sql table that has columns FundId, BreakdownName, BreakdownType and BreakdownValue FundId BreakdownName BreakdownType BreakdownValue F00000OCVS Cash Long 10.69 …
Tag: sql-server
Multi Part Identifier Can Not be Bound
I’m having trouble getting past this error. I’m using SQL Server 2017 (v14): The multi-part identifier “PS_FFC.Date” could not be bound. The multi-part identifier “PS_FFC.Date: could not be bound. …
SQL Server – Create view using many fields of a row as names of columns
I present to you a simple and short example of what I want to resolve. I need to create a view from two tables. The table indicator stores in a single row the names of the indicators to be measured …
T-SQL – Copying & Transposing Data
I’m trying to copy data from one table to another, while transposing it and combining it into appropriate rows, with different columns in the second table. First time posting. Yes this may seem …
Update Primary Key Column Name in SQL
This code defines Category table in SQL: CREATE TABLE [dbo].[Categories] ( [CategoryID] INT IDENTITY (1, 1) NOT NULL, [Name] NVARCHAR(450) NULL, […
How to detect changes to values through a specific order
Given Id | RouteId | Milepoint | RoadCondition -: | :—— | ——–: | :———— 1 | A | 0 | X 2 | A | 1 | X 3 | A | 4 |…
SQL round percent up to nearest .1
I have a columns of percentages and i want them to always round up to the nearest .1 for example .005 –> .1 .11 –> .2 .3256 –>.4 .6797 –>.7 I am trying ceiling and floor, but they …
SQL restart number sequence each year
I’m Working to create a simple repair log serial number. I would like to create a unique code for each repair but I don’t want the numbers continuing on forever, I would like to use Zone(department), …
Multiple rows in table with values from another table
I am struggling with following issue: Table1: Table2: Expected result: Basically I want to multiple rows in dates table with rows from User table. Is it somehow possible? (using TSQL).
I’m getting ‘Subquery returned more than 1 value’, without a subquery on my SELECT
I have a view in which I don’t have access into modify it, and I have to make a SELECT query that brings me the rows in witch a column is empty (empty, not null) In this view I have: Oid| Name | …