Viewing 12 posts - 1 through 12 (of 12 total)
ok my friend, 🙂
thank so much for your time and support
excellent contribution!!!
October 11, 2012 at 6:42 am
My friend,
Now it's very goood,
Do you know as to show result of the NOTE field vertically in the Email Body?
for example as this one:
JOSE ASUNCION FIGUEROA ESTRADA
JAIME...
October 10, 2012 at 3:33 pm
ok my friend,
Make sure you know that the NOTE field that returns records, repeat the result
Like this:
JOSE ASUNCION FIGUEROA ESTRADA JOSE ASUNCION FIGUEROA ESTRADA JOSE ASUNCION...
October 10, 2012 at 2:24 pm
Well, the Query return two records, all records of the table before but concatenated.
but I don't know if there help me!!!
October 10, 2012 at 1:44 pm
my friend, I get the next error
Msg 4104, Level 16, State 1, Line 12
The multi-part identifier "T2.EMAIL" could not be bound.
Msg 4104, Level 16, State 1, Line 24
The multi-part identifier...
October 10, 2012 at 1:20 pm
ok this is my Query:
SELECT T3.NoEmpleado AS 'No.Empleado', LTRIM(RTRIM(T3.NombreEmpleado)) + ' ' + LTRIM(RTRIM(T3.ApellidoPaterno)) + ' ' + LTRIM(RTRIM(T3.ApellidoMaterno)) AS 'Nombre Empleado',
T2.IDArea, T2.
FROM dbo.tblCursoArea...
October 10, 2012 at 12:00 pm
Add the link for see the Query:
http://img200.imagevenue.com/img.php?image=889928666_Query1_122_432lo.JPG
October 10, 2012 at 11:35 am
Ey Luts,
and found the solution, I was able to pass data from field to field Varchar Float.
With this:
update tbl_MotorEns set MotorEns_NoSerieV = CAST(STR(MotorEns_NoSerie, 16, 0) AS VARCHAR(16))
and respect the...
March 5, 2012 at 10:29 am
Hi Lutz,
In the Query:
SELECT CAST(CAST(MotorEns_NoSerie AS NUMERIC(13,0)) AS VARCHAR(13)) FROM tbl_MotorEns
I got this Error:
Msg 8115, Level 16, State 6, Line 1
Arithmetic overflow error converting float to data type numeric.
any Idea??
Thanks
March 5, 2012 at 7:05 am
ok,
Do I have to do this in the SP where the MotoEns_NoSerie field does Insert?
or
in the part where I do the Update field 'Float' Field to 'NVARCHAR' Field?
thank so...
March 4, 2012 at 6:37 pm
1, 2 ... because we need to also accept alphanumeric intervals,
example: BD123456789 (serial number)
3 .... MotorEns_NoSerie field (serial number) was declared FLOAT since I think the table (I did not).
4...
March 3, 2012 at 8:18 am
Viewing 12 posts - 1 through 12 (of 12 total)