|
53254
|
Add Columns to Table Variable Dynamically?
|
|
53253
|
UPDATE statement for variable columns
|
|
53252
|
How to force a bookmark lookup and concatenation?
|
|
53251
|
Last statement in a function must be a return statement
|
|
53250
|
recommendation for a simple replication scenario?
|
|
53249
|
need help in query
|
|
53248
|
ExecuteScalar SQL Server 2005 - how can I test it? It's crashing in .Net 2005 in some instances
|
|
53247
|
Flattening Tables
|
|
53246
|
Query Cost is different at different times
|
|
53245
|
JOIN vs Subquery Performance
|
|
53244
|
regarding blocking
|
|
53243
|
Tricky Update
|
|
53242
|
column to row
|
|
53241
|
Transferring tables via FTP?
|
|
53240
|
How to create reusable query in sql 2000?
|
|
53239
|
SQL based Statistics
|
|
53238
|
Design related
|
|
53237
|
SP - insert statement error
|
|
53236
|
Sql 2005 err 233 ?
|
|
53235
|
Remote server
|
|
53234
|
SQL Select statement to retrieve last 12 or so values matching a criteria
|
|
53233
|
How to debug a SP per remote SQL 2005?
|
|
53232
|
inner join difference between on condition and where condition
|
|
44354
|
openxml
|
|
44353
|
Interesting SQL problem : How to track movement history
|
|
44352
|
split
|
|
44351
|
CR report - connection can't dispose
|
|
44350
|
openxml - attribute and value
|
|
44349
|
permissions on SP and view
|
|
44348
|
Find whole numbers
|
|
44347
|
Deal with NULLs
|
|
44346
|
Return metadata information about a query
|
|
44345
|
DELETE 1 FROM MyTable WHERE ID=123?
|
|
44344
|
Subquery Logic Puzzler
|
|
44343
|
Connecting to Informix
|
|
44342
|
possible to limit database listing to those of which you are a user?
|
|
44341
|
ALTER TABLE doc_exa ADD @variable?
|
|
44340
|
Help with XML EXPLICIT to get output in desired schema
|
|
44339
|
set up scheduler on step basis
|
|
44338
|
TimeOut Expired - Tracing historically.
|
|
44337
|
Apache instances and CAL licensing
|
|
44336
|
Export to Access - Varchar(3) becomes Longtext
|
|
44335
|
Parameter Sniffing - Local Variables - OPTION (RECOMPILE)
|
|
44334
|
One Row into Many?
|
|
44333
|
Trigger problem:
|
|
44332
|
2005: formating text in RAISERROR
|
|
44331
|
Why doesn't this SQL query append a field to the table?
|
|
44330
|
(SQL Server 2005) newbie: join in DELETE
|
|
44329
|
NOT EXISTS
|
|
44328
|
A problem with indexing
|
|
44327
|
BCP question
|
|
44326
|
How to prepare a valid value for unique identifier column?
|
|
44325
|
Cursor trouble 2005
|
|
44324
|
Obtain msinfo32 info + am I SAN attached ?
|
|
44323
|
Skip to end of SQL Script
|
|
44322
|
Login performance
|
|
44321
|
How return records with search word param like 'value1, value2'?
|
|
44320
|
select based on criteria
|
|
44319
|
Error 14274: Cannot add, update, or delete a job (or it steps or
|
|
44318
|
How model for products given different attributes for different types?
|
|
44317
|
Copy database
|
|
44316
|
SQL Server 2000 DTS can I use global variables to rfer to tables
|
|
44315
|
SQL Server 2005: computed columns
|
|
44314
|
Construct ??
|
|
44313
|
How make a where clause conditional on something else?
|
|
44312
|
I need help with formatting date and time
|
|
44311
|
Help with Logic
|
|
44310
|
database maintenance
|
|
44309
|
How to clean up DTS 2000 package logs ?
|
|
44308
|
programmatically creating a maintenance plan
|
|
44307
|
Behaviour of Blk insert with NOT NULL columns
|
|
44306
|
How change a sql view name ?
|
|
44305
|
Reporting Manager access in 2005
|
|
44304
|
Problems creating a stored procedure
|
|
44303
|
Default schema and Resolving table names in Stored Procs
|
|
44302
|
QA not working
|
|
44301
|
Transaction is too large
|
|
44300
|
Challenging Query - Please Help
|
|
44140
|
Check if record is full-text indexed
|
|
44139
|
Help with padding!
|
|
44138
|
Join Hint in DTS
|
|
44137
|
SQLMail varbinary as mail attachment
|
|
44136
|
Is it possible to execute SP from a SP??
|
|
44135
|
Missing comma in query select
|
|
44134
|
Querying ##tables
|
|
44133
|
SQL Delema
|
|
44132
|
trigger question
|
|
44131
|
query of a big tabler of 70,000,000 rows
|
|
44130
|
What is the N for?
|
|
44129
|
What went wrong with my scripts?
|
|
44128
|
Recursion in sql server 2005
|
|
44127
|
row into column
|
|
44126
|
Combinations
|
|
44125
|
SQL SERVER 2000 DBA
|
|
44124
|
SP Recompile and Index Weird Problem
|
|
44123
|
Delete from multiple tables...
|
|
44122
|
Can this be done with an SQL statement?
|
|
44121
|
ASP ans sql server 2005
|
|
44120
|
Capture statistics about Insert and Updates in Stored Procedure
|
|
44119
|
Database Mirroring Question
|
|
44118
|
unresolved external symbol .srv_senddone
|
|
44117
|
MS Access Concurrency Error
|
|
44116
|
SQL insert issue
|
|
44115
|
Using GROUP BY with correlated subquery
|
|
44114
|
Is there a better way to write this SELECT statement.?
|
|
44113
|
sp_attach_db
|
|
44112
|
Fulltext search question
|
|
44111
|
Beginner's question about jobs and error trapping
|
|
44110
|
Need help with the query
|
|
44109
|
Formating Datediff results
|
|
44108
|
to find if servername exist or not
|
|
44107
|
Simple Aggregate question
|
|
44106
|
Convert varbinary into varchar
|
|
44105
|
How to: Converting a uniqueidentifier to an integer...
|
|
44104
|
locking rows exclusively
|
|
44103
|
Backup Query
|
|
44102
|
FTP quetion
|
|
44101
|
History Table Question
|
|
44100
|
CLR stored procedures and garbage collection
|
|
44099
|
Deleting / Merging Partitions SQL 2005
|
|
44098
|
Firing Triggers in a dtsx package
|
|
44097
|
Transaction log Job
|
|
44096
|
Retrieve data SQL 2005
|
|
44095
|
Security issue with DecryptByCert function in sql 05
|
|
44094
|
Retrieve rows from un-Normalized table - ?
|
|
44093
|
Union Grouping across multiple tables
|
|
44092
|
Blocking/Blocked SPIDs
|
|
44091
|
Left outer join v. Union
|
|
44090
|
DELETE and UPDATE query on linked server
|
|
44089
|
BeginExecuteNonQuery IAsyncResult is signalling before cmd complet
|
|
44088
|
Programming Specification
|
|
44087
|
DISTINCT Clause Problems - Urgent.. Helps needed
|
|
44086
|
Same Query, Same Server, Same User, Different Plan
|
|
44085
|
Basic question
|
|
44084
|
breaking down a stored procedure
|
|
44083
|
is temp table present in db
|
|
44082
|
SELECT Multiplicate rows : SELECT X times same record where X is a value in some column
|
|
44081
|
copy a view with new name
|
|
44080
|
Flattening table
|
|
44079
|
getting row count of three different queries..
|
|
44078
|
Really well locked down sqlserver
|
|
44077
|
DISTINCT vs GROUP BY with multiple columns
|
|
44076
|
Evalute formula string
|
|
44075
|
Four tables (dbf files) problem with JOIN
|
|
44074
|
Trigger on master - detail tables
|
|
44073
|
Assign a select ...case.. to a variable
|
|
44072
|
Determine if SQL Server in recovery process from code
|
|
44071
|
DateTime
|
|
44070
|
How to implement multiple assignment?
|
|
44069
|
RETURN vs OUTPUT
|
|
44068
|
SUBSTRING FUNCTION
|
|
44067
|
xp_cmdshell
|
|
44066
|
MSDTC on server '' is unavailable - INSERT to #tmp EXEC sproc
|
|
44065
|
Challange With Search Stored Procedure and Like Operator
|
|
44064
|
Backup/Restore of non-standard databases for beginners
|
|
44063
|
How to get the first and last day of the previous month
|
|
44062
|
removing full-text index
|
|
44061
|
Question about standard restore procedures
|
|
44060
|
diff at a glance
|
|
44059
|
select then update in stored procedure
|
|
44058
|
Creating report and sending it in an email.
|
|
44057
|
Script for moving and comparing tables from one database to another
|
|
44056
|
Absolute time diff
|
|
44055
|
Can I JOIN Database Tables on Different SQL Servers
|
|
44054
|
Hi Need Help with Access and XML data islands as prep to SQLServer
|
|
44053
|
select and display 1:many
|
|
44052
|
Cannot BCP in from a view
|
|
44051
|
creating a new user for database
|
|
44050
|
Calculate rate by line item
|
|
44049
|
How to change collate system?
|
|
44048
|
I Refuse.......
|
|
44047
|
problem understanding coalesce function
|
|
44046
|
case stmt - need to select subset
|
|
44045
|
query by sub-categories with category totals
|
|
44044
|
Update statement performance issue
|
|
44043
|
Outline number sorting
|
|
44042
|
Seconds to mm:ss
|
|
44041
|
Group By Column with Natural Number Values ( 1 , 2 , 3, N) ...
|
|
44040
|
Query Syntax Error
|
|
44039
|
Tools to help analyze SQL Profiler Traces in SQL Server 2005
|
|
44038
|
dynamically change column name when displaying
|
|
44037
|
Opposite of Union Select query
|
|
44036
|
Are there any PhpMyAdmin clone for ASP.net and SQL Server?
|
|
44035
|
Alter column, set default - what's wrong?
|
|
44034
|
Syntax question SQL server 2K-- SELECT ABS(diff) FROM (SELECT CAST( '-123' as decimal(28,2)) as diff)
|
|
44033
|
best way to get a GUID from a table on row insert
|
|
44032
|
Pivot Comma List
|
|
44031
|
Need calculation to be column name...
|
|
44030
|
Bulk Insert Failure on DTS 2005
|
|
44029
|
Error
|
|
44028
|
SELECT
|
|
44027
|
Explicitly detecting if a parameter was passed to a stored procedure?
|
|
44026
|
convert datatype
|
|
44025
|
(Sql Server 2000) Get new @@identity values after multiple row insert
|
|
44024
|
Parameters won't work
|
|
44023
|
getting network login ID from sql server trigger
|
|
44022
|
Learn Stored Procedures
|
|
44021
|
How to make sure mirroring is working without failover
|
|
44020
|
SQL GENERATION
|
|
44019
|
COUNT
|