Search results for query: *

Here is my code. I am working on MS SQL SERVER 2008 R2 IF OBJECT_ID('tempdb..#JAM_TMP_TBL_00','U') is not null BEGIN DROP TABLE #JAM_TMP_TBL_00 END; IF OBJECT_ID('tempdb..#JAM_TMP_TBL_01','U') is not null BEGIN DROP TABLE #JAM_TMP_TBL_01 END; IF OBJECT_ID('tempdb..#JAM_TMP_TBL_02','U') is...

I have two tables; One is a Standard Cost history table and one is a purchase order table. Both have a transaction date. I am trying to figure out a way to compare the Purchase Order Price of an item on a particular day with the Standard Cost of an that item during that time. Here an example...

I have an SSIS Solution (Package) that works fine when I run it from BIDS, but when I run if from the SSA Job Scheduler, I get a positive response, but it doen't run the package. I have tried to troubleshoot it, but now I am lost. Has anyone else had a similar experience? If so, could you...

Within a particular set of results from a query, I want to number the lines, e.g. Order 1 has 5 lines, I want to process the results to read Order 1,0 Order 1,1 Order 1,2 Order 1,3 Order 1,4 I am using the following code to achieve this, but I can't seem to get it to work. I am getting the 2...

I am attempting to send out 72 separate emails using the following code; DECLARE @cardname varchar(100), @mailrecipients varchar(100), @numatcard varchar(100), @trackno varchar(50), @docnum as varchar(50), @DocDate as varchar(50), @newBody...

I have the following stored proc. I want to embed the declared variables into the body and subject of outgoing emails, but I continue to get the error "incorrect syntax near '+'" However, when I use literals, the code works. DECLARE @cardname varchar(100), @mailrecipients...

I am sure that I am missing an escape character, but I can't figure it out. Can someone help me out? CREATE PROC sp_SendConfirmationMail AS BEGIN SET NOCOUNT ON DECLARE @em nvarchar(100), @order_id nvarchar(100),@rc int DECLARE EmailCursor CURSOR FOR SELECT...

I am logged into Management Studio for MS SQL 2005 as sa and for some reason, I can't see the user databases. I have never encountered this before, does someone have a solution? Thanks in advance, Donald

I am using the following ADO to get a ComboBox to populate and it works, but I have to use the drop down to see any of the addresses. What I am trying to do is: a. On current record return the value of Address_ID_1 b. On Insert or Update, provide the entire list Private Sub...

Is it possible to use a single .adp form to View/Add/Update a record. I have just converted my Access 2003 DB to MS SQL 2005 DB and I am able to view records, but I am unable to add or update these records. I am new to Access 2003, but I have a lot of MS SQL experience. Any help or...

Is it possible to use modules to export data at regular intervals? I have been tasked with finding a way to automatically export to a flat file on a periodic basis for upload to MS SQL Server 2005. I have already created an .adp project for the MS SQL 2005 destination database, but the data...

I have a quick question. If I use Active Directory as my authentication method for CRS XI with 3 concurrent user licenses, will it release the license once the report has been gererated through InfoView or will the user have to exit the InfoView session? Thanks in advance, Donald

I have the following query, but two things I can't seem to figure out is how to suppress the BOF from printing at the top of each 'SELECT' statement and how to compute the record count to print on line two and how to justify everything to the left (trimming all of the preceding white space...

I am using MS Access 2003 and MS SQL SERVER 2005. I have a form and a subform. When I unlink them, both forms work fine independently, but when I link them, either by the table field name or the form field name, I get an error that simply says Syntax Error. In my current scenario, I have two...

I am using Access 2003 and MS SQL Server 2005. I got the message: This version of Microsoft Office Access doesn't support design changes with the version of Microsoft SQL Server your Access project is connected to. I read in another post that Access 2003 isn't fully supported by MS SQL...

Is it possible to create a task in Oracle, e.g. I want to create a query for a report, transform that into a stored procedure, and then run that stored procedure at specific intervals throughout the day. The stored procedure would be spooling a file to a specific location for pickup by an FTP...

I am working with an Application that has purposely hidden a table from view in Query Analyzer. Is there a way to expose that table through permissions? I am logged on as sa and I am working on MS SQL 2005 SE Thanks in advance, Donald

I have the following field that I am trying to parse: SM-13496 (D1050234 - PI ) SM-13496 (D1050234 - Lab ) SM-13496 (D1050234 - Consult ) SM-13496 (D1050234 - CRO ) SM-13496 (D1050234 - CRO/CRU IG ) I want to extract everything after the ' - ' and before the ' )', e.g. PI, Lab, Consult, CRO...

How would I trim from a character right? Example: 6213 - Help a brotha out(please) I want to trim everything from ( right, leaving 6213 - Help a brotha out Thanks in advance, Donald

With the help of some of the posts here, I have learned a lot about both manual and regular cross tabs. I finally got regular cross tabs to give me the data that I need, but now I need to insert summary information into the cross tab. Specifically, I need to summarize Income, then expenses...