Questions tagged as 'sql-server'

Tagged questions
2
answers

How to perform a split in SQL server 2008 r2?

Hi, I wanted to know if it is possible to carry out a split as shown below, since I need to receive a string of words separated by commas; So far I have not been served by the methods I have seen on the internet. SELECT * FROM BASE WHERE Doc i...
asked by 24.11.2016 / 16:00
1
answer

Problem with pivot SQL server 2008 r2

Good people, I have not touched much the issue of sql, at least to do what a client has asked me, you need to create a view where you see a single line with the days of a month that you enter a user of your application and show certain data....
asked by 14.11.2017 / 17:37
2
answers

Query Transact Sql - SubSelect

I have an sql query that I can not determine, ( SELECT ( SELECT e.nombre FROM [Control_Documental].[dbo].[Etapa] AS e WHERE e.idEtapa = etd.idEtapa )AS etapa FROM [Control_Documental].[dbo...
asked by 23.09.2017 / 00:33
0
answers

Send SVG image in Email

I tried to send an image in SVG code so that a mail client interprets it as HTML and is visualized. The problem that only I see the image in a mail client, for the most part can not be seen. The way I send the code from sql server is as fo...
asked by 27.09.2017 / 01:24
2
answers

Insert Every record of a datagridview based on visual studio 2015 data?

I have a big question about ... How do I make multiple entries into my database the records that are inside my datagridview?. for example: A trip of such date, insert all the people that will go to that trip, in this case they would be all th...
asked by 04.10.2017 / 09:05
0
answers

How can I upload data from a flat file (excel) to SQL server express?

I tried to upload a flat file (excel) in xlsx and csv formats but I get the following error:    Mens. 4864, Level 16, State 1, Line 1 Data conversion error   of mass loading (type not matching or character not valid for the   code page specif...
asked by 09.10.2017 / 15:35
1
answer

Group record by column including NULL values

I have this script SELECT n.Conteo, MAX(d.IdPaciente) OVER(PARTITION BY d.IdPaciente ORDER BY d.IdPaciente )IdPaciente , IdPaciente, d.FechaAnalitica, d.GlucosaPre, d.Sodio, d.Calcio FROM ##Numeros n LEFT JOIN ( SELECT ROW...
asked by 05.09.2017 / 19:06
0
answers

Question about sql attribute Type Bit [closed]

Good afternoon guys, I have a doubt about this "Bit" guy. I have to insert some data into a table from c # but one of those data is a bit type .. what kind of data from c # equals the bit type in sql server?     
asked by 07.10.2017 / 23:58
1
answer

Return 1 or 0 depending on the result of the query

I have the following query Select L.idtipolocalidad from Localidad L inner join RecepcionDetalleAbierta RDA on RDA.idLocalidadAlmacenado = L.IdLocalidad inner join Localidad L1 on RDA.IdLocalidad = L1.IdLocalidad where l1.Codigo = 'PREC36' g...
asked by 23.03.2018 / 17:22
0
answers

SQL Server query does not work, the parameter that I use to activate it is in SharedPreferences

public class ResumenTotal extends AppCompatActivity implements SwipeRefreshLayout.OnRefreshListener{ private RecyclerView recyclerView1; private ArrayList<ClaseResumen> array1; private SwipeRefreshLayout swipeContainer; @Ov...
asked by 23.03.2018 / 00:43