• SQL select for month date range

    Hello, I am attempting to obtain a count of visits each patient comes in in one month, so for example of they were a new patient in January on the 4th, I would want from the 4th of January to the 4th of February.  The code I am attempting to use is below, but every time I use it, no records are...

    CraigN20 pointsBadges:
  • sql results to text file

    I starting using a new laptop and checked all my sql settings however when I run the same script on my old laptop and new laptop and save to file as text, the data is exactly the same but it is much larger on my new laptop. What setting am I missing on my new laptop? I already save with Encording...

    Chpern5 pointsBadges:
  • Refresh Reporting Services to view newly added sproc fields

    How do I refresh reporting services fields after I have added new fields to my stored procedure? The new felds do not show up in Report Data window. I have tried rebuild and refresh. Neither sem to work. I am using SSRS 2008

    Deeanna5 pointsBadges:
  • Setting up dbmail in SQL Server 2005 on Server 2003

    I am having trouble setting up dbmail in SQL Server 2005 running on Server 2003. I am trying to send mail through an Exchange 2007 Server. Do I need to use the SQL Service account with Windows authentication? Also on the Exchange side, how should the "receive connector" be set?

    SQL Server Ask the Experts2,585 pointsBadges:
  • TFS VSTS2010

    Hello Members,                        I am very new to this blog.I want to need some information regarding VSTS2010 TFS(Team Foundation Server).I have couple of questions in my mind. I really want to share with you. At present time we want to implemnet automation testing...

    TE0015 pointsBadges:
  • Stored procedure content

    Is there a way to "retrieve source" on a Stored Procedure ?  I need to find out what 2 of our Stored Procedures do - especially what programs thay call. Of course, no documentation and no methodology for source-based creation.  

    aceofdelts1,950 pointsBadges:
  • The IT Blog Top 10: Nov. 5, 2009

    10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent...

    Michael Morisy8,323 pointsBadges:
  • How to export/ import userschema in SQL server 2005?

    To export userschema in oracle, we can use expdp and impdp commands. Do we have any commands to export/ import userschema in SQL server 2005? Also, How to export all the tables to filesystem? Using SQL management server studio there is an option to export 1 table at a time to a file.      

    Saimadhu455 pointsBadges:
  • Effective ways for retrieving millions of records from a table?

    I have two tables -- [em]Users[/em] and [em]UserAddress[/em] -- with 30 million records in each.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Troubleshooting Data Mining in SQL Server Analysis Services 2005

    I want to run the Data Mining tool in SQL Server Analysis Services 2005, but I can only get to the processing stage: It hangs (NOT RESPONDING) when I try to go into the Mining Model Viewer. Could this be a PC or SQL config problem? How do I resolve this problem?    

    SQL Server Ask the Experts2,585 pointsBadges:
  • The most-watched IT questions this week: Nov. 3, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...

    Michael Morisy8,323 pointsBadges:
  • Converting SQL 7 Database to Excel

    Hi, I would like to know any possible way of converting my Sql 7 Database to Excel formats. Any ideas anyone. Thanks

    Bertski40 pointsBadges:
  • Date Time SQL Selection Criteria

    Hi everyone, My database table has a time field called [time], Data Type of "Numeric" length of "9" with a Precision of "14" a Scale of "0". The query below produces the following output : 2009-10-14 00:02:42.000 2009-10-28 20:15:10.000 Query : select DATEADD(ss,CAST(Left(min(time),10) AS...

    Backpedal5 pointsBadges:
  • T-shirt giveaway: Have you uploaded your profile pic yet?

    I'm noticing that some of our users who are active on the site still haven't uploaded a profile image! Remember -- having an image uploaded not only shows other users who you are; having a full profile with an avatar also makes us more likely to choose you as a "Member of the Week" or "Featured...

    JennyMack4,280 pointsBadges:
  • Select – Top 10

    Hello, I have to tables, one with name CONTRACT, second AGENT IN table CONTRACT these data: ClientID ClientName ClientSurname ContractNR AgentID AGENT data: ClientID Sum ContractNR I need to select 10 agent's clients, who have a bigest sum. One agent have 100 clients, second only 2 or one client....

    Svetlaneto5 pointsBadges:
  • Auto backup configuration in SQL2005

    How to setup an autobackup for the backup type of Full database and transaction log together as a single bakup file in sql2005.? We can setup to backup full database seperately and transaction log seperately, but i wanted these two should be a single backup file. Any suggestion pls.

    Shamoh40 pointsBadges:
  • Access 2003: Can’t filter Part-no’s by highest $Spend Plant/Site

    I have a file of Part-no with the spend by Plant (or Location).  A given Part-no may have multiple records for the different Plant Locations. I am trying to capture one record for each Part-no that included the Plant with the highest spend and what that amount is. I tried to do a summary query...

    GatorRobNC5 pointsBadges:
  • MS Exchange on Server 2000 one user can receive but not send mail

    One of my users reported that he is not able to send e-mail from his Outlook client.  I sent test messages from his Outlook client to both an internal and external address and did not receive eitehr message.  I sent him e-mail from both my internal and external e-mail addresses and they went...

    Mryansimonovich30 pointsBadges:
  • SQL 2005 will not recognize other local disks

    SQL Server Management Studio only recognizes one drive on the server, how do I get it to recognize the other Local disks?  The one disk it does see is also on the AX-100, but it will not list any of the others, even the interanl disk, as options for devices to create databases on or for backup...

    Rick2766225 pointsBadges:
  • CCSID in AS400

    Hi, i am trying to update a DBCS data defined through ODW BPCS version 6 to DB400 and i run into error SQL-332.I do not whether the problem is with the host variable.I find all the definition of variable being handled properly. Thanks, karthick

    Karthick0835 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