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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL - Counting through a returned dataset
You can use a subquery along with this that groups by ParentSku and counts ChildSku 's and selects only those ParentSku's HAVING counts of ChildSku's <=3.- djohns
- Post #2
- Forum: Microsoft SQL Server: Programming
-
How to set a time to excute the store procedure
If you have SQL Agent Running you can Create a job and schedule it to run. The job step would simply be a call to your stored procedure.- djohns
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Full-Text Searches on a Linked Server
When executing a query using the keyword CONTAINS on a Linked Server that has a Full-Text column in the table I am using, I get the following Error: Cannot use a CONTAINS or FREETEXT predicate on table 'LINKED_SERVER.DATABASE.DBO.TABLE' because it is not full-text indexed. But if I run the...- djohns
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Speed of Stored Procedures?
I also agree. Even though the inline SQL statements executed through ADO are ran at the SQL server, you will be missing out on some performance gains of a stored procedure. This is especially true if the table(s) you are searching through are large. A stored procedure is compiled as mentioned...- djohns
- Post #4
- Forum: Microsoft SQL Server: Programming
