Reformatting SQL Data in a Field
Hi, I’m new to the whole SQL experience and need help converting some data.  In our Activity table, data was imported into the UF_4 field incorrectly.  We want to convert this data “from a Decimal format” to a “NonDecimal”.  Currently the data looks like 5234.000 and we want it to look like 5234 Thanks in advance [...]

Answer Question   |  August 13, 2009  3:42 PM
SQL, SQL 2005

ACCESS 2007 and SQL Server 2005 Schema Updates
We have several clients with access to reports (provided via Views). The reports for each client are separated by being under a different SQL Server 2005 Schema. Obviously we can get each client to link to their Views but the client wants things to work like an ADP – that is, as reports are added, [...]

Answer Question   |  August 13, 2009  2:56 PM
Access 2007, Microsoft Access, SQL Server 2005

PRINT statement in Stored Proc SQL Server 2005
Does PRINT statement in stored proc cause network traffic or any performance issues? Can i get some tips to write good store proc that gains performance.   Thanks.

Answer Question   |  August 12, 2009  6:27 AM
SQL Server 2005, SQL Server stored procedures

T-SQL query to ACESS 2007 database
I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks

Answer Question   |  August 11, 2009  6:32 PM
Access 2007, Access Database, SQL Server 2005, T-SQL, T-SQL Stored Procedures

