Questions about sql-server-2012
Read more about sql-server-2012
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)
split one column values into multiple column based another column value
could you please help me writing select query to get expected output from the below picture. what I want is to split the UPC column values into three columns(Bottle UPC, Pack UPC, Case UPC) based on i...
Hussain
Votes: 0
Answers: 2
In SQL Server I have Json format rows in column level need to create multiple columns # fields are not order we can create based on that
{zipCode=47715, state=IN, city=Evansville, countryCode=US, line1=7424 Eagle Crest Blvd}
{zipCode=10965, state=NY, city=Pearl River, countryCode=US, line1=One Blue Hill Plaza}
{zipCode=30339, state=GA,...
B Nageswara Rao
Votes: 0
Answers: 0
About SQL pivot table
I'm trying to figure out how to produce this result in SQL using pivot table Sorted by SubID
units
Sub
SubCode
AM
PM
3
Math
M2201
Monday / 7:00AM-8:00AM
Tuesday / 1:00PM-2:00PM
3
Science
S22...
ran-de-vouz
Votes: 0
Answers: 1
Using Liquibase to manage two types of DBs and generate build/deploy scripts
My local deployment application supports 2 database types (Oracle and MS Sql Server). I have a working system with a set of build scripts that can be run against an empty schema to create a new build....
Andrew
Votes: 0
Answers: 2