Search results for query: *

I'm trying to set up a SQL Server Agent account and I just hit a wall. I was following these instructions. http://msdn.microsoft.com/en-us/library/ms187901.aspx and http://msdn.microsoft.com/en-us/library/ms190703.aspx When I was creating the SQL Sever Agent Proxy it started to error out...

I have a production IWR 7.1 server that stopped running IWR reports yesturday. This happened once before and the tech support person, whom I am still waiting on to return my call, said that if impserver.exe is not running in task manager then the IWR reports won't run. Welp, it isn't running...

I'm having trouble getting a stored procedure to work in Impromptu. I've set up 3 parameters in the stored proc, and I created three parameters to pass to it. I have called it two different ways with neither working. I've included the error message with each. Can someone show me what I am...

I'm a Business Intelligence Analyst using SSRS, SSAS and SSIS, SQL Server and Oracle databases. I am working for a contracting company and the other day, my boss at the client site let it be known what my billing rate is. He left the bill on his desk as I was talking to him about something...

I am downloading an XML file from a trusted source and would like to allow for DTD inside an XML file that is being downloaded through SSIS. Can anyone tell me how can I set the ProhibitDTD in the XMLReaderSettings to false for SSIS processing? I can't find anyone who can tell me how to...

I have a database instance that is nothing but a linked server place. In it, I can do something like this... select acctkey,acctno from imsv7.account@HVDEV.world or select acctkey,acctno from imsv7.account@HVPRD.world Each time I substitute the Database environment I want to query out of. The...

I have a need to connect to a database that serves as a redirector of sorts to different database environments. In this linked database you can run the following command and get data from each of the databases that are set up as a linked server. select acctkey,acctno from...

I have a stored procedure that is acting kinda funky. I didn't write it, and so that could be contributing to my not understanding it, but I think something is fouled up and I'd like to ask for your review because data I would have thought my delete statement removed is not being removed...

Hey everyone, I have a story I'd like to share with the aim of getting some career/certification advice. I'd appreciate as much input as any one is willing to give. I got my CIS degree in 1995 from a State University Business school. I worked as a COBOL programmer for 3 years (1 company)...

Hey everyone, I have a story I'd like to share with the aim of getting some career/certification advice. I'd appreciate as much input as any one is willing to give. I got my CIS degree in 1995 from a State University Business school. I worked as a COBOL programmer for 3 years (1 company)...

I have an SSIS package that I created that looks like the following: Execute SQL Task [Determines the file name] Data Flow Task Source - Query [Grabs the data] Destination [Saves data to file on network drive] Send Mail Task [Tells user to get file from network] When...

I have a job that builds a flat file. It has a SQL statement in it that created a column like this in a flat file. select campaigntrackingcode=NULL, column2 from stmrecieved then that column, part of a larger select statement was sent to a flat file. I have since decided what to...

I found a pretty awesome UDF to parse a name, but the creator hasn't been very responsive to requests to fix a hole that I found. Anyway, I leave my contract in two weeks and I need to get a solution to them on this before then. Any chance someone could look at this code and tell me what it...

I have a problem getting a piece of SQL to run. SELECT Myfunction.* FROM [Mydbname].[dbo].monthsyear as m Cross Apply [Mydbname].[dbo].[fnEarningsByStateSitePlanMonthYear] (m.[Month],m.[year],205,'W') as [MyFunction] where m.monthStartDate>='2004-02-01 00:00:00' and...

In SQL 2000 Enterprise Manager, one was able to edit and commit data on-the-fly directly from the results pane. Action->Open Table->Query with the SQL Pane shown gives you an interface similar to Query Analyzer. One could write a complex select statement with where clauses and joins, and the...

I am trying to pass a variable to a function that will tell the function which select statement to perform. I've noticed that I can do this by using a table value function but I wanted to do a scaler value function. For simplicity, I simplified my select statement. SET ANSI_NULLS ON GO SET...

I think I spent my brain power for the day; basically I'm confused after trying to convert a SP to a function. I have a Stored Procedure that I want to convert into a Function. I basically need to pass the function 3 variables and return 1 variable. The stored procedure does it great, but...

I am on my first SSIS project and I am kinda learning as I go. The wizard has worked great, I got my SQL statement into the .dtsx project and into a flat file, with the extension I need as well. However what I really want is to have a file name that is composed of different variables. I...

(Background info: Running XP locally, MS 2003 server for the DB operating system, XI Crystal developer edition with MS SQL 2005 database using Microsoft SQL Server ODBC Driver Version 03.85.1117 – Driver.) I have a stored procedure that looks like this: CREATE PROCEDURE dbo.spSumRates --...

I have this view that is HUGE with 4 select statements that are unioned. It takes forever to run, but what is worse is that there is a program that calls this view while referencing the same view in its own from statement, probably doubling its run time. Anyway, instead of re-inventing the...