comp.databases.ms-sqlserver

Date Index

autonumber, cbrewer2
Transfer data to web page fields, jcnone@xxxxxxxx
help with update, Analizer1
- Re: help with update, Plamen Ratchev
Join 4 tables - can it be done?, SirCodesALot
- Re: Join 4 tables - can it be done?, jefftyzzer
- Re: Join 4 tables - can it be done?, Plamen Ratchev
- Re: Join 4 tables - can it be done?, Jack Vamvas
Avg() not including 0's, lee.richmond
- Re: Avg() not including 0's, Gert-Jan Strik
- Re: Avg() not including 0's, Hugo Kornelis
  - Re: Avg() not including 0's, lee.richmond
    - Re: Avg() not including 0's, Ed Murphy
Inserting multiple records into two tables...with a twist, t8ntboy
- Re: Inserting multiple records into two tables...with a twist, Hugo Kornelis
- Re: Inserting multiple records into two tables...with a twist, Erland Sommarskog
Create Table with Variable included in Table Name, Chris H
- Re: Create Table with Variable included in Table Name, Erland Sommarskog
- Re: Create Table with Variable included in Table Name, --CELKO--
- Re: Create Table with Variable included in Table Name, Chris H
  - Re: Create Table with Variable included in Table Name, --CELKO--
trig errors, Daft Pict
- Re: trig errors, Erland Sommarskog
- Re: trig errors, Ed Murphy
detach database file from local SQL Server Express instance by C#?, sg71.cherub@xxxxxxxxx
- Re: detach database file from local SQL Server Express instance by C#?, Plamen Ratchev
Dynamic date range for each row?, lee.richmond
- Re: Dynamic date range for each row?, Roy Harvey (SQL Server MVP)
- Re: Dynamic date range for each row?, jefftyzzer
  - Re: Dynamic date range for each row?, Gert-Jan Strik
    - Re: Dynamic date range for each row?, Erland Sommarskog
REPLICATION, rajdaksha
Select statement query, Jules
- Re: Select statement query, Plamen Ratchev
multiple numbers in one statement, Yo mama
- Re: multiple numbers in one statement, Erland Sommarskog
- Re: multiple numbers in one statement, Plamen Ratchev
Deploying CLR trigger to SQL-Server 2005 -- Permissions Required., chris
- Re: Deploying CLR trigger to SQL-Server 2005 -- Permissions Required., Erland Sommarskog
  - Re: Deploying CLR trigger to SQL-Server 2005 -- Permissions Required., chris
Important about MySQL Certification, educational . mysql
- Re: Important about MySQL Certification, Ed Murphy
Rmote database inserts blocking local queries., quincy451
- Re: Rmote database inserts blocking local queries., Tom van Stiphout
  - Re: Rmote database inserts blocking local queries., quincy451
    - Re: Rmote database inserts blocking local queries., quincy451
    - Re: Rmote database inserts blocking local queries., Tom van Stiphout
    - Re: Rmote database inserts blocking local queries., Andy M
    - Re: Rmote database inserts blocking local queries., Erland Sommarskog
- Re: Rmote database inserts blocking local queries., Jack Vamvas
CALs and SQL Server, David Williams
- Re: CALs and SQL Server, Dan Guzman
  - Re: CALs and SQL Server, David Williams
Performance issue using conditional WHERE clause, Jared
- Re: Performance issue using conditional WHERE clause, Tom van Stiphout
- Re: Performance issue using conditional WHERE clause, Ed Murphy
  - Re: Performance issue using conditional WHERE clause, Jared
- Re: Performance issue using conditional WHERE clause, Erland Sommarskog
- Re: Performance issue using conditional WHERE clause, Jack Vamvas
- Re: Performance issue using conditional WHERE clause, Daniel Eyer
Connection Logs in SQL Server, David Williams
- Re: Connection Logs in SQL Server, David Williams
  - Re: Connection Logs in SQL Server, Plamen Ratchev
    - Re: Connection Logs in SQL Server, David Williams
  - Re: Connection Logs in SQL Server, Erland Sommarskog
    - Re: Connection Logs in SQL Server, David Williams
