python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - sql-server-2016

In SQL How to choose two of three or more tables to join based on a condition?

I have a total of say 3 tables, but I am only interested in joining two of them based on a condition. There is a lot of Q&A on how to use Case Statements, but that's when tables are already define...
test-img

TarrotCarder

sql

sql-server

sql-server-2016

Votes: 0

Answers: 4

Latest Answer

You can left join all three and then select the non-null one using COALESCE(). For example: select p.*, coalesce(a.someinfo, b.someinfo, c.someinfo) as info from price p left join tablea a on a.pr...
test-img

The Impaler

How can I tell if a host is connecting via multiple spids using one application or running multiple instances of the application itself?

We trace our SQL Server activity for performance issues. Some applications, written in C#, look to have up to 50 individual spids connecting to the DB from a single machine. How can I distinguish if t...
test-img

cloudsafe

sql-server

sql-server-2016

sql-server-profiler

sp-who2

Votes: 0

Answers: 1

Latest Answer

Maybe you can adapt this script to your needs CREATE TABLE tbl_who2 ( SPID INT, Status VARCHAR(255), Login VARCHAR(255), HostName VARCHAR(255), BlkBy VARCHAR(255)...
test-img

GuidoG

SQL - Transpose one column of data into a row

I am looking to take the values of a single column and transpose them into the corresponding row for each ClientGUID. A simple example of the of what I have post SELECT statement is: ClientGUID Dx...
test-img

zwick44

sql

sql-server

sql-server-2016

Votes: 0

Answers: 2

Latest Answer

In this type of query the number of values may vary and it is generally simpler and more flexible to use STRING_AGG() to list all the values. We can choose the seperator used between the values. One o...
test-img

user18098820

How to convert a currency format (from Excel) into a decimal in SQL?

I have a column in a table called [AMOUNT]. The column contains value uploaded from an excel sheet in the Currency Format (i.e $158.96, ($78.36), $714.98, ($7.73), etc). How do I convert these value...
test-img

no_name03

sql

sql-server

sql-server-2016

Votes: 0

Answers: 1

Latest Answer

You need to deal with the parenthesis to result in a negative number - one way would be to use translate, such as select Cast(Translate('($78.36)','()','- ') as money) Edit - use nested replace if 20...
test-img

Stu

Posts

Questions

Blogs

Jobs