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 SkipVought 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: phili5678
- Order by date
-
Error in UNION ALL query
i tried this.. i got this error when i didnt select any columns from the tables.. why dont u try using an alias to specify the column name..- phili5678
- Post #2
- Forum: Microsoft SQL Server: Programming
-
How to add two text fields?
;-) enjoy....- phili5678
- Post #10
- Forum: Microsoft SQL Server: Programming
-
HOW TO DUPLICAT ROWS!
i dont think this can be done with one query.. why dont u try with a temp table and then do a select..- phili5678
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Top 3 with Group by
try something like.... select C.Name, C.Title, C.Company from Contact C where (select count(*) from Contact D where c.SOMEID=d.SOMEID and title like "%pres%" or title like "%CIO%" or title like "%CEO" or title like "%CHAIR%") <=3 if u need to group by...- phili5678
- Post #2
- Forum: Microsoft SQL Server: Programming
-
How do I reference a table on a different server
there is something called the sp_addlinkedserver.. then u can use openquery to select from another server.. hope it helps.. :-)- phili5678
- Post #5
- Forum: Microsoft SQL Server: Programming
-
How to add two text fields?
Let me know if u are still having trouble..:-)- phili5678
- Post #8
- Forum: Microsoft SQL Server: Programming
-
How to add two text fields?
why dont u check out UPDATETEXT.. u will have to work with pointers though... This works in SQL 2000..- phili5678
- Post #7
- Forum: Microsoft SQL Server: Programming