invalid server name error, David Williams
- Re: invalid server name error, Erland Sommarskog
  - Re: invalid server name error, David Williams
    - Re: invalid server name error, Erland Sommarskog
    - Re: invalid server name error, David Williams
Months Between, mets19@xxxxxxxxx
- Re: Months Between, Plamen Ratchev
  - Re: Months Between, Erland Sommarskog
DELETE ... NOT query does not delete all that I expected, metaperl
- Re: DELETE ... NOT query does not delete all that I expected, Plamen Ratchev
- Re: DELETE ... NOT query does not delete all that I expected, jefftyzzer
Problem migrating DTS to SSIS, stathisgotsis@xxxxxxxxxxx
Unable to attach the database, grzegorz . gazda
- Re: Unable to attach the database, Erland Sommarskog
Help-VB.NET and SQL Server 2005, sheenitmathew
- Re: Help-VB.NET and SQL Server 2005, Dan Guzman
NULL values in a SELECT in another SELECT, Hiho
- Re: NULL values in a SELECT in another SELECT, Plamen Ratchev
  - Re: NULL values in a SELECT in another SELECT, Hiho
    - Re: NULL values in a SELECT in another SELECT, Serge Rielau
    - Re: NULL values in a SELECT in another SELECT, Plamen Ratchev
    - Re: NULL values in a SELECT in another SELECT, Hiho
    - Re: NULL values in a SELECT in another SELECT, Serge Rielau
    - Re: NULL values in a SELECT in another SELECT, Serge Rielau
    - Re: NULL values in a SELECT in another SELECT, Plamen Ratchev
- Re: NULL values in a SELECT in another SELECT, Serge Rielau
NOT EXISTS using single table?, Artie
- Re: NOT EXISTS using single table?, David Portas
- Re: NOT EXISTS using single table?, Plamen Ratchev
  - Re: NOT EXISTS using single table?, Artie
Query Question, wackyphill
- Re: Query Question, ZeldorBlat
  - Re: Query Question, wackyphill
    - Re: Query Question, wackyphill
Timestamp Precision, t8ntboy
- Re: Timestamp Precision, Plamen Ratchev
ANN: Database Workbench Pro 3.1 released!, Martijn Tonies
Access 2000 and SQL Server 2005, JA
- Re: Access 2000 and SQL Server 2005, Erland Sommarskog
  - Re: Access 2000 and SQL Server 2005, serge
    - Re: Access 2000 and SQL Server 2005, JA
    - Re: Access 2000 and SQL Server 2005, serge
Stored Procedure to list out user access, SQL Server
- Re: Stored Procedure to list out user access, Erland Sommarskog
  - Re: Stored Procedure to list out user access, SQL Server
I need to know where mssql server stores its data., Yılmaz
- Re: I need to know where mssql server stores its data., Yılmaz
  - Re: I need to know where mssql server stores its data., Dan Guzman
- Re: I need to know where mssql server stores its data., Erland Sommarskog
  - Re: I need to know where mssql server stores its data., Greg D. Moore \(Strider\)
TempDB won't shrink, Thomas R. Hummel
- Re: TempDB won't shrink, Erland Sommarskog
  - Re: TempDB won't shrink, Thomas R. Hummel
Design question regarding junction tables, bg_ie
- Re: Design question regarding junction tables, Erland Sommarskog
Variables in SQL-script SQL2005, Brian Sprogø
- Re: Variables in SQL-script SQL2005, Dan Guzman
  - Re: Variables in SQL-script SQL2005, Brian Sprogø
sql mager, Mikulenas slavni
- Re: sql mager, George Shubin
SQL Sort Problem, SQLLearner
- Re: SQL Sort Problem, Plamen Ratchev
- Re: SQL Sort Problem, --CELKO--
- Re: SQL Sort Problem, Jack Vamvas
How top actually works, Gints Plivna
- Re: How top actually works, David Portas
- Re: How top actually works, Gert-Jan Strik
  - Re: How top actually works, Gints Plivna
    - Re: How top actually works, Erland Sommarskog
    - Re: How top actually works, Gints Plivna
    - Re: How top actually works, Erland Sommarskog
    - Re: How top actually works, Gints Plivna
