Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: LogicMagic
- Order by date
-
Date Difference Grouping
try something like: select pairname, datediff(d, max(date), min(date)), datediff(m, max(date), min(date)) from pairs group by pairname Good luck, Vlad http://www.logicmagic.com- LogicMagic
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Import & Export Wizard
You can save the DTS package and reuse it. This assumes that filenames do not change... Vlad http://www.logicmagic.com- LogicMagic
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Default Date format
The user options setting of sp_configure allows server-wide settings and works across multiple databases. This setting also behaves like an explicit SET statement, except that it occurs at login time. So... Try something like USE master EXEC sp_configure 'set dateformat mdy' RECONFIGURE WITH...- LogicMagic
- Post #2
- Forum: Microsoft SQL Server: Programming
-
SQL Stored Procedure - building an heirarchy
The best way I found to do hierarchies is not to do it by autonumber id but inbed level info into the ID. So your example would have ids that looked like 1 1_a 1_b 1_b_i and then you can do select * from table where ID = '1' or ID like '1_%' I hope you can see how this would allow you to...- LogicMagic
- Post #2
- Forum: Microsoft SQL Server: Programming
