Transpose Rows In Sql Server Stack Overflow Figure out another method for the transposition of rows and columns that doesn't require an actual sql table. figure out an appropriate method of allowing the sql account used by my end users to drop a table. I need to select 10 to 20 random rows from a table. (i only can find how to select just n random rows). i need to get something like this select * from table where abs(checksum(newid())) % 19 betwe.
Sql Server Transpose Sql Columns To Rows Stack Overflow Possible duplicate of simple way to transpose columns and rows in sql? you also need a value field in your query for each id to aggregate on. then you can do something like this. from . replace code below with your query, e.g. select id, value from table select . id = 1234, value = 1 union select . id = 1235, value = 2 . There are a few different ways that you can get the result that you want. you can use a select with union all: union all select store, '2 1 2013' date, [2 1 2013] value from yourtable; see sql fiddle with demo. you can use the unpivot function: value for date in ([1 1 2013], [2 1 2013]) see sql fiddle with demo.
Transpose Rows Into Columns Dynamically In Sql Server Stack Overflow
Comments are closed.