microsoft.public.sqlserver.programming [Archive]

CASE WHEN (2 replies)
Date question (1 replies)
Create table from view? (2 replies)
Returning Multiple Rows based on 1 rows column integer content. (5 replies)
need help with query statement (3 replies)
triggers (4 replies)
Newbie question about Stored Procedures (2 replies)
Asynch Batch Processing Architecture (1 replies)
Isolation level question (6 replies)
This is odd (2 replies)
TSQL to find all running SQL Agent jobs (2 replies)
Query.... (2 replies)
Display a rownr in a SELECT Query (5 replies)
Script Table Constraint (1 replies)
datetim convertion to date (6 replies)
Chcecking syntax all triggers (3 replies)
Calculating time differences (4 replies)
using ISNULL with the data type IMAGE (2 replies)
Ongoing Maintenance problems (4 replies)
Passing VB array into SP as a parameter? (3 replies)
Nested ordering???? (5 replies)
Maximum number of open cursors (3 replies)
triggers before insert/update (5 replies)
Storing & Manipulating Currency in the database. (1 replies)
Indexing (8 replies)
Storing SQL data from dotnet....should I use a trigger? (5 replies)
Weird Design issue (12 replies)
Selecting Rows in groups (6 replies)
A Little Help Please With non visible tables (12 replies)
XML in SQL (2 replies)
Charindex vs Dynamic Sql in clauses (3 replies)
SELECT Statement (4 replies)
change time part of datetime (2 replies)
distributed transactions (0 replies)
Table design question (6 replies)
Between Noon today and Noon tomorrow? (4 replies)
What technology should I use (1 replies)
Query Help - Join? (2 replies)
Moving a diagram from one database to another. (4 replies)
Why plural table names? (Celko) (51 replies)
SQL query help (1 replies)
How to view <binary> data in enterprise manager? (2 replies)
complex trigger 2 (2 replies)
Bulk Insert Error (0 replies)
Local Variables Problem (1 replies)
"CAST" question (1 replies)
Output file - breaks. (1 replies)
Distributed queries (0 replies)
Distributed queries (0 replies)
Need help to query several tables (0 replies)
can this be done in one update statement? (5 replies)
STDEV on a whole table (2 replies)
Triggers for access row (4 replies)
need help with another query statement (3 replies)
Immediate help is needed with SQL statement: (8 replies)
How does datediff count month? (2 replies)
How to reset identity column value back to 1 ? (4 replies)
Stored Procs, Views and SELECT (3 replies)
Empty tables (4 replies)
Possible to ALTER a variable table @table inside SP? (3 replies)
Query Issue - Join? (1 replies)
Help with a query- (3 replies)
need help with modifying query statement (1 replies)
Strange Behavior after removing hypothetical indexes (1 replies)
Problem with Group By (2 replies)
Information_Schema (2 replies)
Searching stored procedures (4 replies)
Set a Substring, First 12 Characters (8 replies)
Is this an MSSQL bug? (7 replies)
SQL Server errors not entered in Windows event log (2 replies)
Memo Field? (2 replies)
Network Error: ConnectionCheckForData (0 replies)
Time query (2 replies)
Query Issue (1 replies)
CheckBoxList Selected property (1 replies)
Which commend I should run (3 replies)
Optimizing away unused subselects (3 replies)
org chart or hiearchical data organization database/table design (7 replies)
working with directories (2 replies)
Can I make ORDER BY case-insensitive? (5 replies)
triggers : 'deleted' and 'inserted' psuedotables (2 replies)
datetime Formatting (2 replies)
Is it advisable to use multiple Foreign Keys? (5 replies)
select with function (2 replies)
Identify the table whose data updated (6 replies)
Problem in FLOAT DataType (10 replies)
SQL Server DTS From Sybase (0 replies)
constraints on views (5 replies)
Transaction when client shutdown (10 replies)
altering columns/pk's with sql-dmo (1 replies)
Last of day in monty (5 replies)
AppendChunk with Stored Procedures (4 replies)
Using Variables In Stored Procedure (3 replies)
Turn off trigger temporarily (3 replies)
Index creation speed (2 replies)
No. of the day (2 replies)
Modelling deliverance schema (0 replies)
SQL Query Performance (5 replies)
Return messages of SQL from VB (6 replies)
How to design column to store formatted data? Thanks (3 replies)
Knotty little problem (2 replies)
Record count check (2 replies)
what is wrong with this stored procedure? (7 replies)
PurgeJobHistory not constrained by JobHistoryFilter?? (0 replies)
SQL IIF Statement (5 replies)
Replication (2 replies)
Distinct efficiency (3 replies)
Should be simple (2 replies)
Query Help (4 replies)
Query (1 replies)
String function (3 replies)
recursive sp, fmtonly, ado, (5 replies)
How to model Enumeration's in a Table (13 replies)
INSERT UPDATE QUERY (3 replies)
CASE Cross Join (0 replies)
Generating Report (1 replies)
Replacing IIF with a UDF (not CASE) (9 replies)
convert numeric to time (4 replies)
User Defined Function (5 replies)
trying to transpose [Order Details] data using self-join (3 replies)
Newbie confusion about FK constraints (1 replies)
Login to SQL server through the internet (1 replies)
Looking up a default value (8 replies)
Group by error when using text field (2 replies)
Tools (1 replies)
if else (4 replies)
Query Question (1 replies)
Table assistance (1 replies)
Parsing Like Data for Consolidation... (4 replies)
Cannot contain NULL value when it should (1 replies)
NULL Value (0 replies)
ORDER BY question. (9 replies)
Dynamic SQL (1 replies)
[ETL] from XML to mySQL with ETL? (0 replies)
Dynamic SQL (1 replies)
Transactional Replication (1 replies)
how to describe a table in sql ? (2 replies)
Need a good book to learn how to write Query Statements (3 replies)
Auto-increment value in query (2 replies)
Tsql to drop all users from a database (3 replies)
order by expression (2 replies)
Best practice kinda question (10 replies)
compare (6 replies)
help with query using replicate (8 replies)
Disadvantages of using OPENXML (1 replies)
Looking for good T-SQL book (3 replies)
update multiple columns (2 replies)
Cursor with Input parameters (5 replies)
single update query (1 replies)
Field Exists (2 replies)
Trees? (0 replies)
Date query (5 replies)
UniqueIdentifier, offline data: clustering key choice? ... (indexing+performance question) (2 replies)
help needed (3 replies)
Order of clustered index (2 replies)
identitycolumn as pk (7 replies)
Capturing All tables in a SQL server Instance. (2 replies)
How to get table statistic (1 replies)
Japanese to Unicode characters (4 replies)
Returning System Date (Without the time) (4 replies)
creating a DTS package (2 replies)
From weekday calculate next date (4 replies)
Case Change Query (3 replies)
xp_cmdshell -- I must be missing something obvious (7 replies)
Linked Server to ASE (0 replies)
problem with procedure :( (5 replies)
XML to a SP (0 replies)
How to know when a stored procedure was last changed ? (4 replies)
Search text field for all 1's (9 replies)
Optimizing query (8 replies)
DATEDIFF with weeks always starts on a Sunday? (7 replies)
Triggers - How can I get a field value? (2 replies)
Newbie Server Load Question (2 replies)
Trigger Question (8 replies)
Newbie question with stored procedures (1 replies)
Update text filed from QA (3 replies)
deadlock question (2 replies)
INSERT INTO SELECT FROM Problem (7 replies)
Apply script to multiple databases. (2 replies)
Update text filed error (3 replies)
Newbie Questions (6 replies)
BULK INSERT by non Builk Admin (2 replies)
Only constants, expressions, or variables allowed here. Column names are not permitted. (1 replies)
Need help to modify my query (3 replies)
SELECTing constant range (5 replies)
newbie int date/time conversion (4 replies)
SQL Server UDT Performance Hit (2 replies)
Is there a tool/util/script to do syntax check of all stored procedures? (9 replies)
how to know if a trigger is firing ? (2 replies)
Backup Database (3 replies)
Basic question about Updating (2 replies)
SQL Server Performance on XP (2 replies)
Any ideas for reusing long table variable definitions? (4 replies)
Does the SQL Server 2005 ADO/OLEDB provider support adSeek and adIndex? (3 replies)
Read/Export Binary Data (2 replies)
What type should i use for a field which acts as a filter? (1 replies)
How to read the value of timestamp column (7 replies)
trigger specs (3 replies)
COALESCE(DateCreated,GETDATE()) (1 replies)
Invalid object name (1 replies)
avg and null values (3 replies)
function select (1 replies)
Recurrencing (5 replies)
Urgent help needed. How to search using LIKE if keyword itself is "%"? (7 replies)
Multiple results from single CASE? (1 replies)
Must declare the variable error.. (1 replies)
DTS Data Pump Error (1 replies)
Help on Ignored Words in Full Text Query (1 replies)
query a SQL server (1 replies)
Recommended way to check if a DB already exists on SQL Server (3 replies)
When a client application cancels a query, ...? (1 replies)
Re: multiple variables set from single CASE? (0 replies)
backing up SQL to local drive (0 replies)
Help on Dynamic SELECT (2 replies)
trigger sql syntax errors (very difficult to troubleshoot) (6 replies)
SQL Server logs event on connection (5 replies)
select city from cities where city like (select '%' + city + '%' from stores where city like '%paul%') (4 replies)
using case ** (2 replies)
search condition in WHERE clause (4 replies)
Repeatable Read (3 replies)
Search field name is All SP (4 replies)
bitewise and (6 replies)
Decimals not returned on Output Parameter (2 replies)
if statement (3 replies)
13 Week Period, vs. Equivalent 13 Week Period for Prior Year (3 replies)
DBCC permissions (3 replies)
dynamic sql : insert literal (char or varchar) (9 replies)
Error 823 I/O error (torn page) (6 replies)
Query Question (1 replies)
How to change a column name (2 replies)
converting to sp_executesql (6 replies)
SQL Calculation Question (3 replies)
What is wrong with this simple line? (3 replies)
convert long timstamp to datetime (2 replies)
Update With Column from Another Table (3 replies)
stress sql server with ostress tool (0 replies)
WIndows 2003 server any known issues? (1 replies)
To Null or Not To null ?? (1 replies)
Rename database (4 replies)
Size of image data (1 replies)
Search Query (2 replies)
Unit testing stored procedures (4 replies)
Triggers for auditing (2 replies)
NZ Function? (1 replies)
Transaction question (2 replies)
ROLLUP operator (1 replies)
Converting nvarchar to numeric or decimal (2 replies)
Best table design for different types of name/value settings? (4 replies)
Linked Server and Heterogenouse queries (1 replies)
Datetime and hh:mm:ss (1 replies)