• Is this code spinning it’s wheels

    I have a piece of code which gets a transaction approval from a server which handles bank transactions. The code is supposed to be checking a returned base16 byte array to make sure all of the characters are valid. I do no believe the code does anything except check 1 character in the array. Please...

    CarlCioffi345 pointsBadges:
  • C# override all labels, textboxes etc

    Hi I have an application with many controls on it, is there anyway to override the base System.Controls label, textbox, etc, as I wish to do some changes to the methods without inheriting from it. The reason is I do not want to replace every instance of the control Hope that makes sense. Thanks...

    Cwi30 pointsBadges:
  • Convert string to Datetime in SQL Server 2008

    In SQL Server 2008, I have a string column in my table that displays data like this: "CXL P/D 08/15/13" Now, I'm trying to convert it to datetime but I can't understand how to extract only the date and change the data type. Could someone help me find the right statement?

    ITKE352,580 pointsBadges:
  • Web site

    I am using filezilla to edit and update a website. Is it safe to transfer files to a live website. Thank you very much.

    mfranmustang15 pointsBadges:
  • Help files

    What is custom HTML code in help file software, such as helpndoc? What is meant by insert/remove anchor ribbon menu in the same?

    sejithanjan5 pointsBadges:
  • Did the Database Designer change for Visual Studio 2012?

    I've recently installed Visual Studio and SQL Server 2012 onto my machine. I've noticed the Database Designer isn't as 'friendly' as the old version. Here are some of the changes I've noticed:It creates .SQL scripts instead of automatically saving my changes.I have to update different things in...

    ITKE352,580 pointsBadges:
  • How do I add items to a listbox while the script is still being processed

    I have a script that goes out and downloads files from a url. In my form I have a listbox that I use like a message queue. After each download I send a completion notice to the listbox. The problem I am having is the messages only get sent at the end of my script. In short, I download several...

    TryingHard125 pointsBadges:
  • What comes first? Visual Studio 2012 or SQL Server Management Studio 2012?

    I am preparing a fresh install of SQL Server 2012 onto a Windows 7 x64 development VM. I plan to coordinate this with Visual Studio 2012. Does the install sequence matter? Which of the two should I install first to cut down on issues?

    ITKE352,580 pointsBadges:
  • RPG array

    How can I declare array in RPG?

    prblomes25 pointsBadges:
  • How to get rid of blank areas

    I have a database that contains path diagnoses (rows) and stains (columns) used to determine diagnoses. Therefore for any single entry there may be multiple empty columns. When I make a pivot table I want to be able to show only columns with data in them.

    mensamedic5 pointsBadges:
  • Query selected data convert into XML file in AS/400

    I have 5 PF. Now I want to select data from my PF and selected data need to convert into XML. Please give me guidelines, how do I do a step-by-step?

    madhuchowdary350 pointsBadges:
  • Return a tuple of datetime objects in Python

    I want to write a function that returns a tuple of (start,end) where start is the Monday at 00:00:00:000000 and end is Sunday at 23:59:59:999999. start and end are datetime objects. No other information is given about day, month or year. i tried this functiondef week_start_end(date):start=...

    michaels325 pointsBadges:
  • Counts by time and date with

    I am trying to count logins by hour, by month, etc., in SQL Server 2008. To do this, I believe I need to create two PIVOTs or an UNPIVOT and then PIVOT? However, I can't seem to make it work. SELECT loginid ,DATEPART(MONTH,logtime) Month , DATEPART(HOUR, logtime) Hour FROM somelog (nolock) ) temp...

    ITKE352,580 pointsBadges:
  • SQL Server 2012 Express has slowed down dramatically

    I just recently moved my .NET Development over from a Core2Duo to a new Core i7-3820 machine. No changes were made to the project code and both run on SQL Server 2012 Express.For the past week, I've seen a dramatic slowdown with INSERT INTO commands. Can someone tell me why this is happening?...

    ITKE352,580 pointsBadges:
  • Using NOLOCK in SQL Statement (SQL Server 2008)

    This is more a general question but a friend of mine is in the business of making websites and applications that aren't mission critical. So with that, is it bad practice to use the NOLOCK hint in SQL Statements? He was told by an SQL administrator that he should use it if he's satisfied with a...

    ITKE352,580 pointsBadges:
  • Auto-trimming issue in SQL Server 2008

    I have a weird problem. Why in the the following SQL query does print 'equal' when run against SQL Server 2008. The database compatibility level is set to 100. if '' = ' ' print 'equal' else print 'not equal'And this returns 0: select (LEN(' '))I think its auto trimming in space. Anyone know if...

    ITKE352,580 pointsBadges:
  • Connect AS/400 to web server

    Hi, I have a requirement where I need to send data/file to server using HTTP from my AS/400 server and then receive a response back from web server. Web server is using Java/PHP to accept data files. Please advise me an approach to do this. Thanks in advance.

    AS400xml5 pointsBadges:
  • SQL Server 2012 CONCAT producing strange characters.

    Not sure what's going on here. I created the following query to produce quantity results by month: SELECT CONCAT( MONTHNAME(published) , ' ' , YEAR(published)) AS monthyear, COUNT(*) AS total FROM blog_articles WHERE status = 'Online' AND Year(published) = 2013 GROUP BY CONCAT( MONTHNAME(published)...

    ITKE352,580 pointsBadges:
  • Intellisense isn’t working in SQL Server 2008 R2

    We just got a new machine but everything was already installed on it, including SQL Server 2008 R2 and Visual Studio 2010 SP1. However, I don't have any intellisense in SQL Server Management Studio (aka it's not working). What should I do?

    ITKE352,580 pointsBadges:
  • Incompatibility issues between SQL Server 2012 and Visual Studio 2012

    I am hitting a strange error while trying to create an SQL Database project in Visual Studio 2012. Unable to open Database Project This version of SQL Server Data Tools is not compatible with the database runtime components installed on this computer. I am using SQL Server 2012 Developers Edition...

    ITKE352,580 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