View Full Version : answers
- date comparison
- Where conditions, Encryption
- Remove Characters in MSSQL record
- DataArchitect Version 4.0 now available
- Attention All GURUS: Importing Mulitple MDBs in SQL Server 2005 Using SSIS
- Importing views from one server to another server
- SQL Server Data Type
- Mobile Solution with SQL Server 2005 Express edition and smartphone
- System objects problem
- DTS Job Reporting Failures
- Scheduled Jobs failing
- Sql Distinct Unique Query
- sqlserver
- Creating an append query in SQL query design
- Using table UDF in a view
- what's the correct syntax using DateFormat
- Help for Count Query
- How To Find SQL QUERY EXECUTION TIME - Very urgent Please Help
- SQL query help...
- Moving a database
- constraint in Trigger
- Difference on condition in JOIN & WHERE
- sql-problem
- create query for crystal report
- NULL <> @variable returns FALSE
- BCP - help with import/export using collation Chinese_PRC_CI_AS
- creating a table
- Full Join
- Sum question
- Naming Conventions
- Merging two rows within same table
- Specific deadlock problem
- SubSelects to JOINS
- Log File Problem
- import data
- Displaying Data Across when data goes down! Has to be easy!
- Catastrophic failures with linked servers
- Suggestions on how to convert MS Word Data Dictionary to SQL Server "Description"
- One trigger, many tables - how to automate?
- INSERT - one record at a time
- Crystal Rpts Help- Dates
- Update every row Column_3 = Column_2?
- SQL Stored Proc Executing Another Stored Proc with Multiple Values Passed
- Trying to use a batch file to run a DTS program
- FYI: Maximum # of indexes
- SQL Enterprise Eval => SQL Standard
- Visual Studio - process task & Continue without completion
- Create table as copy of existing table
- Create Table Syntax
- what is mirror table in sql server
- MSDASQL problem...
- DELETE query criteria
- SQL 2005 Express dropdown
- Getting Execution Time of a SQL QUERY through Dot Net
- Problem with procedure
- UNION Query
- changing IP addresses of MS SQL server in clustered environment
- Need to tune a table for performance gains
- Need help w/ sp_send_dbmail !
- Dynamic SQL reading statements from table
- Binary Value Manipulation
- Pivot data - with dynamic headers
- SQL help name conversion
- How can I execute a program from a Stored Procedure
- Need to go down path to find if everything is settled (recursive possibly)
- How do I sum the values of a column?
- SQL quiz
- ms sql server 2005 standard edition
- Create table using joins
- MSDE remote connection failure
- MSDE Performance Degredation
- Query help: Item below reorder level-find all items for same vendor
- XML Templates and Redirects
- Completely Stuck Importing Data to SQL 2005
- Error Converting Data Type NVarchar to Float
- not coming what i want query from two tables
- Compare Previous and Next Records
- Replicating database btw two sites why aren't the tables identical in size?
- Create One Trigger For Both Update and Delete
- Yellowfin Version 3.2
- Oracle 9i Database Administration in 10 Minutes
- How do I import Excel file into SQL Express???
- Triggers
- retrieve data from sql2005 in C#.net
- SQL Server Annoying popup upon boot
- Transform/transfer 50Gb - how to do it fast?
- Active Directory select
- SQL Server Stored Proc Issue with Java
- How to display last record entered with select query ??
- Help Please: Creating Transaction Log Backup
- Linking SQL server 2005 and Oracle 8
- How to Get 4th Largest salary without using "join" or "where" in SQL ?
- Creating a Loop to Insert Integers into a Table
- Many Databases on One SQL Server
- LOG Explorer
- MS Sqlserver 2005: Displaying only dbs user has a right to?
- MSSql VB ADODB troubles
- SQL server, Image data type pointer
- error to send mail using xp_smtp_sendmail
- Time part Problem
- Unable to retrieve data when using Greek characters in statement
- Transaction Log Backup in Bulk-Logged Recovery. help asap
- Microsoft JET Database Engine
- convert number to text
- Joe Celko coming to Seattle
- SqlCacheDependency based on what notification event??
- MSSQL query
- Database Mail: getting bounce info from Exchange?
- Database permissions possibly?
- Database Mail: detecting undeliverable from Exchange?
- Denormalized Database Inquiry
- How to Generate all grants to a user role? (SQL Server 2000)
- Updating a table if another tables row matches... not sure if that quite explains it.
- OPENQUERY UPDATE Syntax help needed
- how to use sp_cursoropen
- Monitor Object Access
- OPENQUERY UPDATE Syntax help needed
- getdate() problem: where is the time taken from ?
- Populate a Table with Stored Proc.
- Number of columns and performance
- How to get Recovery Model of a SQL 2000 Database?
- Upgrade
- Upgrade
- selecting the last 3 orders made
- T-SQL Debugger Error
- T-SQL Debugger Error
- T-SQL Debugger Error
- SQL2000 - Table Collation Error
- what is the difference between unique constraint and primarykey and identifiers
- Optional Where Parameters on Null Data
- MSSQL Audit using ArcSight
- About DateTime in SQL
- sql script
- How to Generate all grants to a user role? (SQL Server 2000)
- Regarding sql error
- Populate table with stored proc
- Microsoft SQL Server 2005 JDBC Driver 1.1 on Solaris
- MS SQL Server Slower for Persistant Queries
- Modifying SQL Server 2000 Maintenance Plans through Scripting
- Generating XSD Schema straight from SQL Server Management Studio
- Problem with Check Constraint Validation in MS SQL Server Management Studio Express
- Different UPDATE behaviors across servers
- Trigger: To fill another Database with using Stored Procedures of the other Database
- Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K
- SQL Server Integration Services please HELP
- How to call a function from a column formula in my MS SQL table
- questions about a View with a Where clause
- Transposing rows as columns
- MS SQL 2005: DB Mirroring and Log Shipping
- Assessment of Database Stored Procedures
- Failover Cluster not using all allocated RAM
- Upgradation
- Question about move large amount of data from database to database
- sql select problem
- READ UNCOMMITTED data
- Update trigger or ?
- how to update a column by using 2 or 3 tables ?
- Sql Server Import
- Restore database in SQL 2005
- COUNT many but display just once?
- Unexpected LIKE behavior
- About calender week
- MSSQL: ALTER TABLE in PROCEDURE
- Garbage at the RowEnd
- how can i go about executing these querries using joins?
- joins syntax
- Return Max Value from SubQuery
- Return Max Value from SubQuery
- Query Optimization
- timestamp ans status of database file
- complete NOOB hope someone can point me in the right direction
- differences between stored procedure and cursor
- Accessing COUNT(expr) values
- dbcc dbreindex question
- Interesting SQL problem : How to track movement history
- combining rows into a single row output
- flattening multiple source measurements into a single fact record
- SQL Select Question
- KILL Command in MSSQL Databases
- Check if record is full-text indexed
- Adding users to linked server
- Optimized SQL Pivot type query
- Function Parameter
- Cursor for a result set returned by a stored proc
- Comprehensive Index Information
- Net Address - bogus values
- C# connects to SQL Server Database
- Looping Through SQL Values
- SQL Server Integration Services HELP URGENT
- SQL Server Integration Services - Foreach Loop Container HELPPP
- FORMSOF and variable
- Visual Basic InterDatabase command keeps displaying Select Data Source screen
- Can I use C# Code in SQL Server Integration Services -Script Component Manager
- RESTORE DATABASE is terminating abnormally.
- SQL Server Integration Services HELP - URGENT
- Column naming/spacing
- Error Message: database has exceeded threshold of 85%
- Disabling or Getting Rid of Foreign Keys So I Can Drop My Table
- Backup Names
- SQL Write Access to Shared
- Snapshot of databases = Hourly job
- what is differences between cursor and stored procedure?
- What is cursor? How many Types of cursor? how to create each one?
- Sql
- The function Len; maybe a solution
- SQL server 2000
- Sql server error
- How to do a Join Using Foreign Keys in Stored in a Database Column?
- Changing collation types and the indexes that love them.
- questions on SQL Profiler
- DB Replication or Table Replication via triggers?
- Anyone lend a hand in .NET?
- how to use a SQL view as a data source for Excel file
- Bulk Insert: Unexpected end-of-file (EOF) encountered...
- Combining queries
- how to generate reprot using sql server 2000 reporting service
- How list out all tables in MS SQL?
- cronjob on ms sqlserver
- converting data(varchar & float) to money
- Very big table
- Strange error on linked server - cannot open default database
- How to copy a sql server database to disk
- Problem in creating Crystal reports
- default datetime argument in stored procedure
- Tranaction log error- can someone tell me if this error was my fault
- Problem in creating Crystal reports
- What is better to use?
- Yellowfin Argues Embedded Business Intelligence Is The Future.
- hiearchy in sql
- At my wits' end: LIKE
- Keyword Density/Count
- Update Last Record
- Access to different databases in different domains
- SP_TRACE_CREATE in MSSQL 2000
- Rants. Difficulty to learn ETL tools?
- AL-USA-PHP/DATABASE WEB HELP
- AL-USA-PHP/DATABASE WEB HELP
- Date problem
- sql server2000 how do i stop running a stored procedure
- Dynamic order by
- Paging and dynamic sort order (ASC/DESC)
- Need help writing a query
- SQL Client 2005 on Win98
- Database Mirroring Monitor Job Error
- sqlconnection open state
- execution plan for single stored procedure from profiler
- Problem with date parameter in stored procedure
- Virtual Cube Hanging When Retrieving Data & Doubling Up Problem
- Null value
- idea for database system application
- how convert date to string
- ssis - Export to a file and Rename file
- Filter records during Transactional Replication.
- WinCMD job
- XML Error message: Name cannot begin with the '.' character, hexadecimal value 0x2E
- How to Filter condition while Transactional Replication
- How To Return A "Range Of Rows"??
- Many tables or a big table with views
- Theoretical definition for the number of unique values?
- Theoretical definition for the number of unique values?
- possible to call php web service from sqlserver/mssql
- Problem to insert Display date
- Problem to insert Display date
- RESTORE DATABASE ... WITH PARTIAL
- RESTORE DATABASE ... WITH PARTIAL
- ODBC Query ... getting Where Clause
- [help SQL SERVER] Query
- Msg 102, Level 15, State 1, Line 3 in Sql 2005
- Trigger Problems
- teradata-java
- Extol Chooses Yellowfin Business Intelligence for its neural predictive analysis appliance
- record insertion from muliple sourses
- Avoiding UNIONS
- Work with 10,000+ Corp-Corp Recruiters and share Resources
- Submit Resume to 10,000+ Corp-Corp Recruiters
- For Loop
- Negative and Positve data from Sql
- Sum of Column of Blob type
- create DBF files using SSIS
- Retrieve ALL tables from ALL Databases
- How to find out MSSQL 2000 or 2005 ?
- Retain/expiration inside a backup device.
- SQL Server Performance
- looking for a query
- Split a string into multiple fields
- How to display one field from 2nd table on the 1rst table?
- change formula thru SQLServer
- How to keep tables updated that are imported from other database
- How to join tables in different databases
- Stored procedure returns duplicates
- The SQL Server management pack script "SQL Server 2000 Database Health" is unable to
- Simple query for MSSQL
- Bulk Insert with default value
- SQL Query using 'OR' Causing problems
- Best way to export data.
- Problem with replace function
- SQL Select Command - Partial Variable String
- Help needed for datediff function for SQL query
- MSSQL Profiler
- SQL - Foreign key with references of multiple tables with same primary key field
- Storing records
- transferred database
- SQL Help - avoiding querying a query...
- help needed with update trigger in SQL Server 2005
- Convert SQL Account to Windows Accounts + EXEC on ALL SPs
- problem in connection of sqlserver with netbeans IDE
- How to Delete Duplicate Record in sql server 2000
- Inner Join Not Exists
- Query Help.
- Do I need to install SQLXML?
- Limiting results to 3 most recent ID's for a group by...
- unable to begin a distributed transaction (Msg 7391)
- MSSQL with one or more users
- Cursors and Strings to Create a table with two columns
- cursors with where clause
- More XML query questions
- Performing calculation using two rows from the same table
- select distinct record only if certain column not null
- Error import
- Sql Server inserting into z/OS db2 table
- FOR XML PATH and dynamic attribute names
- How to import apache log file into a table in SQL 2000
- I am new for SQL Server please help me to write the code
- ChannelAdvisor - DBA Openings
- sql server 2000 and distribution
- Analysis Manager -copying of databse roles?
- MSSQL 2000 and MSSQL 2005 servers run in the same desktop machine
- Identifying Repeating values in a string
- Update Query
- database transfer
- Storing Many Fields in a application to one field in table
- Capture NT User ID
- Urgent help with default value Or Binding MSSQL
- Compact and Repair in an adp
- How to read second record within XML file by using openxml?
- Logging Rows Processed by various stored procedures within a DTS package
- Intermittent OLE DB connection problem -- SQL 2005 SSIS
- Help with parsing assigned groups and roles
- Combining Fields to string
- Splitting a field into multiple rows
- SQL Server 2005 full backup script
- SQL Pagination With Dynamic Order By
- Users cannot view stored procedure text
- SQL Server
- setting up asp server on xp home
- Compare to fields from two different tables with same structure
- Backup /restore DB
- writing the trigger on text field table
- Create Temp Table for getting max date
- Download Merlin Data Compass 2
- Difference between Full Join and Inner Join in SQl Server 2005
- Need Assistance with Dynamic Properties and FTP Task
- if statements in SQL Query
- xp_CmdShell
- clone MSSQL server 2000
- SQL question
- SQL Server 2005 and ASP.NET
- GUID's as a partitioning column.
- need one record from one table based on list in 2nd table
- SQL query help
- How to update selected columns of a table in SQL server db using data from a Excel file?
- Regarding DTS
- indexes and query optimization
- stored procedure help pls
- Bulk Insert Failure on DTS 2005
- Query queued
- Different Types Query
- Cascade 2 strings in stored procedure for MS SQL
- SQL Express 2005 Vs MSDE
- Problem in Creating AFTER INSERT Trigger
- MSSQL Questions - Images and Frontpage integration
- sum of derived value?
- Multiple counts(*) returning 1 record
- Naming The Database Server(s)?
- SQL database auto grow
- SQL server 2005 Express - Vista - Invalid object name '#spdbdesc'
- Sql Syntax Error!
- Linked Server and FilemakerPRO
- Linked Server and FilemakerPRO
- Pass XML file to SQL stored procedure
- Pull info from Active Directory into SQL Server 2000
- join the same table more than 3 times
- SQL Datatypes
- The old inability to toggle/change/switch between ALTER PROCEDURE <---> CREATE PROCEDURE bug (or is it a feature?)
- Combine of 2 queries from different Tabled
- hi this is dileep
- Where r SQL database tables stored ??
- Copy the Database Structure to a new DB
- How do I save a query result to a new table?
- Converting a date field to the month
- how could I ???
- DTS SQL JOB hangs even after the successful completion of the DTS
- Allowing users to truncate log file
- After Sql 2005 Install, Sql 2000 Still There
- I have a database on a network drive that I use for archiving purposes, but when the server is rebooted the database becomes suspect.
- Database Synch. Problem using i'net
- Data type in audit record
- BrainDamage
- log shipping
- getting error while installing sql server 2000 reporting services
- Backing up MSSQL Server on Windows 2003 Small Business Server
- SQL Trigger
- Combine multiple records into single row
- SSIS PAckage Hangs
- Log Shipping Issues
- pivot table without aggregation?
- Getting the results for month and year by a single SQL query
- Stored Procedure
- Cannot convert from varchar to bigint
- hi
- Run query based on values in another table
- Restoring backup from SQL 2000 to SQL 2005 but login name is missing
- Need help in writing a Stored Procedure
- Using OPENROWSET to import a textfile
- Store and retrieve objects - Please help
- USING BULK INSERT to add data to existing tables
- "cursor" what is that
- SQL Update HELP!!!
- Count and Compare 2 Tables
- connections
- Delete Time out of Date/Time column
- problem in searching data from sql
- Flat file source import to SQL databse
- Database Mirroring Transport is disabled in the endpoint configuration.
- Release Dates
- Cyrillic number
- Return Record Number with query
- data length more than ...
- How to convert lower case to uppercase through INSERT query
- Problem with connection String for remote mssql Server
- performance tuning of stored procedure
- Store unicode
- Performance : Stored Pocedure taking more parameters
- Using SQL Scripts at runtime
- Split multirow resultset to single row, multicolumn resultset
- to generate all the dates for a given month and year..
- connecting to analysis server
- Retrieving data from database and displaying it in text box
- Help Using DTS to import multiple tables into Access Database
- Group By Problem
- Referencing a field in another table as part of a formula in a computed column
- VarChar being truncated.
- SQL division of cumulative totals on one select statement
- Want the number that passed the first time.
- SUM function adding two fields in one table
- Merge data in SQL Server databases
- PLS-00201 Error
- Excel Query to SQL Server and data type manipulation on SELECT
- stuck again, if else after where clause
- importing a database into ms sql server
- SQL Server Problem
- Bulk insert error -- "Unknown version of format file"
- Update Status Field after Expiry Date
- aggregation or what?
- SQL 2005 automatically partitioning?
- Full outer join issue
- SQLAgent 2005 SP1 failed to run .bat file.
- synchronize the database
- urgent deadlock problem on Sql Server 2000
- Trigger to update a master table
- Converting string to unicode string in T-SQL
- what are isolation levels in sqlserver
- hi
- How can I join your Group
- store and retrive audio file from/in database
- Concurrency Issue
- DB Maintenance Plan SQL 2005 on 6300+ Database
- Transfer data using SSIS
- how to update two table writing only one query?
- directly deleting sql view
- Crystal Report sub-report expert advice needed.
- newb - mutiple-column join
- Group SQL Select Statement
- Indexes on SQL Server 7.0
- Syntax error in the proximity of GO
- views not updateable
- Service Broker with offline application
- error connecting to sql server 2005 from a small c++ program
- Online Connection between Access and SQL Server
- SQL stored procedure returns duplicates
- dbmail failing
- bi-directional mirroring
- Attaching data at differnet levels in a heirchy
- I hate MS Management Studio Tabs, IS IT THAT HARD to fix.
- maximum from columns
- sql server
- Can I Use If Condition In View
- xml into mssql 2000
- Clarification on Joins
- Database table data modifications with PK/FK relationship
- help with parameter in WHERE
- cascading parameters in sql server 2005 reporting services
- Table name starting with prefix tbl
- Remove spaces in a column
- Senior Database Administrator, Toronto, Canada
- install SS 2005 on win2k3 ENT or STD, which is better??
- Using count() across multiple tables
- delete syntax
- Accessing external data from SQL Server
- sql server 2000 remotely
- Comparing two databases
- Converting Rows to Columns
- Converting Rows to Columns
- Mentored Learning
- XML, schema collection and "large value types out of row" problem
- shows all the months in the result
- Server is not responding.
- Sub-Query / Cross Join / or something else?
- Complete Newbie Help
- Procedure
- max no of rows which can be updated in a table which is replicated ?
- Multiple db query call from within different context into #temp table
- How to debug sql programme
- Quick SQL Select Statement ?
- Data Feed / Make / Model Catalog
- Help needed creating select statement
- user defined type as a primary key
- which is the role with minimum permissions including a one to execute jobs.
- Database error
- help to store audio file in database
- nulls
- Which is fater to search NUMERIC or ALPHABET
- SQLServer Login as sa vs dbo
- Access 2k adp
- Append Query from Access to SQL Server
- Date query help
- Connecting PHP to MSSQL 2000?
- MSSQLSERVER trying to load deleted extended procedure
- Help with Select and IN
- Inserting foreign keys
- C# to SQL Recursive CTE Translation help
- I cannot view table content in MS SQL Server Express
- Updating 2 tables
- Europe syntax for desimal
- Updating two different dbs once with same data
- Transaction not rolling back
- How to create a .BAK file
- SQL query in an ASPX "Expressions Web" page to a database (beginner)
- Find a newly inserted record from table without using MAX or TOP
- Date Format in MS Access using a query
- Features in 2005 that work in Compatibility Mode 80
- Change connected user to avoid owner prefix in queries
- JOIN without excluding non-joined rows?
- Auto Numbering Rows
- Query for Backup Model
- StoredProcedure help
- Is it possible to avoid a loop?
- selecting max and min year
- selecting records based on date
- Importing text file fails