• Updating a Date Time Field

    I need to update the Confirmation Date Time field to NULL for a specific meeting but am unsure how to insert it.  The script below works for an individual but if they have more than 1 confirmation date it clears then all. Meet_Master.MEETING is where the meeting code AM2011 is. UPDATE   ORDERS...

    DJandLO130 pointsBadges:
  • Open IT Forum: Did you buy a TouchPad?

    HP's decision to discontinue the TouchPad (and its subsequent steal of a price) has been all the buzz the past couple days. Did you bite at the alluring $99 price tag? Tell us what went into your decision, or if you couldn't care less about the TouchPad. Do you think hackers are about to have a...

    MelanieYarbrough6,345 pointsBadges:
  • Change Initial Program

    how do you change the initial program and library for all user profiles preferrably using SQL.

    Rhinopop15 pointsBadges:
  • Open IT Forum: How do you prepare your data center for severe weather?

    Every season has its share of weather threats, and we want to know how you prepare for them. The east coast is gearing up for Hurricane Irene's arrival, and we were wondering what steps you were taking (if any) to make sure your data center doesn't see much (or any) downtime. What unique conditions...

    MelanieYarbrough6,345 pointsBadges:
  • Best book for SQL Server

    hey anybody please can anybody tell me the best book for sql server

    Naani5 pointsBadges:
  • Open IT Forum: What should system documentation look like?

    While documentation doesn't necessarily make the world go 'round, it certainly keeps it spinning neatly on its axis when trouble arises. If you're providing a product or service, you should be providing your customers with accurate information that allows them to effectively use and maintain that...

    MelanieYarbrough6,345 pointsBadges:
  • SQL query working differently in sql plus and SSSR

    I wrote down a sql query for creating a SSRS report. The query is fetching different no of rows and data in SQLPlus and SSRS. I am worried how same query can fetch different results in different environments. Please help me.

    Pradeepkiet085 pointsBadges:
  • Free IT Book: Essential Skills for the Agile Developer

    The team at Net Objectives (including CEO Alan Shalloway) has compiled the essential skills for the Agile developer. To get this resource and guide to better programming and design, simply answer one of five questions and paste the link to your answer in the discussion section below. Ultrium 4,...

    MelanieYarbrough6,345 pointsBadges:
  • problem in connect visual studio 2010 to SQL 2008

    when i am connecting the sql in my visual studio windows application to open a database file a error occurred you don't have the permission to open this file   contact the file owner or administrator to obtain the permission

    Prsaini5 pointsBadges:
  • Ageing Report T-SQL

    Im trying to write a query to retrive debtors ageing report in sql I have two tables [strong]1. Billing(billAmount,BillDate,AccountNo)[/strong] [strong]2.Payments(payAmount,payDate,AccountNo)[/strong] I need the output to show ageigng [strong]0-30, 31-60, 61-90, 91+[/strong] with the balances for...

    Sanisto45 pointsBadges:
  • Open IT Forum: Will HP be a worthy cloud contender?

    HP announced its Cloud Services program in beta and we wanted to know initial reactions. Have you registered for the beta? Share your initial thoughts, whether or not you have, and we'll return to this in the next phase of HP's cloud services. Share your thoughts and we'll share 50 Knowledge Points!

    MelanieYarbrough6,345 pointsBadges:
  • SQL Server Help

    Hi all, I am running into a little bit of a problem. I need to insert records with a stored procedure into a table based on the information selected. From the info selected, it decides what table to insert it into.  Example: Select top 1 SerialNo from dbo.Serial --returns 'ASEEADL1234567' based on...

    Cdizl25 pointsBadges:
  • Visual Basic and SQL database design

    i have vb.net & sql  application sql database have one tabe with 37 column (there is no normalization) after runing the application more than three million of rows will enterd by users . I'm afraid  it Will give a bad performance  or have (out of memory massge) so i Made a solution (i...

    msmj8675 pointsBadges:
  • Free IT Book: The Python Standard Library by Example

    This week's free IT book is an essential addition to the developer's library. If you want to master the powerful Python Standard Library through real code examples, this is the prize for you. Simply answer one of five questions and post the link to your answer in the discussion section below. Good...

    MelanieYarbrough6,345 pointsBadges:
  • Data Fields outside of report section

    I am looking at a previously written Crystal 8.5 report in which most of the data fields are outside of the report section. I can only see these fields if I reduce the report size to 50%. I have tried landscape orientation and adjusting the paper size to 11X17, but I still have many fields that I...

    Mystic15 pointsBadges:
  • t-sql and AS400

    I want to develop a TSQL query. First I need to determine if all the numbers in one of the fields are in numerical order and also find the missing holes in the number sequence. Secondly I need to sort by another field and by a particular criteria.  The words that I need to sort-by would be...

    CompEng1,185 pointsBadges:
  • Open IT Forum: Goals to round out 2011

    We're approaching the final quarter of 2011: What are some of your IT department's goals to finish out the year? What are some of the things you are implementing to position yourself for 2012? Whether it's updating your system documentation or updating your IT staff's certifications, we want to...

    MelanieYarbrough6,345 pointsBadges:
  • Create new SQL 2008 database in external drive

    My local server using SQL 2008 Express is running low on disk space. Is it possible to create new databases or move a database to an external drive? If so, how is it done, configuration wise? Thanks.

    HermanHermit15 pointsBadges:
  • Add/Rename SQL Server 2005 Server Name

    Hi experts, I have am trying to rename and add new server name to Microsoft SQL server 2005. I as using following steps for rename step 1. select @@servername ' for seeing current server name step 2. sp_dropserver 'ray' ' for deleting current server step 3. sp_addserver 'raynew', local ' for adding...

    itspirit55 pointsBadges:
  • Announcing the HP Elite Series Scavenger Hunt (sponsored)

    Today is the first day of the HP Elite Series Scavenger Hunt, designed to better educate potential customers about all of the great qualities that make HP Elite Series "elite." For details on how to enter check out the HP Elite Series Scavenger Hunt homepage. The Loot Grand Prize: 5 HP EliteBook...

    ITKE346,030 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