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!

Register Log in
  • 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!

Search results for query: *

  1. Middlej

    Issue with Data Transform Task

    Thanks for the input on this matter -- the SET NOCOUNT ON option worked for my problem -- outputting data from a stored proc to a semicolon-delimited text file. Thank you, Joe Middleton
  2. Middlej

    Querying Modification Dates for a Table

    I would like to be able to query table modification dates to see when a user table has been modified. For example, if I want to see when an INSERT statement has been performed on a specific user table, can I query for this in the system tables? The benefit here is to be able to effectively...
  3. Middlej

    Using a system date variable within a Function

    Hello everyone...here's a little problem I have. I would like to use a GETDATE()-like function within a function, except I know I can't use GETDATE() within a function I create. What other options can I use? I have tried this: select dbo.myfunction(mydate) from (select getdate() as...
  4. Middlej

    Executing a DTS Package using T-SQL

    Does anyone out there have any tips or ideas as to how one can execute a DTS package using Transact-SQL code? The idea is to have certain external data sets imported only if certain conditions are met. Such an example MIGHT look like (note: I've tried this, it doesn't work): USE [Database...

Part and Inventory Search

Back
Top