View Full Version : Microsoft SQL Server
- URGENT: Need to trim the text data stored in image column
- small clarification
- Filegroup name modify error
- SQL- Table Creation using Cursors
- Removing Junk Characters
- getting uniqe rows from multi table query
- Help with a Select Statement
- How ro schedule the job and mail the desired result
- file connect,,linking datafile to datafile group
- Making a String shorter
- Mssqlservice 2008 r2
- Run query on multiple tables
- Select only most recent date
- Granting permission for a VIEW - totally confused!
- help on replace command
- Updating Across a Partitioned View
- Finding slow SQL statements
- Need a small help with parent child
- site scope monitoring tool for creating alerts
- File exist
- Changing Database Collation setting
- Need to only return rows in 5 minute intervals
- Zipping a backup a file.
- exchange server upgrade - possible issues!
- Sum Question
- numeric to nvarchar
- How to write SQL Query
- SSRS Error - Cannot read next Data Row
- Combining results of two similar queries into one result set?
- how to loop everyday for the whole year
- Merging two rows into a single one
- Stored Procedure
- After server move a query doesn't work anymore
- SSIS Julian to Gregorian date conversion
- SQL Server 2000 Installation Fail
- Conditional Formatting Expression Help
- query the names of stored procedure results columns
- Splitting alphabets and numbers in a string
- How to retrieve historical user queries
- Compare TWO Tables
- Selecting the first record in a join
- Query errors when going from SQL 2k5 to 2k8
- function returning multiple values.
- What is the best way to omit this value from my results?
- run commands only between the hours
- Calculations on fields containing non numerical data?
- fast way to move a clustered index on a half billion rows
- Bypass linked table credentials popup?
- Deploying a database question
- My First Database Design
- CHECKDB found 12 consistency errors
- Database locks
- Split single row to multiple rows
- slow SQLCMD
- Cannot install SQL Server 2008 R2 Express
- SQL OLE DB query result
- Select from multiple tables
- Connecting to SQL Server From Excel 2000
- Linked Server IN sql
- Recursive type query???
- Operand type clash: int is incompatible with text line 17 1
- SQL Server Query and Office
- Unused Space
- Three and condition in where clause not working
- Updating all records in a group
- Placeholder rows
- How to solve this SQL Exception?
- how to extract email content from email---??
- Multiple Flat Files to different SQL Tables (SSIS)
- How do I?? Maybe a recursive query??
- Join two tables and update values in one
- Update statement error
- Average number of contact hours per student
- SSIS Export
- Need Help Writing Sql Now
- MS DTC has stopped this transaction
- how to find maximum
- Large Distribution Database with Few RowCount
- New system purchase, need spec advice
- SQL server, alculating median values on a column in a table
- Nz - Null to Zero function
- FILTER For MDX Query
- how to optimize DB with command?
- Stats Update - SQL Server 2008
- Varchar(8000) issue while transferring sql server table to csv file
- Can Table created on different filegroup based on schema
- Send an Email
- Please provide sql query
- Database query
- sql inquiry
- Need a quick answer on decimal rounding!!
- SA User in SQL Server Express
- User-defined function woes
- Set date parameters within Stored Procedures
- One to Many Relationship
- After upgrade 2008 link server no longer work
- Insert Multiple Records into a single field on another table
- Would this code cause this linked server error?
- using trigger
- combine two table records by first name
- Get Time defaulters list
- Group by for different column values
- PKs, temp tables, what?
- SSIS: general question on functionality/purpose
- SQL Query Assistance - Filter for Specific
- Removing duplicate rows in grouping
- Multiple COUNT()s in Query
- Grouping on Data Change
- POS Problems
- Shrinking the log on a job
- Subquery Help
- How to export data in file
- installing SQL server, no features to be selected
- First & Last records in a group
- Can STWithin or STContains be used to update columns based on point within polygon re
- how to solve error 40 on MSSQL 2005 ?
- problem filtering
- Failed to open attachment file
- One to Many Relation ( Sql Server Back end )
- Script
- PIVOT query
- Want to insert from two tables into a single with a hard coded value
- Help w/reducing redundencies in XML output
- locating duplicate records in a table
- Question abt reading from SSIS Flat file source
- Select Query
- Checking lock granualrity in SQL Server
- Checking for deadlock over last period of time
- How to convert this date
- What's wrong with my case statement?
- Replication - Several Transactions Occurring
- Massive index size
- Sql query to pull certain row
- Database 'X' cannot be opened. It is in the middle of a restore while activating SB
- Dense / Spares Indexes
- License question
- How do i log the SQL server sessions?
- installing 2008
- Excluding data for certain criteria only
- The question about System Catalog
- Delete Duplicate Records-without primary key
- sql complex query
- sql server count of
- Help with same row values from subquery
- connect to MS SQL via Solaris (using OLE DB...)
- An INSERT EXEC statement cannot be nested
- Complicated SQL query
- convert codepage 1252 to 65001 (UTF8)
- can't connect an SQL 2000 Instance from Win 7 with enterprise Managerq
- Capture Database & Server Name in a Derived Column to identify source of data before
- Filtered Where Clause
- SQl Security - Check for specific data
- Query help, common rows, simple?
- Sum Question
- Random Behaviour with JOBS
- NPI Download Files from CMS
- Date format issue
- Smart Card
- Smart Card System for new building
- Sql Server Tuning
- [ANN] ODB C++ ORM 1.8.0 released, adds support for SQL Server
- Running an automated procedure to email when event is 14 days away
- Slow ADODB RecordSet MoveNext
- Grouping Help
- Display Duplicates which have a different state
- How to know if SQL server is still in Evaluation ?
- Adding a child Table
- Good Beginner Book For SSAS?
- Convert Help Please!
- Advice on how to combine date and time into one field
- Exclude if returned value is 0
- User Interface for Web DB
- Finding the highest current number only for an increasing range
- ORDER BY and UNION together again!
- Stored Proc insert - multiple tables
- Accounts to use for replication
- Any equivalent of runstats()
- Finding out physical size of table
- Changing a date
- retrieving only 50 chars from a detail table
- Another DB design question . . .
- How to add data to column
- sql server procedure
- Moving Postgresql to MS SQL?
- Filtering Alias Column
- sqlserver non clustered index row locator
- Help understanding query results
- Adding Info
- BCP out
- MS SQL to clean XML
- Sql Help(Update)
- Best practice to update a table
- Table Partitioning - MERGE RANGE deadlocking
- merge transformation in ssis
- Copy Wizard utility
- Ftp task
- keep duplicate with highest score fuzzy grouping
- Loop through table
- how to present utf8 in sql server 2008?
- How to cast a Varchar column to DateTime
- HELP!!-Y am i getting this error?
- SQL Spatial - All object between the coordinates
- Store Procedure Help
- Execute Stored Procedure Via Batch File
- Help with MSSQL and VBS
- Sense-checking request
- SSRS Report toggle feature hanging VS2008 IDE
- Convert Column value to Row
- Need SQL Help
- Installing SQL Server 2008 R2
- Join into new data
- Join into new data
- Finding all the SQL for a particular Session
- Getting session information
- Rotate view
- Is the following possible through SQL?
- need help with decrypting a table encrypted with EncryptByKey
- .bak size increase each time you replace the .bak with new .bak ?
- Setting up a read only user
- Hierarchy sql query
- Insert multiple rows with a trigger that invoke a function
- adding values to columns
- Join help
- How do I update the SQL Server 2008 to include the studio?
- hresult e_fail error in ssis
- Designing a date-dependent table
- back-up script
- Sending database to another person/computer
- ssis query through variable
- Query that joins two tables and retrieves a sum
- Compare time difference action
- IRR Function - Issue comparing results between systems
- Need help retrieving highest paired value
- error: user not associated with a trusted SQL Server connection
- ssis expression through variable
- How to Create a New Partition on a Cube using T-SQL in SQL Server 2000?
- Normalization and Query Performance
- whats wrong in this code ?
- BCP Password Issue
- Analysis 2000 - Migration issue
- ssis flat file header issue
- how to make a sql script that will restore by backup database ?
- Ignore Prefix
- Selecting into XML format
- Merge Replication - Phantom Conflicts
- Accessing a Report Server Url when SSRS is configured for SharePoint Integrated mode
- Oledb source query through expression
- Convert varchar to float, decimal
- Setting in ssrs server to ignore default timestamp 12:00:00 AM
- Updating Date in SQL Query (Excel Connections OLE DB Query)
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.