• Modifying a Stored Procedure

    The stored procedure below pulls suspected duplicate records. What I need it to do is return suspected duplicates only if it meets the criteria of having a member record type (GEN) & a non-member record type (WEB). But if the duplicates both have a non-member record type I don't want it showing up...

    DJandLO130 pointsBadges:
  • Writing a “If” & “Then” Statement in Crystal Reports 9

    Hi, I'm new to the site and reletively new to writing code so, please bare with me.  I'm trying to pull duplicate records from a field that has multiple member types {Member_Types.MEMBER_TYPE}. What I want to do is pull only the duplicate records that contain a valid member type. For example 2...

    DJandLO130 pointsBadges:
  • Announcing the Symantec Endpoint Protection 12 Scavenger Hunt (sponsored)

    Want the chance to win an iPad 2 or Amazon.com gift cards? The Symantec Endpoint Protection 12 Scavenger Hunt is your opportunity to learn about all of the new features of Symantec Endpoint Protection 12 while getting in the running to earn great prizes. Think you know about all of the new features...

    ITKE346,470 pointsBadges:
  • Free IT Book: The Data Warehouse Mentor

    The Data Warehouse Mentor by Robert Laberge will show you how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. He'll explain how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and...

    MelanieYarbrough6,345 pointsBadges:
  • How to speed up AS/400 SQL?

    We have SQL on our Data Warehouse written using SHOWCASE. The SQL could be better, it is not SO bad for something writen with a drag and drop gui, but the execution is far too slow - 12 minutes to extract data from the main 3.5 million record file, with several left outer joins. So, we created...

    Sloopy2,195 pointsBadges:
  • Free IT Book: Building Applications in the Cloud

    This week's free IT book, Building Applications in the Cloud: Concepts, Patterns, and Projects, is Christopher Moyer's guide to help you not just migrate to the cloud, but "use cloud architectural patterns that deliver superior performance, scalability, and availability." Whether you're building a...

    MelanieYarbrough6,345 pointsBadges:
  • SQL Report Help

    Hi I'm dave and I'm new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return based...

    Blowinup5 pointsBadges:
  • Tell your friends about IT Knowledge Exchange, earn 100 points!

    Tell your friends about IT Knowledge Exchange, and get 100 knowledge points closer to winning our latest contest. Simply send out this tweet to earn your points!

    MelanieYarbrough6,345 pointsBadges:
  • Tomorrow at 4PM ET: ITKE Rolls Out New Badge System

    Badges are almost here and we could use your help. Friday at 4pm ET, we will be launching the new badge system so we need you to stay vigilant and let us know if you notice anything odd with your badges, your profile, or the site. Be aware that [strong]we are planning to experience some...

    ITKE346,470 pointsBadges:
  • Contest Bounty: Earn 500 knowledge points!

    You could earn 500 knowledge points for sharing your story. Simply read this blog post and then share your story of survival. If we publish your story, we will first ask permission and compensate you with 500 knowledge points to go toward our current IT Knowledge Exchange contest . Good luck!

    MelanieYarbrough6,345 pointsBadges:
  • Crystal Reports – combining two reports into one

    i had returned a code in which i will generating two reports individually not at same time but now i want to generate at one time the two reports into a single report

    Kimidiramana30 pointsBadges:
  • Branded URL redirects are mirroring the website. Is this managed in the DNS or by the website host?

    Bvechik5 pointsBadges:
  • You Pick: Drupal’s Building Blocks, Scalability Rules, Building Cloud Apps, DTrace

    This week, you get your pick of our most recent IT book titles. Check out our latest titles in the IT Bookworm Blog for more details on these books: Scalability Rules Multicore Application Programming Drupal's Building Blocks Building Applications in the Cloud DTrace To win one of these great...

    MelanieYarbrough6,345 pointsBadges:
  • Contest Bounty: Ask/Answer questions this weekend, earn 100 points!

    Is the rain keeping your weekend plans from getting off the ground? Well, IT Knowledge Exchange has a chance for you to take advantage of staying indoors. Ask or answer 10 questions* this weekend, and you will earn 100 knowledge points, good for our current contest! Any combination of...

    MelanieYarbrough6,345 pointsBadges:
  • ORDCHG

    We are trying to implement ORDCHG functionality outbound and noticed that everytime we change the Order only the changes go through in the Idoc for ORDCHG and not the entire document , for e.g if i have an order with a text message in it and if i change the item details then only the header and the...

    Heysap5 pointsBadges:
  • Crystal Reports file error: data may have been lost

    using CR7 xp sp 3 office sp 3 when I do a export from CR7 to excel I receive the following message file error data may have been lost

    Leeanne455 pointsBadges:
  • Statistical significance and CIs for Population Survey

    Hi, I have a data set that is generated from a population survey of a licensed profession in the state. I have a 63% response rate. I am generating demographics (age, gender, race, degree level distributions) and descriptives for age, hours worked etc. How do I generate CIs and statistical...

    SOSINeedHelp5 pointsBadges:
  • Completed IT Knowledge Exchange Profile? Earn points!

    What's a community without a face? Let your fellow IT Knowledge Exchange members know a little more about you and your expertise by filling out your public profile and uploading a photo. Then put the link to your profile in the discussion area below to claim your 10 knowledge points, good toward...

    MelanieYarbrough6,345 pointsBadges:
  • Process Execution error – CD

    Receive the below CD error: from one of the process when tried NDM CD error CDE0200    Escape                  40 Message . . . . :   Process execution not allowed.                       The Process Manager is not allowing execution of processes at this...

    Iwannalearnas40055 pointsBadges:
  • Will you be at Interop Las Vegas next week?

    Grab lunch or a coffee with editor Michael Morisy to discuss what you think of the keynotes, sessions, and vendor announcements at Interop next week. Get some sweet IT Knowledge Exchange swag and let us know what you're thinking of the show and the direction of networking in general! Let him know...

    ITKE346,470 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following