duplicate checking, Analizer1
- Re: duplicate checking, Plamen Ratchev
A dimension playing off another dim, Mike K
Need Help Importing Data from Excel to My SQL Database, alvinstraight38@xxxxxxxxxxx
- Re: Need Help Importing Data from Excel to My SQL Database, Erland Sommarskog
  - Re: Need Help Importing Data from Excel to My SQL Database, aj
    - Re: Need Help Importing Data from Excel to My SQL Database, alvinstraight38@xxxxxxxxxxx
- Re: Need Help Importing Data from Excel to My SQL Database, Jim Johannsen
Biztalk vs SSIS as an ETL tool, KR
- Re: Biztalk vs SSIS as an ETL tool, Brad
Max(date) using joins, t8ntboy
- Re: Max(date) using joins, Erland Sommarskog
- Re: Max(date) using joins, Plamen Ratchev
  - Re: Max(date) using joins, t8ntboy
    - Re: Max(date) using joins, Plamen Ratchev
    - Re: Max(date) using joins, t8ntboy
    - Re: Max(date) using joins, Plamen Ratchev
    - Re: Max(date) using joins, t8ntboy
    - Re: Max(date) using joins, Plamen Ratchev
    - Re: Max(date) using joins, Ed Murphy
A philosophical question about inserts, Mike Husler
- Re: A philosophical question about inserts, Plamen Ratchev
- Re: A philosophical question about inserts, Erland Sommarskog
- Re: A philosophical question about inserts, Jack Vamvas
filtering results by input box?, kevin
- Re: filtering results by input box?, Tom van Stiphout
  - Re: filtering results by input box?, kevin
    - Re: filtering results by input box?, kevin
    - Re: filtering results by input box?, Erland Sommarskog
    - Re: filtering results by input box?, Tom van Stiphout
    - Re: filtering results by input box?, kevin
- Re: filtering results by input box?, Piero 'Giops' Giorgi
16GB Ram 64-bit server, what configuration to use?, serge
Re: Time Dimension Design Question, dmcmunn
T-SQL Sudoku Game, swint002
SQL 2005: Transactional Replication > Executing sp on subscriber should execute on publisher, PatrickW
- Re: SQL 2005: Transactional Replication > Executing sp on subscriber should execute on publisher, Patrick
SQL query timeout, RodStrongo1
- Re: SQL query timeout, Erland Sommarskog
  - Re: SQL query timeout, RodStrongo1
    - Re: SQL query timeout, Erland Sommarskog
    - Re: SQL query timeout, RodStrongo1
    - Re: SQL query timeout, Erland Sommarskog
    - Re: SQL query timeout, RodStrongo1
SQL SERVER 2005 SP2 post upgrade issue, albertwoomer
error when connecting to sql db, jho
- Re: error when connecting to sql db, jho
Queries Log on SQL Server 2000 ???, Josechu
- Re: Queries Log on SQL Server 2000 ???, Erland Sommarskog
- Re: Queries Log on SQL Server 2000 ???, Dan Guzman
Output to text-file, Kaitsu
- Re: Output to text-file, Roy Harvey (SQL Server MVP)
- Re: Output to text-file, Chris.Cheney
Formatting Numeric Value in Computed Column, Stephen C. Smith
- Re: Formatting Numeric Value in Computed Column, Tom van Stiphout
- Re: Formatting Numeric Value in Computed Column, Erland Sommarskog
- Re: Formatting Numeric Value in Computed Column, Plamen Ratchev
  - Re: Formatting Numeric Value in Computed Column, Plamen Ratchev
- Re: Formatting Numeric Value in Computed Column, Stephen C. Smith
Limit use of memory cache, Ed Murphy
- Re: Limit use of memory cache, Erland Sommarskog
  - Re: Limit use of memory cache, Ed Murphy
    - Re: Limit use of memory cache, Erland Sommarskog
    - Re: Limit use of memory cache, Erland Sommarskog
    - Re: Limit use of memory cache, serge
