Recent content by iwm

There is a string I need to parse to create several columns. I am using the following statement to create the employeeID column and the Import Date column: select Substring(rowdata, 1, 9) as 'EmployeeID', substring (rowdata, 11, 8) as 'Import Date' from livereqlog Example of string to be...

I have a table that contains funding sources. It has recently been brought to my attention that there are duplicate entries in the funding source table. EXAMPLE fundName: AAA, fundNumber: 123-456-7890, departmentID: 1 fundName: ZZZ, fundNumber: 123-456-7890, departmentID: 746 As you can...

Thanks for your help. I really appreciate it!

I need assistance exporting data from an Excel Spreadsheet into an existing SQL table (table A). I used the Import Export Wizard to export the data from Excel into SQL, however that created an additional table (table B). Is it possible to export data from Excel into an existing table using the...

I need to insert a row into table "A". I was instructed to Select scope_identity() to create the ID for the new row in table "A". So I ran the following statement: SELECT SCOPE_IDENTITY() from A This statement returned a NULL value for each row. How do you use scope_identity to create an...

When I execute the following statement: sp_lock The mode colum returns an "IX" and the Resource column is empty. Should I be concerned? Is this indicative of a blocked process? Thanks in advance for your help!

The client does not want to see dates prior to Dec. 31, 1899. I used the Format Editor to suppress the date prior to Dec. 31, 1899: {Reference.beginDate}< 'Dec 31, 1899' This formula works except when the date is April 01, 2011. It suppress the date when the date is April 01, 2011. Why does...

Perhaps using the Suppress If Duplicated options from the Format Editor will solve this problem

The client does not want to see dates prior to Dec. 31, 1899. I used the Format Editor to suppress the date prior to Dec. 31, 1899: {Reference.beginDate}< 'Dec 31, 1899' This formula works except when the date is April 01, 2011. It suppress the date when the date is April 01, 2011. Why does...

Client "A" is receiving the following crystal report viewer message when she attempts to print a report created in crystal reports 9, "THE PAGE HEADER PLUS PAGE FOOTER IS TOO LARGE FOR THE PAGE". Multiple clients use this report, yet only client "A" receives this message. This leads me to...

Recognized date formats: mm/d/yy, mm/dd/yy, mm/dd/yyyy.

I created this report using Crystal Reports 9 several years ago. The description field is a string containing the invoice date and the item description. The client instructions for formatting from the description field were as follows: 1. (First character) Open parenthesis 2. Followed by...

They want the characters that are in the parenthesis to become the the invoice date field, and remaining characters will become the description field. If there are no parenthesis then the entire string should be used as the description field. Your assistance is greatly appreciated. Thanks...

I created this report using Crystal Reports 9 several years ago. The description field is a string containing the invoice date and the item description. The client instructions for formatting from the description field were as follows: 1. (First character) Open parenthesis 2. Followed by...

Everyone, On behalf of my career, I thank you! With Great Appreciation, Ingrid