• ROW_NUMBER in SQLServer

    In Oracle, I can use the analytic ROW_NUMBER function to assign sequence numbers to output rows, re-starting the sequence as certain values change (e.g., there's a separate count for each deptno in this example:) SELECT deptno , ename , ROW_NUMBER () OVER ( PARTITION BY deptno ORDER BY ename ) AS...

    FrankKulash1,240 pointsBadges:
  • Problem in accessing menustrip items in VB.Net 2005.

    Hi everyone, I'm working with VB.Net 2005(.Net framework 2.0). I am having a problem in accessing the items in a menustrip of a form. Suppose there is an item in a menustrip named FILE. Under the FILE item there are 3 subitems- OPEN, SAVE and EXIT. Now, I wanna access and disable the 2nd subitem...

    Priyamtheone30 pointsBadges:
  • Problem with MSSQL? .NET application? or Win Server?

    Dear members, Please help me in regarding my problem. I am very much confused on whom to blame for the problem........MSSQL? or .NET ? or Win server? I have a dedicated server with 2GB RAM, SQL 2005, 150GB bandwidth, 160 GB disk space etc., I have created a .net application that fetches data from...

    georgesmith55 pointsBadges:
  • SQL Server Schema Best Practices

    I am in the process of establishing a "sandbox" database for a mix of users with SQL development skills. I have done this before with Oracle but not with SQL Server. What I would like to do is build a database whereby each user has their own play area. We are running SQL Server 2005 so I thought of...

    MortimerSchnurd0 pointsBadges:
  • SQL 2000 to Yukon Migration

    We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of...

    Kilaru0 pointsBadges:
  • database sql,with vb coding,first time running not fast

    we have an accounting package written in visual basic 6.0 and sql database,the problem is when we open the database the first time,it takes lot of time,but when we open it after, it will be very fast and remain fast ,even when we quit the application and restart it.

    Micus20050 pointsBadges:
  • Using MAX data types in SQL Server

    I'm new to using large data types (varchar(max))and after reading an article (Using MAX data types in SQL Server) I have a few questions. I am trying to understand how you insert such a long string (up to 2 billion char) in the database table? I am assuming this would include storing Word...

    Hank103925 pointsBadges:
  • Can I call upon the username of someone logged into the pc, and use it in a web link?

    Hi all, Basically, I've got a webpage I'm working on, and I'd like to be able to provide a link in that page, that will take a user into their home folder on the network. Since it'll be different for each user, but it uses their username as their home folder, I'm thinking there must be a way, to...

    Linger19740 pointsBadges:
  • Help with VBScripting – Beginner

    Attached is the script I'm working on for an assignment. I cannot get the count to work for the number of temps equal to the avgtemp. for each member in temps if member = avgtemp then count=count + 1 next What am I doing wrong? -------------------------------------------------------- Option...

    Chottenstine0 pointsBadges:
  • Lost Global Catalogue

    My Windows 2003 PDC recently died but prior to this I had transfered the operations master roles including schema master to my BDC. I was convinced my BDC was a Global Catalogue server but didn't get a chance to check before my PDC died. This happened just before I went away for 2 weeks and I only...

    ITBird15 pointsBadges:
  • API’s to copy data in physical volume to virtual hard disk(.vhd) file

    hi,i am using virtual server 2005.I need API's to write data into .vhd file..

    Neelu5 pointsBadges:
  • SQL Packages

    I have a query on SQL packages.Is it necessary to create an SQL package every time we connect to a remote system?Is there any other alternative?

    Sweta30 pointsBadges:
  • Query Criteria

    Hello. I have a report with multiple subreports. User enters date range when prompted from query in main report. I want to refer the subreport date criteria to the date range the user enters for the main report, via the query. I used this in the query criteria under the date...

    Bec10 pointsBadges:
  • How supply password in VBA during CompactOnClose for back-end password-protected db?

    Access 2000: Goal: to open and close a password-protected public access db (which compacts on close) and hide the "Password Required" prompt on open and on close. Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link. I have password protected...

    Dlc9ball20 pointsBadges:
  • Segmentation Fault (core dumped) C program

    Hi!.. I'm new to this, and sorry if this has been a mistake... Anyway my problem is this. I am finishing a project which utilizes a client-server mode of computing. Its basically somewhat a time manager implemented on LInux environments specifically Ubuntu LInux. The server is web-based which uses...

    CodeBreaker5 pointsBadges:
  • Dreamweaver CSS intellisense version 6.0

    Dear Sir/Madam I have Macromedia dreamweaver version 6.0 and want to know how i can enable the intellisense to work on the CSS files. Intellisense works fine when i m creating basic HTML page, but when i create a new file and choose the create CSS file the intellisense doesnt work there. The code...

    Harpz1235 pointsBadges:
  • Microsoft Solutions Framework (MSF)

    What are the advantages and disadvantages of MSF

    Gpas5 pointsBadges:
  • How to make a single row in SQL

    Dear all, Please help me I am not good in sql queries. I have a view like this. SNo Employee title Cdate IN TIME OUT TIME 258 john accountant 27/01/2008 7:28:12 258 john accountant 27/01/2008 7:28:30 258 john accountant 27/01/2008 16:03:42 258 john accountant 27/01/2008 16:03:48 258 john accountant...

    Binu.emiliya10 pointsBadges:
  • data reportsin vb

    how to do filter in database if i have to print a saperate record from a database, with the helpof dataraports, how to use tht.when ever i give give print command it will print all record that r present in the database, plz give me the details or code that i can print only a selected record. plz...

    .net,c ,c++5 pointsBadges:
  • security problem

    Hello, I have small workgroup having 10 computers in my office. I do some personal work in office like using yahoo messenger, checking personal e-mails and some online banking site. But how does one of my senior knows it? I do everything lonely and securely so that nobody in the office knows it....

    BinooDas123410 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