check the word whether correct or not, akk2006
- Re: check the word whether correct or not, Tom van Stiphout
Re: Importing from Excel problems, Jack Vamvas
Re: DTS-Package sends mail and files before the job finishes, Jack Vamvas
Create Delete Trigger on Table1 to Update a filed on Table2, Yas
- Re: Create Delete Trigger on Table1 to Update a filed on Table2, Ed Murphy
- Re: Create Delete Trigger on Table1 to Update a filed on Table2, Hugo Kornelis
- Re: Create Delete Trigger on Table1 to Update a filed on Table2, Erland Sommarskog
- Re: Create Delete Trigger on Table1 to Update a filed on Table2, SagiPhoenix@AlbionLab
  - Re: Create Delete Trigger on Table1 to Update a filed on Table2, Erland Sommarskog
[Announce] DataDirect XML Converters 3.1 Released - HL7 Support, Stylus Studio
using freetds tsql, eeb4u@xxxxxxxxxxx
- Re: using freetds tsql, Jack Vamvas
  - Re: using freetds tsql, eeb4u@xxxxxxxxxxx
    - Re: using freetds tsql, eeb4u@xxxxxxxxxxx
    - Re: using freetds tsql, Jack Vamvas
working with a local db copy, ll
- Re: working with a local db copy, Erland Sommarskog
Re: Format Number on Select, Knowledgy
Re: Query - Select two tables where a.id=b.id, Knowledgy
Re: learner a ms sql, Knowledgy
Re: Extracting Duplicates from SQL Server 2000, Knowledgy
Dropping an active connection on an attached database, Crazy Cat
- Re: Dropping an active connection on an attached database, Erland Sommarskog
  - Re: Dropping an active connection on an attached database, Crazy Cat
Selecting SUM and COUNT, but not straightforward.., KingofGing
- Re: Selecting SUM and COUNT, but not straightforward.., KingofGing
  - Re: Selecting SUM and COUNT, but not straightforward.., KingofGing
- Re: Selecting SUM and COUNT, but not straightforward.., --CELKO--
DB2 Tutorial, db2
- Re: DB2 Tutorial, Serge Rielau
Select Max values from queries for multiple Schedule_Number, mcolson
- Re: Select Max values from queries for multiple Schedule_Number, Plamen Ratchev
? about users, Brian
- Re: ? about users, Erland Sommarskog
FOR XML EXPLICIT can't get element 4 going, Pacific Fox
- Re: FOR XML EXPLICIT can't get element 4 going, Erland Sommarskog
  - Re: FOR XML EXPLICIT can't get element 4 going, clickfind(tm)
    - Re: FOR XML EXPLICIT can't get element 4 going, Erland Sommarskog
    - Re: FOR XML EXPLICIT can't get element 4 going, Pacific Fox
Re: sql operator question, ll
ANN: Advanced Data Generator v2.2.0 released!, Martijn Tonies
SSIS Mapping Columns from Flat Files, stephen
- Re: SSIS Mapping Columns from Flat Files, jhofmeyr
  - Re: SSIS Mapping Columns from Flat Files, stephen
    - Re: SSIS Mapping Columns from Flat Files, Dan Guzman
    - Re: SSIS Mapping Columns from Flat Files, jgeissman
Multiple joins in SQL Server, narendra vuradi
- Re: Multiple joins in SQL Server, Ed Murphy
  - Re: Multiple joins in SQL Server, Serge Rielau
Error handling in stored procedure AND checking, barmatt80
- Re: Error handling in stored procedure AND checking, Plamen Ratchev
  - Re: Error handling in stored procedure AND checking, barmatt80
    - Re: Error handling in stored procedure AND checking, Plamen Ratchev
    - Re: Error handling in stored procedure AND checking, barmatt80
Re: Query Update - subquery?, --CELKO--
Pass through query from MS Access, gumby
- Re: Pass through query from MS Access, Tom van Stiphout
- Re: Pass through query from MS Access, Erland Sommarskog
Position of Table Columns, Ganapathi sundaram
- Re: Position of Table Columns, Tom van Stiphout
- Re: Position of Table Columns, --CELKO--
- Re: Position of Table Columns, Madhivanan
Re: backup advise, David Greenberg
- Re: backup advise, Erland Sommarskog
Re: database optimization, David Greenberg
- Re: database optimization, Erland Sommarskog
- <Possible follow-ups>
- Re: database optimization, Knowledgy
- Re: database optimization, Jack Vamvas