|
39502
|
Complicated Union/Subquery Join?
|
|
39501
|
NEED HELP IN CODE: NOT A VALID IDENTIFIER (openrowset)
|
|
39500
|
TRIGGER
|
|
39499
|
Showing who has a table locked
|
|
39498
|
Manage multi SQL Server
|
|
39497
|
Dynamic SQL Query
|
|
39496
|
MAXDOP Recommendation
|
|
39495
|
Another trigger issue
|
|
39494
|
Inserting only non existing rows
|
|
39493
|
how to connect to MDF file with classic ASP?
|
|
39492
|
Order clause in a view differences between 2000 and 2005
|
|
39491
|
Rows to Columns
|
|
39490
|
new to 2005 Service Broker question
|
|
39489
|
Islam, the Religion of Ease
|
|
39488
|
Help in writting query
|
|
39487
|
Backup Information
|
|
39486
|
rest assure about the date
|
|
39485
|
While Loop Question
|
|
39484
|
Can a table column be used as a parameter?
|
|
39483
|
The database could not be exclusively locked to perform the operation.
|
|
39482
|
"The multi-part identifier "Users.RecID" could not be bound" error on simple update
|
|
39481
|
Seeking a clever in-query SQL solution to sequences
|
|
39480
|
Calling stored proc and running procedure sql give different resul
|
|
39479
|
proc an sql query yield different results
|
|
39478
|
Result Set
|
|
39477
|
Concurrent Connections
|
|
39476
|
Reporting services trial software
|
|
39475
|
Getting the records count from a cursor
|
|
39474
|
Need to provide documentation
|
|
39473
|
State of the Art Software Development Practices
|
|
39472
|
BULK INSERT suddenly slowed down dramatically
|
|
39471
|
userdefineddatatype with datatype comparsion
|
|
39470
|
troubleshooting
|
|
39469
|
How to emulate this TSQL in C#
|
|
39468
|
Hyperlink Column
|
|
39467
|
syntax to determine if constraint exists
|
|
39466
|
builtin functions help
|
|
39465
|
error 443
|
|
39464
|
Warning in Event Viewer
|
|
39463
|
Outer Join and null values as zero(0) query
|
|
39462
|
Calculate percentage of columns.
|
|
39461
|
ownership
|
|
39460
|
VARBINARY Conversion
|
|
39459
|
Protecting sheet with update vba script
|
|
39458
|
equivalent of MySQL's SQL_CALC_FOUND_ROWS function?
|
|
39457
|
Visual FoxPro 9 tables to SQL Server 2005 tables!
|
|
39456
|
Select top .... order by
|
|
39455
|
Data transfer
|
|
39454
|
INSERT Procedure
|
|
39453
|
Group By Week
|
|
39452
|
Dynamic TODOs in VS2005 SQL files
|
|
39451
|
DB Maintenance Plan SQL 2005 on 6300+ Database
|
|
39450
|
Computer Programmer Job Available!
|
|
39449
|
Try Catch in a user function
|
|
39448
|
Returning rows with duplicate fields
|
|
39151
|
Min and second Min
|
|
39150
|
see???? the???? most/????? hot?????? new?????? site???? of/???? 2007????
|
|
39149
|
BULK INSERT, "String or binary data would be truncated."
|
|
39148
|
How to Count Averages? Newbie Needs Help
|
|
39147
|
Run a Stored Procedure for every row in a select?
|
|
39146
|
sniffing mssql;)
|
|
39145
|
pivoting one column
|
|
39144
|
enumerate records
|
|
39143
|
trigger to determine if row is inserted or updated
|
|
39142
|
equivalent of date() in sql statement
|
|
39141
|
monitor folder
|
|
39140
|
ASP.NET 2 Data Binding with SQL 2005 XML
|
|
39139
|
How to select one of two columns?
|
|
39138
|
SQL Role
|
|
39137
|
Simple Newbie Question (I hope) -- Subquery using 1 table
|
|
39136
|
DELETE records.
|
|
39135
|
Testing Enum values in Stored Procedures
|
|
39134
|
Execute XML code in trigger
|
|
39133
|
possible to determine weekday with Tsql?
|
|
39132
|
DTS package in SQL Server Management Studio
|
|
39131
|
SQL SERVER 2005 BCP question
|
|
39130
|
BUG 2005 ?
|
|
39129
|
Setting transaction isolation level when reading from a view
|
|
39128
|
SSIS Script task and Server.MapPath
|
|
39127
|
Strange Error ?
|
|
39126
|
SQL Server Fill Factor question
|
|
39125
|
Stored procedure: exec with variable column name
|
|
39124
|
sql replication rights
|
|
39123
|
SQL query on multiple databases
|
|
39122
|
best way render date in MMDDYY format
|
|
39121
|
Optimizing Sub Queries
|
|
36991
|
how to view tables?
|
|
36990
|
Unable to create new view in database
|
|
36989
|
SQL Server Error 1205, State 50 while reading a view
|
|
36988
|
XML + schema collection + "large value types out of row"
|
|
36987
|
Help needed on a Inner Query.
|
|
36986
|
Multiple results on one line
|
|
36985
|
I need help with ssis logs
|
|
36984
|
how to select only the last x columns from a table
|
|
36983
|
Replication with SMO/RMO
|
|
36982
|
Patindex and greed ..only want first
|
|
36981
|
variable column count
|
|
36980
|
index
|
|
36979
|
Case insensitive for OpenXML
|
|
36978
|
Issue with returning large number of rows in SQL-DMO
|
|
36215
|
query structure (newbie)
|
|
36214
|
LEFT OUTER JOIN That Doesn't!
|
|
36213
|
Benefits of uniqueidentifier and Int
|
|
36212
|
Store Procedure Running slower gradually day after day
|
|
36211
|
Right Outer, Right
|
|
36210
|
Query with subquery in Where clause returning multiple values
|
|
36209
|
Is SQL 2005 buggy?!
|
|
36208
|
xp_sendmail on error
|
|
36207
|
Stats
|
|
36206
|
Getting error "Either BOF or EOF is True..."
|
|
36205
|
check divide by zero
|
|
36204
|
RANK()
|
|
36203
|
DTS to SSIS
|
|
36202
|
How to: Deny INFORMATION_SCHEMA view
|
|
36201
|
1 query and 2 results??
|
|
36200
|
Select Item - item Detail with twist
|
|
36199
|
my stored procedure's unexpected return
|
|
36198
|
CTE performance!?!?!!?
|
|
36197
|
Select SQL Script in 2005
|
|
36196
|
try catch handling
|
|
36195
|
SQL2000 Filesystem Permissions Error
|
|
36194
|
Try/Catch block is altering error message
|
|
36193
|
trying to make into function
|
|
36192
|
Function results to update table
|
|
36191
|
BCP error - [ODBC SQL Server Driver]String data, right truncation
|
|
36190
|
Error msg Alter Authorization
|
|
36189
|
SQL Server Courses
|
|
36188
|
Using SMO, how to find column by name
|
|
36187
|
Looking For Programming Job?
|
|
36186
|
modified date-time
|
|
36185
|
Create key column value
|
|
36184
|
DTS Packages and exporting multiple records from a single record.
|
|
36183
|
Restore BackUp
|
|
36182
|
Incorrect syntax near the keyword 'As'
|
|
36181
|
help with stored proc while loop
|
|
36180
|
insert command help, please
|
|
36179
|
Help with pivot
|
|
36178
|
Help on easy Join-Clause needed
|
|
36177
|
Error converting data type varchar to numeric
|
|
36176
|
Updating a Very larg table
|
|
36175
|
C# to SQL recursive CTE translation help
|
|
36174
|
What is wrong with this String operation
|
|
36173
|
To Create Database files with Read-only access
|
|
36172
|
Cant execute Dos Command
|
|
36171
|
generating sql script by code
|
|
36170
|
Notification services for live data
|
|
36169
|
select clause
|
|
36168
|
Communication Link Failure
|
|
36167
|
analysis server - report sorting problem
|
|
36166
|
Catch context switch failing
|
|
36165
|
DATETIME Min value constant
|
|
36164
|
how to get number of columns
|
|
36163
|
Parameter Prompt in SQL DTS Package
|
|
36162
|
Capacity Planing and estimate space
|
|
36161
|
Database Mail Question
|
|
36160
|
Use DTS to save web page as Text file?
|
|
36159
|
Help with Function
|
|
36158
|
Call web service
|
|
36157
|
Query that retrieves last values
|
|
36156
|
Pivot Data SQL 2000 Only
|
|
36155
|
HELP!!! --- From Job tasks to ASP
|
|
36154
|
sql 2000 3rd row from a row that matches my condition
|
|
36153
|
SELECT
|
|
36152
|
Change Column Names
|
|
36151
|
retriving data from sql2005 to sql2000
|
|
36150
|
Can Team Database import a Visio database diagram?
|
|
36149
|
rounding question
|
|
36148
|
fulltext return no data
|
|
36147
|
encryptbykeyautocert does not exist?
|
|
36146
|
Date query help
|
|
36145
|
CONVERT DATE TSQL????
|
|
36144
|
Date Time Detect Overlapping Time in SQL Server 2000
|
|
36143
|
Merge Replication Snapshot Generation - Need Best Practice
|
|
36142
|
Use CONVERT and format an int?
|
|
36141
|
Column Position in Table
|
|
36140
|
Duplicate Key Violation Query (Sql Server Compact Edition)
|
|
36139
|
WCF and Service Broker Architecture
|
|
36138
|
SqlDependency invalid statement
|
|
36137
|
RecordCount NULL
|
|
36136
|
Win2000 ODBC Connect Second Instance??
|
|
36135
|
How to maximise write performance for streaming data via C#
|
|
36134
|
Displaying database recovery model
|
|
36133
|
Dropping extended stored procedures
|
|
36132
|
Invalid Object Name Error
|
|
36131
|
enabling AWE on clustering environment
|
|
36130
|
counts and averages
|
|
36129
|
What are the most common roles for users of an average app?
|
|
36128
|
TOP by GROUP SQL 2000
|
|
36127
|
selecting from tables, avoiding multiple results
|
|
36126
|
Options for importing data into SQL 2005
|
|
36125
|
2005 ROWGUID/UniqueIdentifer not initializing
|
|
36124
|
Change user-defined type
|
|
36123
|
Age Old Concatenating rows question - Small details left..
|
|
36122
|
SQL Script for SQL Server 2005
|
|
36121
|
deadlock, locking
|
|
36120
|
Rapidly growing Table
|
|
36119
|
Why does this query fail only SOMETIMES
|
|
36118
|
Lindsay Lohan Doing A Hung Guy!
|
|
36117
|
sql dmo and sql2005
|
|
36116
|
min()/max()/top 1, subqueries, or what?
|