• 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...

    ITKE56,485 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?...

    ITKE56,485 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:
  • 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...

    ITKE56,485 pointsBadges:
  • Remote connection error using SQL Server Express 2012

    Now, I've recently added SQL Server Express 2012 to my home server. I'm trying to connect to it from Visual Studio 2012 from my machine but I keep getting this error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was...

    ITKE56,485 pointsBadges:
  • Does SQL Server 2008 lack “datetime”?

    Does SQL Server 2008 allow for the datatype “datetime”? I’ve primarily worked on SQL Server 2005. I found out about the gap when I built an entity framework model while using a 2008 database. When I tried to update the entity on a 2005 database I got the following error: The version of SQL...

    ITKE56,485 pointsBadges:
  • Cannot find server name

    I’ve just started learning ASP.net and I installed Visual Studio 2010 and Microsoft SQL Server 2008. When I connected SQL server management studio to the server message box and tried to enter a server name, the connection failed. How can I find the name of the server? Is there something else I...

    ITKE56,485 pointsBadges:
  • SSIS on SQL Server 2012

    We're in the middle of upgrading from SQL Server 2005 to SQL Server 2012. However, there's a good amount of SSIS running on this server. Can we re-deploy these packages on the new SQL instance? Will we have to go through Visual Studio upgrade for each? Thanks!

    ITKE56,485 pointsBadges:
  • Tasks solved by writing computer programs

    Identify 5 different tasks that can be solved by writing a computer program and for each task, isolate the problems to be solved?

    wakiso5 pointsBadges:
  • Having problems connecting to SQL Server 2008 remotely

    I am trying to connect to my database in Visual Studio 2010 using the named instance by 123.123.123.123/instanceNameBut, I get the following error message: error provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server I have the following aspects enabled: open Port...

    ITKE56,485 pointsBadges:
  • Using a table variable as input in a stored procedure

    Have just run into a problem. Currently our web service has been adding data to our SQL server 2008 tables by building a dynamic SQL INSERT command. It has started failing because of the data coming in. It contains a single quote in the name data ex. O' Brien. I am looking to pass the tables from...

    ToddN20006,360 pointsBadges:
  • Powerbuilder and Word OLE

    How do I insert pictures in picture content control in Word during runtime from PB (if I have 5 predefined picture content controls already saved in a Word template?

    HariharanAthmaraman5 pointsBadges:
  • Privera software

    I'm an IT beginner and I want to learn more about Privera software. Can someone point me in the right direction?

    ki7uf8tz65 pointsBadges:
  • QR Code barcodes in .NET

    How could I generate barcodes not in black and white, but still it could be scanned, it this possible?

    Alice34570 pointsBadges:
  • Why is my textbox always showing zero’s after the decimal point? (Visual Basic)

    I have a text box to where a user will insert text like 1234567. My intentions is to have that textbox add the comma's and decimal points once the focus has left it. However the results I am getting is 1,234,567.00 and not 12,345.67. Here is my code: Private Sub toothchart_TextChanged(ByVal sender...

    TryingHard125 pointsBadges:
  • Lost Toolbar

    I unchecked all of the toolbars (by mistake) in the "Customize" menu and now I can't find a location to Right-Click on to bring up the customize menu so I can restore the Standard menu. Any suggestions?

    ChuckWagon5 pointsBadges:
  • Insert data to DB2 database using VB and SQL stored procedure

    I have spent a few days trying to find a solution using Google. Has anyone had luck with this problem? Simply put we are trying to send data from our web service to our I-Series. We need to do this via a SQL stored procedure. When we do the insert dynamically it works as long as there are no single...

    ToddN20006,360 pointsBadges:
  • How to change datetime values in SQL Server?

    I want to present a datetime value without hours, minutes or seconds in SQL Server 2008? Would this code work?Statement @SomeDate datetime = '2013-09-18 16:30:22' select trunc_date(@SomeDate) ----------------------- 2013-09-18 00:00:00.000

    ITKE56,485 pointsBadges:
  • Dynamic vs. Stored Procedure table inserts

    I just finished making some code changes to get around a problem. I changed my code from doing a dynamic insert to using a stored procedure. Originally it was 20 lines of code for the dynamic process. Doing it the stored procedure way, by the time you defined all the parms it was 107 lines of vb...

    ToddN20006,360 pointsBadges:
  • Windows Forms and SQL Server 2008 database

    Now, I have created two different things: A local database and a Windows form. With the Windows form (In Server Explorer), I added the database's connection. How can I begin querying it using LING-to-SQL? Thanks!

    ITKE56,485 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