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 Chriss Miller 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: BrooksMT
  • Content: Threads
  • Order by date
  1. BrooksMT

    T-SQL script skipping lines of code (it shouldn't)

    I have a T-SQL script that is almost 1,100 lines of code that is acting strangely. It has 19 "steps" and if you copy and paste the code into a query window in SSMS, it runs perfectly. But if you add a link to the script in an SSIS connection and run it from an Execute SQL task, it runs steps 1...
  2. BrooksMT

    Need a little help with non aggregate Pivot table

    This almost works. The SDM_Field contains character data. This should not show all nulls. Suggestions appreciated. Thanks, Brooks SELECT [DESTFLD] ,[AFS] as AFS,[CLCS] as CLCS,[CPI] as CPI,[ForeignOfficeDeposits] as ForeignOfficeDeposits,[HEQ] as HEQ ,[ILN] as ILN,[INVSEC] as...
  3. BrooksMT

    T-SQL question on case/when statement

    I'm much more familiar with VBA and less so with T-SQL. Does the following code make sense? If a ‘WHEN’ statement evaluates as true, are the following WHEN statements skipped? update CPI_Temp Set [ID_OWAM] = CASE WHEN [Orig_wam]< 24 THEN '01Y' WHEN [Orig_wam]< 48 THEN '03Y' WHEN [Orig_wam]<...
  4. BrooksMT

    Is VB.NET included with Visual Studio 2008?

    Hi, I use VS 2008 to create SSIS packages, but when I go to File, New, Project it does not offer a VB.NET project type. Can someone tell me whether VB.NET is included in VS2008 or is it a separate licensing fee? What would be the name of the installation program for VB.NET? Thanks! Broks
  5. BrooksMT

    SSIS switchboard/menu/dashboard ... ?

    I'm working on an application that will have about a dozen SSIS packages. These will be run manually on different days and times. What are the options for putting these onto one screen with 12 buttons (1 per package) that can be clicked to launch the package? Thx.
  6. BrooksMT

    Error with sp_send_dbmail in a Job

    I have a SP, called SP_Test which includes the msdb SP sp_send_dbmail. When I run SP_Test from the Stored Procedure folder, it works perfectly fine and ends by sending an email. But when I run SP_Test from a Job in SQL Server Agent, I get this error when it hits the sp_send_dbmail: Executed...
  7. BrooksMT

    Excel VBA Links/Connections not showing

    I'm working with some Excel objects through VBA in Access. I'm working with a spreadsheet that has 3 connections. I can see them in Data, Edit, Links. But when I create and Excel object and a workbook object, I can't see the links. ?xlIn.ActiveWorkbook.Connections.Count 0...
  8. BrooksMT

    Good book for writing Excel VBA from Access?

    Would appreciate suggestions for a good reference book for writing VBA code in Access which manipulates Excel objects. (not looking for a book for writing VBA WITHIN Excel) Thx
  9. BrooksMT

    Help - Error opening rpt

    Error is: %1 could not be found Failed to open document Am using CR 2008. The error occurs regardless of whether I double-click on the *.rpt file or if I start CR then load the the *.RPT. I was working on this file last week and have quite a bit of time invested in it. It contains about 2...
  10. BrooksMT

    Create Indexes not utilitized within the same SQL script

    I have a script which contains a "work" table that was being generated as it ran (via INTO). Later queries which used the table ran too slow so I added CREATE INDEX statements on the work table. This had no effect. So I made the work table permanent and added the indexes before the script...
  11. BrooksMT

    Showing times at key points during a SQL script

    I'm running a lengthy SQL script from the Visual Studio using a Execute SQL task. What statements can be added to the script to display the date/time at key points (similar to a Debug.Print)? Ideally, I'd like to write to the Progress window but saving to a text file would also work. Thx, Brooks

Part and Inventory Search

Back
Top