Tuning SQL query with hierarchy result through DB link
I have the below SQL query: /********************************************************************************************************/ SELECT tm_super.tm_nbr ,tm_super.tm_fname ,tm_super.tm_lname ,tm_super.super_tm_nbr ,tm_super.super_fname ,tm_super.super_lname ,tm_super.super_job FROM (SELECT papftm.employee_number tm_nbr ,paaftm.supervisor_id tm_super_id ,paaftm.person_id tm_person_id ,papftm.first_name tm_fname ,papftm.last_name tm_lname ,papfsuper.employee_number super_tm_nbr ,papfsuper.first_name super_fname ,papfsuper.last_name super_lname ,UPPER(pjsuper.name) super_job FROM per_all_assignments_f paaftm ,per_all_people_f papftm ,per_all_people_f papfsuper ,per_all_assignments_f paafsuper ,per_jobs_v pjsuper WHERE papftm.person_id = paaftm.person_id AND paaftm.supervisor_id = papfsuper.person_id AND [...]

Answer Question   |  August 11, 2009  7:22 AM
DBLink, SQL tuning

Display Bug with CFTextArea?
Is there a bug or a trick needed for cftextarea to display DB retrieved query data? When I try to display a single retrieved MS-SQL varchar value in a cfwindow dynamically created form, I must refresh to see the value. A HTML textarea control on the same form displays properly. Multiple query rows display fine [...]

Answer Question   |  August 7, 2009  5:02 PM
SQL, SQL Database, SQL Display

Adding data in SQL 2005 server
i am trying to add data on an sql database from backend problem is it does not acceptnull values kindly help. My email address is edmuia@yahoo.com

Answer Question   |  August 6, 2009  2:00 PM
SQL Server 2005, SQL Server database

view active directory data using SQL server 2005
How could I view active directory data using SQL server 2005. For example I have all of the data available in Human Resource system and I would like to pull some of the information to the active directory like name, position and department … ext where the user name is primary key. Thanks alot for [...]

Answer Question   |  April 13, 2010  11:25 AM
Active Directory, SQL Server 2005

SQL Server 2005 – Unable to Eun a Pull Subscription due to “unable to connect to distributor” error
I have 2 Windows server (Windows Server 2003) running SQL Server 2005. Server 1 is the distirbutor and publisher. For a snap-shot replication, I have no problems running a push subscription from server 1 to server 2. However when I try to set up and run a pull subscription on server 2. It fails due [...]

Answer Question   |  August 17, 2009  9:37 AM
SQL Server 2005, SQL Server replication

Changing the sql server service and agent windows account password
Hello, we are considering changing the sql server service and agent’s password. What all should be considered prior to doing this? This will include doing this on 2000, 2005, and on clusters. Thanks!

Answer Question   |  August 5, 2009  4:09 PM
SQL Server Agent, SQL Server authentication, SQL Server security, SQL Server Services

SQL Server 2005 question self join query
I have one table that name is TblCategory on that 2 columns are CategoryName another column name is UpperCategoryID my table is like this CategoryName UpperCatID ———— ———– Book Commerce Commerce Accounting Science Math Commerce B.O. Material Pen Pen Link Pen Renolods I want ouput like CategoryName ———— Book Material

Answer Question   |  August 5, 2009  10:36 AM
SQL Server 2005, SQL Server Query, SQL Server tables

Exporting SSRS Report in Simple Excel sheet(not formatted)
Hi All, when I export and ssrs report in excel, it gets exported in excel but in a fancy format. I want to export the data in a simple excel sheet format so that I could apply filters or formulaes. If any one of you are aware of this do let me know please. Avhilash.

Answer Question   |  August 5, 2009  10:11 AM
Export SSRS Report to Excel, SQL Server Reporting Services, SSRS, SSRS 2005, SSRS reports

SQL Server 2008: Difficulty setting mixed mode authentication password
I am attempting to install SQL Server 2008 (64-bit) on Windows Server 2003 SP2 (64-bit). During the installation, I get stuck at the step where it asks for a mixed mode authentication password. Following the requirements, I have tried a strong password but I am still getting the error message, “The specified SA password does [...]

Answer Question   |  August 4, 2009  6:31 PM
SQL Server 2008, SQL Server 2008 64-bit, SQL Server authentication, SQL Server installation, Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 R2 x64

SQL Select: Getting the previous records from a known record
I issued a select statement like this: Select phone# from pltlcd where phone# >= 985143525 fetch first 20 records only PLTLCD is a file sorted by phone#. From the first record retrieved by the aboe select statement, how do I get the 20 records in the file that exist before the returned set of the [...]

Answer Question   |  February 29, 2012  4:37 PM
SELECT statement, SQL Select, SQL Select statement problem

Encrypt the password in SQL 2000
How to pass encrypted passwords in connection string in asp/vb using sql server 2000. Im trying to create a new user login for the applications using SQL server 2000. However want the end users to avoid viewing the login credentails for sql server 2000 in the connection string part. Hence prefer to pass the encrpted [...]

Answer Question   |  August 4, 2009  11:53 AM
ASP, SQL Server 2000, SQL Server encryption, SQL Server security, VB

Estimate SQL Server tempdb space for a query
Database – MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge – about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns [...]

Answer Question   |  August 3, 2009  7:46 PM
Space allocation, SQL Server, SQL Server Data Storage, TempDB

Recovering lost SQL Server 2000 data
I lost a LDF file for SQL server 2000 — but I have the MDF. How can I recover my data?

Answer Question   |  December 13, 2010  6:47 PM
Data Recovery, LDF, MDF, SQL Server 2000, SQL Server backup and restore

Error during SQL Server 2000 installation
When I attempt to install SQL Server 2000 using Windows XP Service Pack 2 for IT Professionals and Developers, I encounter the following error: “Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client components will be available for installation” How can I fix this problem?

Answer Question   |  September 7, 2010  6:43 PM
SQL Server 2000, SQL Server error messages, SQL Server installation

unable to connect to SQL from Access
I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version [...]

Answer Question   |  August 3, 2009  6:10 PM
Access 2007, Microsoft Access, SQL Server 2008, SQL Server to Microsoft Access

Filling data in datagridview in vs2005 with windows develpment
HI all I have a more than 80000 data in sql server 2008 in a single table. Then i have to show that data in datagridview. But the performance has very slow some time my machine hang. It has taking several minute. So i have to improve this performance could anybody help me. For information [...]

Answer Question   |  August 10, 2009  6:56 AM
DataGridView, SQL Server 2008, VB.NET, VB.NET 2005, Visual Studio 2005