16801:
CASE function in SQL
16802:
uniqueidentifier vs IDENTITY ... not the same old questions
16803:
Time lapse in sql
16804:
Get Hierarchy
16805:
How to generate Sequence numbers for a primarykey (string datatype)
16806:
Recursive Triggers
16807:
Uniqueidentifier Type, Keys and Efficiency
16808:
select 5 from UK, 5 from Germany etc...
16809:
reporting services on flat files...
16810:
Explain this query please
16811:
intermittant OLEDB query failure
16812:
Which Column Has the Data?
16813:
troubleshooting ado.net ?? displaying parsed sqlcommand commandtext?
16814:
Cannot add parameter to stored procedure, causes sp failure called from old ASP page
16815:
ADO XML (XHTML) SQL and DOM
16816:
How to not use distributed transaction?
16817:
Is SELECT MAX(ID) expensive when you have an index on ID?
16818:
Date Only from Date/Time data
16819:
SQL Job output to file
16820:
Problem with datetime variable
16821:
How can I use the ODP.NET at the TVF in my SQL Server 2k5?
16822:
Select all but one column
16823:
Records in table 1 but not table 2 with a composite primary key
16824:
Rollback a "Force restore over existing database"
16825:
Column Names
16826:
Calculate Averages
16827:
DTS help
16828:
How to check for full backup before a log backup
16829:
How to find and file's date and version using SQL server queries
16830:
View SQLServer Linked Server Processes
16831:
Error with Microsoft.SqlServer.BatchParser
16832:
Alternative to a cursor
16833:
Help with a sql statement, grouping and Count
16834:
SQL Syntax question
16835:
Complicated SELECT question
16836:
Complex Select
16837:
Outputting the number of records returned from a stored procedure
16838:
Stored Procedure Syntax
16839:
Complicated Insert question...
16840:
Parameters in Stored Procedures
16841:
Format Date predefined
16842:
Stored Procedure to delete duplicate records
16843:
How to create SQL Server Job from script
16844:
Length of string
16845:
Sequence of dates in a query
16846:
FAQ System
16847:
Is this possible?
16848:
null value issue in stored procedure...
16849:
Insert multiple records in a table
16850:
Match your Design site data schema and SQL statement to Application site
16851:
IF EXISTS then Update ELSE Insert
16852:
Backup database permissions problem
16853:
LOGIN Scripting
16854:
Accessing AS/400 Db2 with IBM's OLE/DB driver
16855:
Finding the rows that do not match
16856:
Handling osql error within batch file
16857:
Deploying sql server databases
16858:
Jion with null values
16859:
LEFT JOIN & RIGHT JOIN
16860:
Removing triplets
16861:
Error when users Increases
16862:
Newbie, sending text message to mobile device and SQL Server
16863:
openrowset or opendatasource
16864:
expression for "anything"
16865:
Could not find stored procedure
16866:
"Best practice" table/query structure sought
16867:
Adding a select into SQL statement
16868:
Migrate / Read Access data file(s) in SQL Server
16869:
Insert New Record
16870:
Insert Record
16871:
aggregate problem
16872:
Problem with view
16873:
Averaging time
16874:
Fatal Error 8520 (SQL Server 2000)
16875:
2005 backward compatibility question
16876:
Append Room numbers fields by Building
16877:
SQL Date Query help
16878:
Creating a Custom Warning/Message
16879:
Handling Nulls in several columns
16880:
SQL Code to Retrieve last week's data.
16881:
getting job_id from sp_start_job
16882:
How to get the database names with the active connections to the server?
16883:
Tricky Query ( For me at leaset )
16884:
SQL Server 2000 Ranking
16885:
help needed
16886:
Listing all Functions in a Database
16887:
Help with pro-rating annual amount
16888:
Help with Select
16889:
SQL Query
16890:
dbcc checkident to external server
16891:
problems with distributed transaction
16892:
Specs for SQL Server client machine
16893:
Forward engineer stored procedures from vss SQL 2005
16894:
Cannot connect to Analysis service!!! Help!
16895:
Tracking Errors
16896:
IIS Virtual Directory Management for SQL - deploy on Web or Database Server?
16897:
update triggers with sum values
16898:
Union Query Help!
16899:
ajaxulation question
16900:
Saving Object Explorer Settings in SSMS
16901:
backup database
16902:
Why selecting from stored procedure is disallowed?
16903:
Trigger for UPDATE, INSERT
16904:
A GOTO statement references the label
16905:
Database structure problem...
16906:
Get the latest date of a product price
16907:
display as columns instead of rows?
16908:
SQL crl stored procedure output
16909:
Export
16910:
Check for column exists (sql 2005)
16911:
Calculated field question
16912:
Script Object
16913:
Inserting data for two tables at the same time
16914:
Each GROUP BY expression must contain at least one column that is not an outer reference??
16915:
cursor to insert into a table variable
16916:
Help modifying stored procedure sql 2005.
16917:
Databse project group vs2005 missing
16918:
Self Linked Server
16919:
server management studio insert row to table Error
16920:
Fastest way to import
16921:
necessary help-database mirroring
16922:
How to limit number of columns by a parameter in SELECT statement?
16923:
Getdate() & Function
16924:
Stupid Question: Joining Strings
16925:
Edit Database Table Directly
16926:
Linked server
16927:
View question
16928:
Operators "<>" or "NOT column ="
16929:
Match your Design site's data schema and SQL statement to Application site
16930:
Included Column
16931:
Programming resources
16932:
[SQL Server 2000] TRUNCATE TABLE
16933:
diagram
16934:
INSERT INTO
16935:
SIMPLE INSERT QUESTION
16936:
Predict stored procedure output dataset?
16937:
Necessary Helo-Database mirroring
16938:
INNER JOIN only on certain conditions problem
16939:
Newbie-how to determine what fiscal year
16940:
line break in nvarchar field
16941:
Run File .sql From SQL.DMO
16942:
Once again its on...(Query Strategy)
16943:
Question on CLR Stored Procedure
16944:
Datetime type
16945:
UDF Question
16946:
How to update the many side table
16947:
trouble with Exec(...) statement.
16948:
Cursor Detect and Cleanup?
16949:
Best practice for declaring a variable varchar(MAX)
16950:
Object Search
16951:
Reporting Services
16952:
Column name in a variable
16953:
FYI
16954:
Finding the Calculated Difference between rows
16955:
"Invalid Cursor State"
16956:
Compare the columns in two tables
16957:
Gender Function
16958:
Scaling Out with SQL Server 2005 Express
16959:
FAST_FORWARD
16960:
Multi Server Jobs
16961:
Better way to do this?
16962:
SQL Challenge #1
16963:
paging with row_number() - how to return total record count?
16964:
[?] question
16965:
www.OutpatientSurgicare.com/video/
16966:
Applying a unique ID
16967:
Want to avoid using cursor
16968:
Is this query possible?
16969:
Help on Query
16970:
Convert Numeric field to Date field
16971:
Database Mail
16972:
MI5 Persecution: Website Index (2509)
16973:
Are these queries possible without cursors or a while loop?
16974:
String Manipulation
16975:
MI5 Persecution: Dirk Gently on the Toronto Case (710)
16976:
Concatenating rows with carriage return
16977:
Count var number in a table
16978:
msdb..sp_start_job Launching NOW and getting Instance_Id back for lookup up status
16979:
Text column truncating
16980:
Inner query Question
16981:
URL get cutoff in SQL
16982:
Disregard fields in a Stored Proceedure
16983:
Excel-->sql server
16984:
Stopping a SQL Query when a particular calculated value is met
16985:
The hierarchical join -- solution
16986:
Query which calculates a field value based on previous row's values
16987:
Declaring a Cursor with a Where clause value set at runtime
16988:
Problem with my modelisation
16989:
Best TSQL coding approach
16990:
Slicing database by company_id colum
16991:
Pull Last Record from Table
16992:
Total sum field with PIVOT?
16993:
Total sum field with PIVOT?
16994:
Identity Column
16995:
Collation changing script
16996:
Function to find the max of two dates (SQL2K)
16997:
How can i select data from a table with a custom span of record number
16998:
executing console application to create excel from database
16999:
beginning SQL server 2005?? [C# .NET 2.0]
17000:
Distributed Query Problem...
17001:
Sql server to Excel DTS problem
17002:
SQLCMD Informational Messages
17003:
Finding offending rows in a self relating table
17004:
Can this be done?
17005:
how to disable database cache for large result set
17006:
Design question - Single table with many relationships
17007:
selecting records #20 - #30 from recordset of 100
17008:
The GO statement and full recovery
17009:
How to query info from a second table for multiple IDs in the first table?
17010:
Update Query Help Needed for SQL Server 2000 - URGENT
17011:
How to get a where clause with dates between specific months?
17012:
physical location of file
17013:
Matrix Control help... need row sum
17014:
use in then get array string from table
17015:
Padding an interget with '0' to produce a leading zero string
17016:
scheduling a stored procedure from sql/ado.net
17017:
sql print color
17018:
Help with Update Script..
17019:
How can i use a "Table" variable in a dynamic sql query?
17020:
Upon INSERT Code 80040E14 Must declare the variable
17021:
I know this must be a simple query ...
17022:
Production Database
17023:
HELP!!!!! - reading XML data out of sql2005
17024:
Defining Alert for System Errors
17025:
Create Relation Cross-Tab from Flat Table?
17026:
How to get ALTER scripts of all SPs in a DB
17027:
MCQ Questions
17028:
creating table with Create Table
17029:
sql query needed to 'merge' rows (not easy.. been trying a couple days)
17030:
sql query needed to 'merge' rows (not easy.. been trying a couple days)
17031:
Help me before i get mad SQL Query
17032:
Strange problem: Warning: Null value is eliminated by an aggregate or other SET operation.
17033:
Collation Problem 2
17034:
18452 error on sql2005
17035:
Consistency error using DBCC CheckDB
17036:
printing problem with MS database diagrams
17037:
Inventory application schema
17038:
Sort order and view
17039:
Collation Problem
17040:
Correlated sub query on joined table
17041:
Clients for Analysis Service
17042:
Help finding out if DB exists...
17043:
SQL transaction in multi-threading environment
17044:
Mixed mode does not work SQL2005
17045:
Mixed mode does not work SQL2005
17046:
'set ansi_nulls on' when modifying a stored procedure
17047:
Multiple Threads in SQL CLR
17048:
VERY strange issue with SQL 2000 + ADO Command object
17049:
Page File usage high
17050:
Send/Fetch text file to FTP site.
17051:
Scheduling stored procedures
17052:
vb and sql express
17053:
storing a .pdf file in a database table...
17054:
Update Limit
17055:
Translate This Syntax?
17056:
Very beautiful
17057:
Provider list empty
17058:
Bulk Insert from Excel File???
17059:
Bulk Insert from Excel File???
17060:
Running Balance in view
17061:
Suggestion for relation of these tables?
17062:
Stored Procedure Parameter Type References Table Type?
17063:
Cursor - retrieving data
17064:
refreshing views and functions
17065:
ASYNC_NETWORK_IO while inserting into DB
17066:
update only updated columns
17067:
Exchange data
17068:
T-SQL problem
17069:
FOREIGN KEY to NULL
17070:
Querying two dates never worked for me? Why
17071:
Help regarding QUERYING BETWEEN TWO DATE FIELDS WITH TWO PARAMETERS
17072:
Query timeout
17073:
SQL Server Process vanished
17074:
Version of sql server
17075:
ISQLW OSQL SCLCMD ?
17076:
SQL Personal Edition Equivalent in SQL 2005
17077:
show records not created yet for a date range
17078:
Remote query timeout apparently
17079:
Error using OPENROWSET. OLE DB error trace.
17080:
how to create filegroups dynamically
17081:
Looking For Set-Based Solution
17082:
Sql smo server processes enumeration problem.
17083:
Data types and clustered index.
17084:
calling CREATE ASSEMBLY on unsupported framework assembly (System.Web.dll)
17085:
Trigger Question
17086:
Need to optimize SQL statement
17087:
Sequential Numbering
17088:
Getting just the datepart of a datetime value - How?
17089:
How to get column headings on a job in DTS
17090:
Query Help ( count )
17091:
Re: File download from website
17092:
File download from website
17093:
memory usage
17094:
What would be the most effecient way to import from this text file?
17095:
Sql Server 2000 (NEW SP4 installed) Access ADO EXEC call fails when variable names are passed
17096:
ORDER BY on a varchar causing degradation
17097:
Monthly Summary Report
17098:
Self Join Does'nt work !
17099:
Database Backup
17100:
Is my syntax wrong? This must be simple but...
17101:
Which is best, SET or SELECT?
17102:
Which memory options to set
17103:
what is PREFETCH
17104:
SQL SERVER 2005 DATETIME format inconsistency between select and insert/update
17105:
Transactions and Locking
17106:
'NULL' string in csv file
17107:
SQL - Fast LOCALHOST , Slow IP
17108:
Recursive Trigger
17109:
necessary help-problem in creating database mirroring
17110:
sending default parameter to function
17111:
Complex Systems
17112:
NOT IN
17113:
Search word in the table in database
17114:
Order by col = value
17115:
Cursor quirk
17116:
Simple Store Procedure Question - Passing in a blank.
17117:
SQL 2005 consume Web Services
17118:
Full-text search wrong ranking
17119:
Column for storing any kind of text?
17120:
assist with query
17121:
How to use stored procedures for controlled data modification?
17122:
Help with a query please
17123:
Query help
17124:
query help
17125:
Query help
17126:
How can I return an effective date as a start date and an end date
17127:
Sending html-mail from sql server 2005
17128:
vb2005 applicaion conflicts with SSMSE when connect to local SQL server express 2005?
17129:
Help - made stupid mistake on install of 2005
17130:
SQL 2000 not for replication
17131:
cross join from two tables where primary key of each table does not exist in a third table
17132:
Modifying system tables in SQL Server 2005
17133:
How to combine sums of two separate queries
17134:
why this is not working
17135:
what is the scope of command 'set datefirst'?
17136:
Necessary Help-Problem with creating view index
17137:
Displaying rows vertically.
17138:
query help!
17139:
return value from insert statement
17140:
How to:Make a view index
17141:
deterministic UDF causes reads on *some* servers
17142:
Restoring backup SS 2005
17143:
Insert Spaces in the text
17144:
How to debug
17145:
Multiple Replace([ ?
17146:
how to change views column data type
17147:
Documenting database
17148:
How to know when server started
17149:
OUTER joins, aggregates, and WHERE clause
17150:
copying stored proc to another server