Search Results | SQL Server Performance Forums

Dynamic for Visual Basic6

Thread by: ohne, Oct 14, 2006, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi to everyone. How can i create a dynamic connection to sql server from visual basic 6? I have this code: cPersonalFile = gDrive & gDir &...

Problem with dates

Thread by: ohne, Oct 11, 2006, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hello, i have this issue with dates, i dont know how to ask user for a date to make a search in the table i have this script: SELECT Personal.EmpID...

Help with this query!!

Post by: ohne, Oct 10, 2006 in forum: SQL Server 2005 T-SQL Performance Tuning

Ohhh god! thank you FrankKalis, I overlooked it too, but I have one last question, on the old script, it returns 2804 rows, but it does not has the...

Help with this query!!

Post by: ohne, Oct 10, 2006 in forum: SQL Server 2005 T-SQL Performance Tuning

Thanks FrankKalis, as i though, it solved the problem, but it returns nothing, any suggestions? Love... how is it?

Help with this query!!

Post by: ohne, Oct 10, 2006 in forum: SQL Server 2005 T-SQL Performance Tuning

Can you explain to me whats a proper aggregate function? the custom ones? Ok, i did change the script, it ended like this: select m.EmpID as EmpID,...

Help with this query!!

Post by: ohne, Oct 10, 2006 in forum: SQL Server 2005 T-SQL Performance Tuning

hi Roji. P. Thomas and thanks for your help! the error is gone, but now i got this one: Msg 8120, Level 16, State 1, Line 2 Column...

Help with this query!!

Thread by: ohne, Oct 10, 2006, 13 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

This one is giving me headaches!! I have this query: select m.EmpID as EmpID, m.fecha as Since, m.motivo as Notes, m.ClvDelMovto AS AreaFamilia,...