SeWaNsX's questions

People, I turn to you because google has not been very helpful for what I need.

I am looking for a way to make a dynamic pivot with 2 columns. Example:

I have this:

id  rut         fecha                   entrada salida
2   15114999    2017-10-16 00:00:00.000 9:00      :  
626 15114999    2017-10-16 00:00:00.000 11:00   13:00
627 15114999    2017-10-16 00:00:00.000 13:30   14:00
628 15114999    2017-10-16 00:00:00.000 15:00   16:00
629 15114999    2017-10-16 00:00:00.000 16:20   16:30
630 15114999    2017-10-16 00:00:00.000 17:00   17:30
631 15114999    2017-10-16 00:00:00.000 18:00   19:00
3   15114999    2017-10-17 00:00:00.000 9:00    22:00
4   15114999    2017-10-18 00:00:00.000 9:00    14:00

and I require this result

rut         fecha                   entrada salida entrada2 salida2 entrada3 salida3 entrada4 salida4 entrada5 salida5 entrada6 salida6 entrada7 salida7
15114999    2017-10-16 00:00:00.000 9:00      :     11:00   13:00   13:30   14:00   15:00   16:00   16:20   16:30   17:00   17:30   18:00   19:00
15114999    2017-10-17 00:00:00.000 9:00    22:00                                               
15114999    2017-10-18 00:00:00.000 9:00    14:00                                               

The id is not correlative.

I pose my problem. I have a SQL Server 2008 Database Server in which new databases are constantly being created, many of them are also being deleted and I don't have complete knowledge of how the log works, because I can actually see which databases have been deleted, but a while ago it stopped showing many, so I think the LOG is deleted or moved.

I would like a Dynamic SQL where I indicate by some variable or cursor, all the bases that I want to consult if they exist and that for each one I return the value "exists" or "does not exist".

I have nothing advanced since I can't think of how I could do it. I thought with some cursor along with a while, but I can't really think of it.

Any idea how I could?

I'm looking for a way to make the same change to different databases that start and end with the same syntax, just change the base number.

I have the following code but it doesn't work for me, it only updates the first Base

DECLARE @numero_alumno INT
DECLARE @base_inicio varchar(10)
SET @base_inicio = 'Base_0'
DECLARE @base_fin varchar(10)
SET @base_fin = '_AM'
SET @numero_alumno = 1
DECLARE @Base_de_datos varchar(50)

WHILE @numero_alumno < 10
BEGIN
    SET @Base_de_datos = @base_inicio+cast(@numero_alumno AS Varchar(1))+@base_fin
    EXEC('USE '+ @Base_de_datos)
    UPDATE RPARAMS SET Param='Dato_que_cambiare' WHERE copar='CONFIGUR'
    SET @numero_alumno = @numero_alumno + 1
    PRINT @Base_de_datos
END

PRINT 'Realizado'
GO

I indicate my query immediately:

Example, I have the table 'calendar':

Código | Tramo  | días
Semana1|08001800| 5
Semana1|DESCANSO| 2
Semana2|15302100| 4
Semana2|21000800| 1
Semana2|DESCANSO| 2
Semana3|09001900| 5
Semana3|DESCANSO| 2
Semana3|08001800| 2

The table indicated above is a schedule and my question is whether the result query can be obtained in the following way:

Código | Tramo  | Tramo  | Tramo  | Tramo  | Tramo  | Tramo  | Tramo  | Tramo  | Tramo  |
Semana1|08001800|08001800|08001800|08001800|08001800|DESCANSO|DESCANSO|
Semana2|15302100|15302100|15302100|15302100|21000800|DESCANSO|DESCANSO|
Semana3|09001900|09001900|09001900|09001900|09001900|DESCANSO|DESCANSO|08001800|08001800|

In theory, you should read the 'TRAMO' and repeat it the number of times indicated in 'days' and you should repeat it to the right in columns and without repeating the 'code'.

At the moment I haven't advanced in the code since I can't think of how to do it, I was thinking about using CASE but it doesn't work for me.

any ideas? Is that understood? It is dynamic since the query will be extended to the side according to the number of days that the section has.

Please your guidance.

I'm trying to get a small report from SQL Server 2008.

I need to list all databases created on the server, including:

• Name
• Creation date
• user (the one with db_owner permissions)
• and size

He sp_helpdbgives me certain data and I can't match it with my query:

SET language 'Spanish'
SELECT 
    name AS [Nombre DB]
    ,LEFT(DATENAME(WEEKDAY,crdate),10) + ' ' + CONVERT(VARCHAR(10),crdate,105) AS [Fecha Creación] 
FROM master.dbo.sysdatabases
order by crdate

Any idea how to do it?

I've searched on Stack Overflow but can't find it.

In SQL Sever 2008 I have a table called "tbltemp" with a field called "day", this field is type DateTime.

When I query direct dates on this field, it shows the following: Select day from tbltep

2017-03-20 00:00:00.000
2017-03-21 00:00:00.000
2017-03-22 00:00:00.000
2017-03-23 00:00:00.000

I would like to transform the query so that it returns as follows:

Lun 20-03-2017
Mar 21-03-2017
Mie 22-03-2017
Jue 23-03-2017

etc.

(The query I have is much larger than that but I do need to transform the datetime data)

Dear, I need to make a macro emulating the EXCEL =TEXT() function in vb.

the idea is that by having cells with hours (7:55) the vb function transforms me to 07:55. Usually for this I use =TEXT(cell,"hh:mm"), this transforms it for me. I need to bring that function to visual basic but it doesn't work for me with the following code:

Sub cambiarFormatohhmm()
Dim celda As Range

    For Each celda In Selection
        celda.Value = Texto(celda,"hh:mm")
    Next

End Sub

Any ideas?