Tag: sql-server

Select most recent row filtered on multiple columns

SQL syntax alphanumeric characters, SQL Server

sql sql-server

If I pull this ID down from my source system it looks like 9006ABCD. What would the syntax look like if I just want to return 9006 as the ID? Essentially, I don’t need the alpha characters.

SQL rotate results from wide to vertical

sql sql-server

I would love some help with the best way to capture some column data and rotate it so I can store the column name and numeric value in a temp table. The results are a single row showing a value for …

SQL Server – OPENROWSET Server name error using parameters

openrowset sql sql-server

I’m having trouble with this query…Any idea how to declare variables and make it visible to OPENROWSET query? DECLARE @SERVERNM VARCHAR; SET @SERVERNM = (SELECT(CAST(CONNECTIONPROPERTY(‘…

Parse a varchar column containing XML like data into row wise

sql sql-server tsql

i have a column in table which contain data like XML,i would like to get data in rows. My table data as- select printDataColumn from Mytable It returns value-

time and date from nvachar

sql sql-server

Want to convert NVarchar to Time and date using update column command in sql server CREATE TABLE [dbo].[timeconvert]( [sno] [int] NULL, [Duration_Load] [nvarchar](7) NULL, [Duration] [time](7) NULL, …

Filter and keep most recent duplicate

sql sql-server sql-server-2014 tsql

Please help me with this one, I’m stuck and cant figure out how to write my Query. I’m working with SQL Server 2014. Table A (approx 65k ROWS) CEID = primary key CEID State Checksum 1 …

Select every rows that contains all elements of group

sql sql-server

Column [TYPE] has A or B or C. I want to select list of names those have all A,B,C in the table. Result — dealing with count select name from tempso group by name having count(*) = (…

Combine 2 tables without primary key

sql sql-server tsql

I have 2 tables and wanna combine as below Table Student: Student ID | Student Name ———–+————- 100 John 101 Micheal Table Subject: Subject Name | Subject Desc –…