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

What is the best practice to insert a row after some consecutive rows in a table?

I have the below data in a table: REGION,CATEGORY,SUBCATEGORY,ItemName,ItemViews,sales,ItemViewspercentage CE,Infotainment,Safe Exit Assist,Voice Commands,5,4,125.00% EA,Infotainment,Safe Exit Assist,...
test-img

Asutosh Nayak

sql

sql-server

sql-server-2008

Votes: 0

Answers: 1

Latest Answer

You can use GROUPING SETS for this SELECT REGION = CASE WHEN GROUPING(REGION) = 1 THEN 'Total' ELSE REGION END, CATEGORY, SUBCATEGORY, ItemName, ItemViews = SUM(ItemViews), sales = SUM(sal...
test-img

Charlieface

Find which where clause is the most troublesome

Problem background I am trying to pin down to what condition(s) are causing no records / rows the most, so to allow me to find the root cause of what data in the database might need scrubbing. So for ...
test-img

Vivek Shukla

sql

database

sql-server-2008

stored-procedures

Votes: 0

Answers: 1

Latest Answer

If this is just for debugging, what about detecting when the @@ROWCOUNT = 0 and storing those parameters in a separate debugging table? SELECT TOP 1 * FROM SomeTable WHERE column1 = @param1 AND...
test-img

SOS

Find distinct from multiple columns

I have 2 columns called price and PID in database called seatinginfo. Both columns will have multiple of the same values like pid 1,1,1,1,2,2,2,2,2,2,2,3,3,3,3,3 price 10,10,30,40,60,80,70,90,90,90,90...
test-img

kivi12k

sql

sql-server

sql-server-2008

Votes: 0

Answers: 1

Latest Answer

This is probably as simple as basic aggregation. Something like this should work based on the pretty vague details. select price , max(pid) from YourTable group by price
test-img

Sean Lange

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,...
test-img

B Nageswara Rao

sql-server

tsql

sql-server-2008

sql-server-2012

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs