• How to store TOP 2 variables in SQL Server 2008?

    How can I make it so that I can store the top 2 results in 2 variables?create table t(id int); insert into t (id) values (1),(2),(3),(4); declare @id1 int declare @id2 int select top 2 @id1 = first id, @id2 = next id from tIs there a way to make this happen in one query without using a loop?

    ITKE54,900 pointsBadges:
  • Items keep hanging in SQL Server Management Studio 2012

    When I'm using SQL Server Management Studio 2012, I'm clicking on the "Databases" node in Object Explorer but it just keeps loading items until it finally hangs. This is only happening when I'm connected to a remote server, not when I'm accessing it through my PC. Does anyone know what the problem...

    ITKE54,900 pointsBadges:
  • Dreamweaver Firefox PHP

    PHP codes in calculator?

    Sjoseph5 pointsBadges:
  • Email hosting for business

    Hi, I need email hosting for my company... I found that I can buy package in web hosting like GostPapa or Hotgator and get webhosting + unlimited emails account But on other hand I found Greatmail and Rackspace for hosting emails but I can't find the difference between, beside of the price... email...

    tnobk5 pointsBadges:
  • Compiler options

    I need an example of compiling an RPG PROGRAM specifying PGMINFO(*pcml) and INFOSTMF

    COOPERL10 pointsBadges:
  • Google Adsense not approved then how to solved it my website

    My website is not approved by google adsense. tell me any idea? how to possible?

    7spkiran5 pointsBadges:
  • How do i find the IP range?

    How do i find the IP range for 172.16.4.0/30?

    Ameera20 pointsBadges:
  • Sample Microsoft Access database to capture Image from Webcam

    I'm looking for a sample ms-access database with a form that can capture an image from a connected webcam.

    Nojunk4me5 pointsBadges:
  • Kernel, Linux kernel

    Hi members, Can someone help me simply define this to a most simplest and aided examples or illustration in support to clearly understand this. " What is a Kernel?" I have heard the word over and over but I do not come to fully understand it. I search in the internet to try to fully understand it...

    patrickScott12140 pointsBadges:
  • SSRS reports in SQL Server 2012?

    I’ve been working with SQL Server 2008 R2 in conjunction with Visual Studio 2008 and 2010. I just installed SQL Server 2012 and have SQL Server Data Tools running. Now I’m trying to create SSRS reports in SQL Server 2008 R2, but I can't find them in Programs. I realize that common advice is to...

    ITKE54,900 pointsBadges:
  • i5/OS V5R4 Job Number exceed 1.000.000 What will happen?

    The system internal job counter seems to have a range from 1 to 999999. What will happen, if 999999 is reached? Will the system automatically restart at job number 1? or what? Thanks for your answers.

    acdeka5 pointsBadges:
  • Trying to ID SSRS reports

    Our company currently has over 50 SSRS reports. We're trying to assign an unique ID to each report and we're wondering if there's a way to leverage system generated information in SQL Server 2012 databases rather than manually assigning each report one-by-one.

    ITKE54,900 pointsBadges:
  • Uninstall error using SQL Server 2012

    I just went ahead and uninstalled an instance from SQL Server 2012. However, when I tried to uninstall a second instance but I keep receiving an error message saying I don't meet the requirements. What's the problem here?

    ITKE54,900 pointsBadges:
  • Computer input devices

    What is a mouse and how it work?

    mashah007125 pointsBadges:
  • How to read transaction log in SQL Server 2014?

    I need access to the read transaction log file in SQL Server 2014 for auditing purposes. In the past, I’ve used a third party log reader, but we’re looking to cut costs. I’m familiar with CDC, but that only allows access to data changes and I also need access to schema. Is there an improved...

    ITKE54,900 pointsBadges:
  • AS/400 Firmware Upgrade

    Can you provide me the steps for rollback plan when performing the firmware upgrade? We are planning on a firmware upgrade from SF240_320 to SF240_417 on our V6R1 system. And we need to submit the plan to management for approval. I need the steps for rollback in case of any problem.

    Srini050515 pointsBadges:
  • Security for SQL Server 2012 SSAS

    So I just installed an instance with SSAS only. Now, I'm curious how security (login) will be maintained. I've created one instance with engine and SSAS (Dimensional) and another instance with just SSAS (Tabular).

    ITKE54,900 pointsBadges:
  • Date, Time and numbers change format instructions for Linux environment.

    Date, Time and numbers change format instructions for Linux environment. It has to be written in English. Action button to automate Date, Time and numbers setting on Linux environment. This action button must work as an embedded button on a mail, in order to be able to send it to the user, and user...

    harshapahadiya5 pointsBadges:
  • Upgrade from system i 5.4 to 7.1 skipping 6.1

    Has anyone upgraded directly to 7.1 from 5.4 skipping 6.1? Any gotchas not obvious. What's your experience. Thanks.

    OldSysAdmin945 pointsBadges:
  • Lotus Notes template

    Lotus Notes 6.5 mail template illegal circular use core-emailer; I have a customized mail template and am using Domino 6.5. Each time my users open mail or create a new memo we or they get "illegal circullar use coreemailer." I have to click it between 6 to 10 ten times before it goes off and after...

    charleskanzim30 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