microsoft.public.sqlServer.programming

• Date Index

---

• Link server Identity column insert question?, SQL
• Help with SQL Query, deeg
  • Re: Help with SQL Query, Dom
    • Re: Help with SQL Query, deeg
      • Re: Help with SQL Query, Dom
      • Re: Help with SQL Query, --CELKO--
      • Re: Help with SQL Query, deeg
• Collect csv from ftp server and bulk import, Tim P
• Question on BCP, Dom
• SELECT question?, kizildag
  • Re: SELECT question?, Tom Cooper
    • Re: SELECT question?, deeg
• Select only columns with contents, Holger Schröter
  • Re: Select only columns with contents, Erland Sommarskog
  • Re: Select only columns with contents, --CELKO--
• Detect Valid Full backup, Van Den Steen Dany
• How to perform LIKE syntax in parameter query?, Ben
  • RE: How to perform LIKE syntax in parameter query?, Ben
• Service Broker Check after Receive?, SnapDive
  • Re: Service Broker Check after Receive?, Jeroen Mostert
• Using Machine name in DOS Batch, Ada
  • Re: Using Machine name in DOS Batch, John Bell
    • Re: Using Machine name in DOS Batch, Ada
• Help with SQL partitions, Derek
  • Re: Help with SQL partitions, Dan Guzman
    • Re: Help with SQL partitions, Derek
• Change RDL file datsource, Manuel
• query problem, Jami
  • Re: query problem, Baiju K U
    • Re: query problem, Jami
• Sum on Rounded column, Baiju K U
  • Re: Sum on Rounded column, Erland Sommarskog
    • Re: Sum on Rounded column, Baiju K U
  • Re: Sum on Rounded column, --CELKO--
• SQL logs, Simon Whale
  • Re: SQL logs, Erland Sommarskog
  • Re: SQL logs, Uri Dimant
  • Re: SQL logs, Michael MacGregor
    • Re: SQL logs, Erland Sommarskog
      • Re: SQL logs, Michael MacGregor
  • Re: SQL logs, Simon Whale
• running a job, cj
  • Message not available
    • Re: running a job, cj
• Serial Motor, Justin Case
  • Re: Serial Motor, Bob Barrows
    • Re: Serial Motor, Erland Sommarskog
    • Re: Serial Motor, Dan
• AIML, Justin Case
  • Re: AIML, Bob Barrows
• Locking at delete statement(SQL2008), simon
  • Re: Locking at delete statement(SQL2008), Erland Sommarskog
  • Re: Locking at delete statement(SQL2008), Uri Dimant
• Database design question, tshad
  • Re: Database design question, Erland Sommarskog
    • Re: Database design question, tshad
      • Re: Database design question, Erland Sommarskog
      • Re: Database design question, tshad
      • Re: Database design question, Erland Sommarskog
  • Re: Database design question, --CELKO--
• Monitoring UPDATE, Bassam
  • Re: Monitoring UPDATE , SQL Server 2005, Bassam
    • Re: Monitoring UPDATE , SQL Server 2005, Bob Barrows
  • Re: Monitoring UPDATE, Erland Sommarskog
• parse name and address, shank
  • Re: parse name and address, Erland Sommarskog
• Open a Windows Form from SSRS, jm27102
• eliminating duplicates, Jay via SQLMonster.com
  • Re: eliminating duplicates, Erland Sommarskog
  • Re: eliminating duplicates, ray
• Re: Stored Proc Question: Use ad hoc Where Clause, Ray
  • Re: Stored Proc Question: Use ad hoc Where Clause, Erland Sommarskog
    • Re: Stored Proc Question: Use ad hoc Where Clause, ray
• sharing DBs between 2 instances on same box without linked servers, siddhath
  • Re: sharing DBs between 2 instances on same box without linked servers, Erland Sommarskog
• Search and Replace within string, Greg Berthume
  • Re: Search and Replace within string, Bob Barrows
    • Re: Search and Replace within string, Greg Berthume
• Replacing multiple statements with a single MERGE, --CELKO--
  • Re: Replacing multiple statements with a single MERGE, Eric Isaacs
  • Re: Replacing multiple statements with a single MERGE, Erland Sommarskog
    • Re: Replacing multiple statements with a single MERGE, Erland Sommarskog
      • Re: Replacing multiple statements with a single MERGE, --CELKO--
  • Re: Replacing multiple statements with a single MERGE, Peso
    • Re: Replacing multiple statements with a single MERGE, Peso
      • Re: Replacing multiple statements with a single MERGE, Peso
• Insert a one returned value from a MAX function in SSRS in Footer, jm27102
  • Re: Insert a one returned value from a MAX function in SSRS in Footer, John Bell
• Find distinct records of the last order from a customer, David
  • <Possible follow-ups>
  • Find distinct records of the last order from a customer, David
  • Find distinct records of the last order from a customer, David
    • Re: Find distinct records of the last order from a customer, Erland Sommarskog
      • Re: Find distinct records of the last order from a customer, David
• Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle, gv
  • Re: Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle, gv
• Run query on multiple databases, Sammy
  • Re: Run query on multiple databases, Erland Sommarskog
• Dealing with BAD Dates in SSIS, robboll
  • Re: Dealing with BAD Dates in SSIS, Bob Barrows
    • Re: Dealing with BAD Dates in SSIS, jm27102
      • Re: Dealing with BAD Dates in SSIS, Bob Barrows
      • Re: Dealing with BAD Dates in SSIS, robboll
      • Re: Dealing with BAD Dates in SSIS, Bob Barrows
      • Re: Dealing with BAD Dates in SSIS, Bob Barrows
      • Message not available
      • Re: Dealing with BAD Dates in SSIS, Bob Barrows
  • RE: Dealing with BAD Dates in SSIS, jm27102
  • Re: Dealing with BAD Dates in SSIS, Eric Isaacs
• Looping through table to build sql case statement, Jack
  • Re: Looping through table to build sql case statement, Eric Isaacs
  • Re: Looping through table to build sql case statement, --CELKO--
  • Re: Looping through table to build sql case statement, Erland Sommarskog
• Start -> From-Till date conversion, Danny
  • Re: Start -> From-Till date conversion, Eric Isaacs
  • Re: Start -> From-Till date conversion, Erland Sommarskog
    • Re: Start -> From-Till date conversion, Danny
  • Re: Start -> From-Till date conversion, --CELKO--
• Subquery with Max(date), tshad
  • Re: Subquery with Max(date), tshad
    • Re: Subquery with Max(date), tshad
    • Re: Subquery with Max(date), Bob Barrows
      • Re: Subquery with Max(date), tshad
  • Re: Subquery with Max(date), Erland Sommarskog
    • Re: Subquery with Max(date), tshad
      • Re: Subquery with Max(date), Erland Sommarskog
      • Re: Subquery with Max(date), tshad
      • Re: Subquery with Max(date), Erland Sommarskog
      • Re: Subquery with Max(date), tshad
• Complex select statement formulation, Jack
  • RE: Complex select statement formulation, Q
    • RE: Complex select statement formulation, Jack
• XML - Eliminate Namespace in Elements, Mary
  • Re: XML - Eliminate Namespace in Elements, Erland Sommarskog
  • Re: XML - Eliminate Namespace in Elements, John Bell
• How to retrieve a distinct row using one column as criteria?, Edgard L. Riba
  • Re: How to retrieve a distinct row using one column as criteria?, Dan
    • Re: How to retrieve a distinct row using one column as criteria?, Edgard L. Riba
      • Re: How to retrieve a distinct row using one column as criteria?, Erland Sommarskog
  • Re: How to retrieve a distinct row using one column as criteria?, --CELKO--
• Mnipulating temp table output in sql, Jack
• Sync two tables, Eddie Pazz
  • Re: Sync two tables, Iain Sharp
• Trying to migrate from SQL Server 2005 to Oracle 10g Express Edition, Learner
  • Re: Trying to migrate from SQL Server 2005 to Oracle 10g Express Edition, Bob Barrows
    • Re: Trying to migrate from SQL Server 2005 to Oracle 10g Express Edition, Learner
      • Re: Trying to migrate from SQL Server 2005 to Oracle 10g Express Edition, Learner
      • Re: Trying to migrate from SQL Server 2005 to Oracle 10g Express Edition, Bob Barrows
  • Re: Trying to migrate from SQL Server 2005 to Oracle 10g Express Edition, dan kirk
  • Re: Trying to migrate from SQL Server 2005 to Oracle 10g Express Edition, Jon Waterhouse
    • Re: Trying to migrate from SQL Server 2005 to Oracle 10g Express Edition, Learner
• RE: I am trying to match a negative number to its exact opposite posit, SoccerFan@community.nospan
• Re: I am trying to match a negative number to its exact opposite positive number, Bob Barrows
  • <Possible follow-ups>
  • Re: I am trying to match a negative number to its exact opposite positive number, --CELKO--
    • Re: I am trying to match a negative number to its exact opposite positive number, Peso
• Compare Data, Altair Brito
• sql result different to excel result, Phil
  • Re: sql result different to excel result, Iain Sharp
  • Re: sql result different to excel result, --CELKO--
    • Re: sql result different to excel result, --CELKO--
    • Re: sql result different to excel result, Phil
• Tracking of changes, simon
  • Re: Tracking of changes, Uri Dimant
    • Re: Tracking of changes, simon
      • Re: Tracking of changes, simon
      • Re: Tracking of changes, Uri Dimant
      • Re: Tracking of changes, simon
      • Re: Tracking of changes, Erland Sommarskog
• convert to stored proc, John
  • Re: convert to stored proc, John
    • Re: convert to stored proc, Bob McClellan
      • Re: convert to stored proc, John
      • Re: convert to stored proc, Bob McClellan
    • Re: convert to stored proc, Bob Barrows
      • Re: convert to stored proc, Bob McClellan
      • Re: convert to stored proc, Bob Barrows
      • Re: convert to stored proc, Bob McClellan
      • Re: convert to stored proc, Bob Barrows
• Retrieve unique values based on multiple columns, Denis
  • Re: Retrieve unique values based on multiple columns, Eric Isaacs
  • Re: Retrieve unique values based on multiple columns, Erland Sommarskog
  • RE: Retrieve unique values based on multiple columns, Wojciech Garwol
• Find objects referencing deleted columns, SoccerFan@community.nospan
  • Re: Find objects referencing deleted columns, Erland Sommarskog
    • Re: Find objects referencing deleted columns, SoccerFan@community.nospan
      • Re: Find objects referencing deleted columns, Erland Sommarskog
      • Re: Find objects referencing deleted columns, SoccerFan@community.nospan
• How to check record exists before INSERT multiple records, jonjack via SQLMonster.com
  • Re: How to check record exists before INSERT multiple records, Plamen Ratchev
    • Re: How to check record exists before INSERT multiple records, jonjack via SQLMonster.com
  • Re: How to check record exists before INSERT multiple records, --CELKO--
    • Re: How to check record exists before INSERT multiple records, Tony Rogerson
    • Re: How to check record exists before INSERT multiple records, Plamen Ratchev
      • Re: How to check record exists before INSERT multiple records, --CELKO--
      • Re: How to check record exists before INSERT multiple records, Tony Rogerson
  • Re: How to check record exists before INSERT multiple records, Geniusinuse
• Insert Data Generate Date into an SSRS Report Header, jm27102
  • Re: Insert Data Generate Date into an SSRS Report Header, Uri Dimant
    • Re: Insert Data Generate Date into an SSRS Report Header, jm27102
• Multiple SCOPE_IDENTITY, DavidC
  • Re: Multiple SCOPE_IDENTITY, Tom
• Confusing varchar(max) ..., Frank Uray
  • Re: Confusing varchar(max) ..., Plamen Ratchev
    • Re: Confusing varchar(max) ..., Frank Uray
      • Re: Confusing varchar(max) ..., Plamen Ratchev
      • Re: Confusing varchar(max) ..., Frank Uray
• Help needed in BCP and Bulk Insert, SqlBeginner
  • Re: Help needed in BCP and Bulk Insert, Erland Sommarskog
    • Re: Help needed in BCP and Bulk Insert, SqlBeginner
      • Re: Help needed in BCP and Bulk Insert, Erland Sommarskog
• Try this, Abu Arqam
• altering XML on sql server and getting information on them, Roy Goldhammer
  • Re: altering XML on sql server and getting information on them, John Bell
  • Re: altering XML on sql server and getting information on them, Erland Sommarskog
• A rather basic question I am sure..., AussieRules
  • Re: A rather basic question I am sure..., Erland Sommarskog
    • Re: A rather basic question I am sure..., AussieRules
      • Re: A rather basic question I am sure..., Erland Sommarskog
    • Re: A rather basic question I am sure..., AussieRules
  • Re: A rather basic question I am sure..., John Bell
• Doing joIn with REGEXP? (MySQL), jonjack
  • Re: Doing joIn with REGEXP? (MySQL), Erland Sommarskog
  • Re: Doing joIn with REGEXP? (MySQL), John Bell
    • Re: Doing joIn with REGEXP? (MySQL), jonjack via SQLMonster.com
      • Re: Doing joIn with REGEXP? (MySQL), --CELKO--
• Re: String Manipulation Func, Erland Sommarskog
  • Re: String Manipulation Func, odeddror
    • Re: String Manipulation Func, Erland Sommarskog
      • Re: String Manipulation Func, Jeroen Mostert
      • Re: String Manipulation Func, Jeroen Mostert
      • Re: String Manipulation Func, Erland Sommarskog
      • Re: String Manipulation Func, odeddror
      • Re: String Manipulation Func, Erland Sommarskog
      • Message not available
      • Re: String Manipulation Func, Erland Sommarskog
      • Re: String Manipulation Func, odeddror
• basic join question, AussieRules
  • Re: basic join question, Geoff Schaller
  • Re: basic join question, Erland Sommarskog
  • Re: basic join question, --CELKO--
  • Re: basic join question, Iain Sharp
• ddl not working in scrip, Sceren
  • <Possible follow-ups>
  • ddl not working in scrip, Sceren
    • Re: ddl not working in scrip, Erland Sommarskog
      • Message not available
      • Re: ddl not working in scrip, Erland Sommarskog
• Replace certain data within a string, bcap
  • Re: Replace certain data within a string, Andrew J. Kelly
• Trigger Syntax, Cory J. Laidlaw, Beyond01.com
  • Re: Trigger Syntax, Scott Morris
• Synonyms, SetonSoftware
  • Re: Synonyms, Eric Isaacs
  • Re: Synonyms, John Bell
    • Re: Synonyms, SetonSoftware
  • Re: Synonyms, Erland Sommarskog
    • Re: Synonyms, SetonSoftware
• recursive call in TSQL, Rafeeque Muhammad
• RDLC 2008 Error in print layout mode, Giorgio Parmeggiani
  • RE: RDLC 2008 Error in print layout mode, "Charles Wang [MSFT]"
    • Re: RDLC 2008 Error in print layout mode, Giorgio Parmeggiani
      • Re: RDLC 2008 Error in print layout mode, Giorgio Parmeggiani
      • Re: RDLC 2008 Error in print layout mode, "Charles Wang [MSFT]"
• Pivot in a Join, tshad
  • Re: Pivot in a Join, tshad
• Date comparison better method, SqlBeginner
  • Re: Date comparison better method, Jeffrey Williams
    • Re: Date comparison better method, SqlBeginner
  • RE: Date comparison better method, SqlBeginner
    • Re: Date comparison better method, Dan Guzman
      • Re: Date comparison better method, SqlBeginner
  • Re: Date comparison better method, Eric Isaacs
• how to delete/archive huge data from a table without much issues!, SqlBeginner
  • Re: how to delete/archive huge data from a table without much issues!, Jeroen Mostert
  • Re: how to delete/archive huge data from a table without much issues!, Uri Dimant
    • Re: how to delete/archive huge data from a table without much issu, SqlBeginner
• Removing duplicates in multiple tables, SqlBeginner
  • RE: Removing duplicates in multiple tables, SqlBeginner
  • Re: Removing duplicates in multiple tables, SetonSoftware
  • Re: Removing duplicates in multiple tables, Erland Sommarskog
• design decision sanity check - necessary to span data across multiple tables?, PJ6
  • Re: design decision sanity check - necessary to span data across multiple tables?, Eric Isaacs
  • Re: design decision sanity check - necessary to span data across multiple tables?, Erland Sommarskog
• Converting money type into varchar, Federico Caselli
  • Re: Converting money type into varchar, --CELKO--
  • Re: Converting money type into varchar, Eric Isaacs
• Check if a row is empty, sChapman
  • Re: Check if a row is empty, amish
  • Re: Check if a row is empty, Uri Dimant
  • Re: Check if a row is empty, --CELKO--
• Create view to get data from multiple databases, Sammy
  • Re: Create view to get data from multiple databases, Dan Guzman
• Importing nightly from another DB, Jordan
  • Re: Importing nightly from another DB, Eric Isaacs
• Trigger error, DavidC
  • Re: Trigger error, Eric Isaacs
• Check Constraint and function call, pascal13131
  • Re: Check Constraint and function call, Erland Sommarskog
  • Re: Check Constraint and function call, --CELKO--
    • Re: Check Constraint and function call, pascal13131
      • Re: Check Constraint and function call, --CELKO--
    • Re: Check Constraint and function call, J.B. Moreno
      • Re: Check Constraint and function call, --CELKO--
      • Re: Check Constraint and function call, J.B. Moreno
      • Re: Check Constraint and function call, Tony Rogerson
      • Re: Check Constraint and function call, --CELKO--
      • Re: Check Constraint and function call, Tony Rogerson
      • Re: Check Constraint and function call, --CELKO--
      • Re: Check Constraint and function call, Tony Rogerson
      • Re: Check Constraint and function call, Erland Sommarskog
      • Message not available
      • Re: Check Constraint and function call, Erland Sommarskog
      • Re: Check Constraint and function call, --CELKO--
      • Re: Check Constraint and function call, Erland Sommarskog
      • Re: Check Constraint and function call, --CELKO--
      • Re: Check Constraint and function call, Tony Rogerson
      • Re: Check Constraint and function call, Erland Sommarskog
• Get column value in delete trigger, DavidC
  • Re: Get column value in delete trigger, Tom Moreau
  • Re: Get column value in delete trigger, Eric Isaacs
  • Re: Get column value in delete trigger, Erland Sommarskog
• Update stored procedure question, fniles
  • Re: Update stored procedure question, Bob Barrows
  • Re: Update stored procedure question, Erland Sommarskog
    • Re: Update stored procedure question, fniles
      • Re: Update stored procedure question, amish
      • Re: Update stored procedure question, Erland Sommarskog
    • Re: Update stored procedure question, J.B. Moreno
      • Re: Update stored procedure question, fniles
      • Re: Update stored procedure question, Erland Sommarskog
      • Re: Update stored procedure question, J.B. Moreno
• Header in Job Step Output file, Rob
  • RE: Header in Job Step Output file, Rob
    • Re: Header in Job Step Output file, Bob Barrows
      • Re: Header in Job Step Output file, Rob
• Populate matching Data from another column into one, Aalamo
  • Re: Populate matching Data from another column into one, Erland Sommarskog
  • Message not available
    • Re: Populate matching Data from another column into one, Erland Sommarskog
  • Re: Populate matching Data from another column into one, Leo
• Paging in sql 2000(Query Help), Hemant
  • Re: Paging in sql 2000(Query Help), Iain Sharp
• Using row_number() in Recurcive CTE, Roy Goldhammer
  • Re: Using row_number() in Recurcive CTE, Erland Sommarskog
  • Re: Using row_number() in Recurcive CTE, --CELKO--
    • Re: Using row_number() in Recurcive CTE, Iain Sharp
• Backup and Restore database using T-SQL, shapper
  • Re: Backup and Restore database using T-SQL, Scott Morris
• Enforce Password Policy and Expiration. When?, shapper
• sql check by Idera, tshad
• 64 bit MSDASQLfor Windows Server 2008, Craig Lambie
  • Re: 64 bit MSDASQLfor Windows Server 2008, Dan
• Disallow viewing table definitions, Vern Rabe
  • Re: Disallow viewing table definitions, Tony Rogerson
    • Re: Disallow viewing table definitions, Vern Rabe
• Is any group function which concatenates data?, PrzemekD
  • Re: Is any group function which concatenates data?, Erland Sommarskog
  • Re: Is any group function which concatenates data?, --CELKO--
    • Re: Is any group function which concatenates data?, Tony Rogerson
    • Re: Is any group function which concatenates data?, Tony Rogerson
      • Re: Is any group function which concatenates data?, --CELKO--
      • Re: Is any group function which concatenates data?, Tony Rogerson
• Stored procedure timeout, Jose Nadim
  • Re: Stored procedure timeout, Tony Rogerson
    • Re: Stored procedure timeout, Jose Nadim
      • Re: Stored procedure timeout, Bob Barrows
      • Re: Stored procedure timeout, Jose Nadim
      • Re: Stored procedure timeout, Tony Rogerson
      • Re: Stored procedure timeout, Erland Sommarskog
      • Re: Stored procedure timeout, Jose Nadim
      • Re: Stored procedure timeout, Erland Sommarskog
• for xml auto and synonyms, pvdm
  • Re: for xml auto and synonyms, John Bell
    • Re: for xml auto and synonyms, pvdm
      • Re: for xml auto and synonyms, John Bell
      • Re: for xml auto and synonyms, Erland Sommarskog
• Create Login and Role Name, shapper
  • Re: Create Login and Role Name, Erland Sommarskog
    • Re: Create Login and Role Name, shapper
      • Re: Create Login and Role Name, shapper
      • Re: Create Login and Role Name, shapper
      • Re: Create Login and Role Name, Erland Sommarskog
• splitting of data elements - help in best way forward, Simon Whale
  • Re: splitting of data elements - help in best way forward, Bob Barrows
    • Re: splitting of data elements - help in best way forward, Simon Whale
  • Re: splitting of data elements - help in best way forward, --CELKO--
• Using "WITH TIES" SQL Clause, eliza sahoo
• Browse - How to Remove Duplicate Items, ray
  • Re: Browse - How to Remove Duplicate Items, ray
• Invalid object name when I try to create a scaler udf in a stored procedure., Julie
  • Re: Invalid object name when I try to create a scaler udf in a stored procedure., Uri Dimant
  • Re: Invalid object name when I try to create a scaler udf in a stored procedure., Erland Sommarskog
• customise dbo.udf_Txt_SplitTAB, Phil
  • Re: customise dbo.udf_Txt_SplitTAB, Uri Dimant
• Temp Table Context Problem In SP called by trigger?, Simon Eng
  • Re: Temp Table Context Problem In SP called by trigger?, Eric Isaacs
  • Re: Temp Table Context Problem In SP called by trigger?, Erland Sommarskog
    • Re: Temp Table Context Problem In SP called by trigger?, Simon Eng
      • Re: Temp Table Context Problem In SP called by trigger?, Eric Isaacs
      • Re: Temp Table Context Problem In SP called by trigger?, Erland Sommarskog
      • Re: Temp Table Context Problem In SP called by trigger?, Eric Isaacs
      • Re: Temp Table Context Problem In SP called by trigger?, Erland Sommarskog
      • Re: Temp Table Context Problem In SP called by trigger?, Eric Isaacs
• Group By - Select Columns Questions, ray
  • Re: Group By - Select Columns Questions, Eric Isaacs
    • Re: Group By - Select Columns Questions, ray
  • Re: Group By - Select Columns Questions, Erland Sommarskog
    • Re: Group By - Select Columns Questions, ray
      • Re: Group By - Select Columns Questions, Bob Barrows
      • Re: Group By - Select Columns Questions, ray
      • Re: Group By - Select Columns Questions, Bob Barrows
      • Re: Group By - Select Columns Questions, Eric Isaacs
      • Re: Group By - Select Columns Questions, Eric Isaacs
      • Re: Group By - Select Columns Questions, ray
• Query and Extract, dankonsoer
  • Re: Query and Extract, Dan
    • Re: Query and Extract, dankonsoer
      • Re: Query and Extract, Dan
      • Re: Query and Extract, dankonsoer
• The multi-part identifier "dbo.v_dtf_SCOpenCallsTech.preffullname" could not be bound., Anonymous User
  • Re: The multi-part identifier "dbo.v_dtf_SCOpenCallsTech.preffullname" could not be bound., Erland Sommarskog
• Reporting Services And Object Data Source, Giorgio Parmeggiani
  • RE: Reporting Services And Object Data Source, "Charles Wang [MSFT]"
  • <Possible follow-ups>
  • Reporting Services And Object Data Source, Giorgio Parmeggiani
    • RE: Reporting Services And Object Data Source, "Charles Wang [MSFT]"
• Why Inner join is better than equi join, Deep
  • Re: Why Inner join is better than equi join, Bob Barrows
    • Re: Why Inner join is better than equi join, Deep
      • Re: Why Inner join is better than equi join, Erland Sommarskog
      • Re: Why Inner join is better than equi join, Bob Barrows
      • Re: Why Inner join is better than equi join, --CELKO--
      • Re: Why Inner join is better than equi join, Bob Barrows
      • Re: Why Inner join is better than equi join, Tony Rogerson
  • Re: Why Inner join is better than equi join, Tony Rogerson
• SQL Server Training, DBATAG
• Name of procedure when running it, Roy Goldhammer
  • Message not available
    • Re: Name of procedure when running it, Dan Guzman
• Finding all table and fields that are involved in a one to many relation (on many side) with a given field, bz
  • Re: Finding all table and fields that are involved in a one to many relation (on many side) with a given field, Tom Cooper
    • Re: Finding all table and fields that are involved in a one to many relation (on many side) with a given field, bz
      • Re: Finding all table and fields that are involved in a one to many relation (on many side) with a given field, bz
  • Re: Finding all table and fields that are involved in a one to many relation (on many side) with a given field, Plamen Ratchev
• Using While Loop to Union Selects?, SnapDive
  • Re: Using While Loop to Union Selects?, Erland Sommarskog
  • Re: Using While Loop to Union Selects?, --CELKO--
• Calling a user-defined function?, Mij
  • Re: Calling a user-defined function?, Mij
  • Re: Calling a user-defined function?, Erland Sommarskog
• any word order match, mandy
• Fastest way to move lots of data between databases on same server., Dan
  • Re: Fastest way to move lots of data between databases on same server., Erland Sommarskog
    • Re: Fastest way to move lots of data between databases on same ser, Dan
      • Re: Fastest way to move lots of data between databases on same ser, Erland Sommarskog
  • Re: Fastest way to move lots of data between databases on same server., John Bell
• Operation between alias, Luciano \(DOC\)
  • Re: Operation between alias, Robert Ellis
  • Re: Operation between alias, --CELKO--
• image field where clause, Mecn
  • Re: image field where clause, Erland Sommarskog
• Plain Text In Image Field, JeffP->
  • Re: Plain Text In Image Field, John Bell
    • Re: Plain Text In Image Field, JeffP->
      • Re: Plain Text In Image Field, John Bell
• Grouping stored procedures, Bob
  • Re: Grouping stored procedures, Erland Sommarskog
• sql 2000 error handling, Mecn
  • Re: sql 2000 error handling, Erland Sommarskog
    • Re: sql 2000 error handling, Mecn
      • Re: sql 2000 error handling, Erland Sommarskog
      • Re: sql 2000 error handling, Mecn
      • Re: sql 2000 error handling, Mecn
      • Re: sql 2000 error handling, Erland Sommarskog
• SQL insert query help needed, Pantso
  • Re: SQL insert query help needed, Plamen Ratchev
  • RE: SQL insert query help needed, Q
• Migrating from MS Access, jodleren
  • Re: Migrating from MS Access, Plamen Ratchev
• Updating using groupby, Rocky20
  • Re: Updating using groupby, Plamen Ratchev
    • Re: Updating using groupby, Rocky20
• Scope Variables and SSIS Sequence Containers, jm27102
  • Re: Scope Variables and SSIS Sequence Containers, Jay Davis
• sys.conversation_endpoints not purged, Markus Kropik
• 'trusted' constraint, David Hearne
  • Re: 'trusted' constraint, Erland Sommarskog
• Re: Soundex Problem, Goldeye
• Help in update, Jami
  • Re: Help in update, Uri Dimant
• deleting from many tables., Bob McClellan
  • Re: deleting from many tables., Iain Sharp
    • Re: deleting from many tables., Bob McClellan
  • Re: deleting from many tables., Uri Dimant
  • Re: deleting from many tables., gareth erskine-jones
• SSRS doesnt like Guid param datatypes, moondaddy
  • Re: SSRS doesnt like Guid param datatypes, moondaddy
• how to join dynamic SQL results with another query, new DBA in '09
  • Re: how to join dynamic SQL results with another query, Plamen Ratchev
  • Re: how to join dynamic SQL results with another query, sam
  • Re: how to join dynamic SQL results with another query, Uri Dimant
  • Re: how to join dynamic SQL results with another query, Erland Sommarskog
    • Re: how to join dynamic SQL results with another query, new DBA in '09
      • Re: how to join dynamic SQL results with another query, Erland Sommarskog
      • Re: how to join dynamic SQL results with another query, new DBA in '09
      • Re: how to join dynamic SQL results with another query, Erland Sommarskog
  • Re: how to join dynamic SQL results with another query, --CELKO--
    • Re: how to join dynamic SQL results with another query, Erland Sommarskog
      • Re: how to join dynamic SQL results with another query, Tony Rogerson
      • Re: how to join dynamic SQL results with another query, new DBA in '09
      • Re: how to join dynamic SQL results with another query, Erland Sommarskog
    • Re: how to join dynamic SQL results with another query, Tony Rogerson
    • Re: how to join dynamic SQL results with another query, new DBA in '09
      • Re: how to join dynamic SQL results with another query, --CELKO--
      • Re: how to join dynamic SQL results with another query, new DBA in '09
      • Re: how to join dynamic SQL results with another query, --CELKO--
• DB2 on SS, John Grandy
• Available well experienced consultants for your positions, Teja
• Does asynchronous operation supported by oledb provider for openquery?, greenxiar
  • Re: Does asynchronous operation supported by oledb provider for openquery?, Erland Sommarskog
    • Re: Does asynchronous operation supported by oledb provider for openquery?, greenxiar
      • Re: Does asynchronous operation supported by oledb provider for openquery?, Erland Sommarskog
• Query question - Separating Columns?, Linn Kubler
  • Re: Query question - Separating Columns?, Iain Sharp
    • Re: Query question - Separating Columns?, Linn Kubler
      • Re: Query question - Separating Columns?, Plamen Ratchev
• Question about stored procedures - please advise., Mitchell_Collen via SQLMonster.com
  • Re: Question about stored procedures - please advise., Bob Barrows
  • Re: Question about stored procedures - please advise., --CELKO--
  • Re: Question about stored procedures - please advise., Tom Cooper
  • Re: Question about stored procedures - please advise., Sylvain Lafontaine
    • Re: Question about stored procedures - please advise., Sylvain Lafontaine
  • Re: Question about stored procedures - please advise., Erland Sommarskog
• Cast Varchar to Decimal?, SnapDive
  • Re: Cast Varchar to Decimal?, Eric Isaacs
    • Re: Cast Varchar to Decimal?, Eric Isaacs
    • Re: Cast Varchar to Decimal?, John Bell
      • Re: Cast Varchar to Decimal?, Eric Isaacs
  • Re: Cast Varchar to Decimal?, Sylvain Lafontaine
    • Re: Cast Varchar to Decimal?, Erland Sommarskog
      • Re: Cast Varchar to Decimal?, Eric Isaacs
• Begin and End Block in an IF statement, RG
  • Re: Begin and End Block in an IF statement, Erland Sommarskog
  • Re: Begin and End Block in an IF statement, --CELKO--
    • Re: Begin and End Block in an IF statement, Jellifish
• Purple Indulgence——ghd new limited edition color collection, zhan dandan
• Selecting Maximum Values in a Query with joins to other tables, Glenn
  • Re: Selecting Maximum Values in a Query with joins to other tables, Tom Cooper
    • Re: Selecting Maximum Values in a Query with joins to other tables, Glenn
  • Re: Selecting Maximum Values in a Query with joins to other tables, Erland Sommarskog
    • Re: Selecting Maximum Values in a Query with joins to other tables, Glenn
      • Re: Selecting Maximum Values in a Query with joins to other tables, Erland Sommarskog
• Selecting Top Records from Subquery, scott
  • RE: Selecting Top Records from Subquery, Q
• Create function concatenate, Steph
  • Re: Create function concatenate, Plamen Ratchev
    • Re: Create function concatenate, Steph
      • Re: Create function concatenate, Erland Sommarskog
      • Re: Create function concatenate, Steph
      • Re: Create function concatenate, --CELKO--
      • Re: Create function concatenate, Erland Sommarskog
• Try Catch to Pinpoint Set-Based Error?, SnapDive
  • Re: Try Catch to Pinpoint Set-Based Error?, Erland Sommarskog
    • Re: Try Catch to Pinpoint Set-Based Error?, SnapDive
      • Re: Try Catch to Pinpoint Set-Based Error?, Bob Barrows
      • Re: Try Catch to Pinpoint Set-Based Error?, Erland Sommarskog
      • Re: Try Catch to Pinpoint Set-Based Error?, SnapDive
      • Re: Try Catch to Pinpoint Set-Based Error?, Erland Sommarskog
      • Re: Try Catch to Pinpoint Set-Based Error?, SnapDive
• many reports solution, Ryan Liu
• tuning import of large dataset, Jeff
  • Re: tuning import of large dataset, Erland Sommarskog
  • Re: tuning import of large dataset, Dan Guzman
  • Re: tuning import of large dataset, Geoff Schaller
• deleting duplicate rows, Keith G Hicks
  • Re: deleting duplicate rows, Bob McClellan
    • Re: deleting duplicate rows, Keith G Hicks
  • Re: deleting duplicate rows, Erland Sommarskog
    • Re: deleting duplicate rows, Keith G Hicks
      • Re: deleting duplicate rows, Dan Guzman
  • Re: deleting duplicate rows, --CELKO--
    • Re: deleting duplicate rows, Geoff Schaller
      • Re: deleting duplicate rows, gareth erskine-jones
    • Re: deleting duplicate rows, Keith G Hicks
      • Re: deleting duplicate rows, Geoff Schaller
• Preferable option for shredding (performance-wise), sk
  • Re: Preferable option for shredding (performance-wise), Erland Sommarskog
    • Re: Preferable option for shredding (performance-wise), sk
      • Re: Preferable option for shredding (performance-wise), Erland Sommarskog
• Is msdtc required to be installed on the boxes in this scenario?, Ben
  • Re: Is msdtc required to be installed on the boxes in this scenario?, Geoff Schaller
  • Re: Is msdtc required to be installed on the boxes in this scenario?, Erland Sommarskog
    • Re: Is msdtc required to be installed on the boxes in this scenario?, Geoff Schaller
      • Re: Is msdtc required to be installed on the boxes in this scenario?, Erland Sommarskog
• Organizing Solutions and Projects, Bob McClellan
  • Re: Organizing Solutions and Projects, Geoff Schaller
    • Re: Organizing Solutions and Projects, Bob McClellan
• Is there any replacement for SQLXML in sql server 2008 R2?, Allan2010
• Split T-SQL UDF function to return the result as table, Praveen Kumar
• Union versus multiple join conditions, J.B. Moreno
  • Re: Union versus multiple join conditions, Erland Sommarskog
    • Re: Union versus multiple join conditions, J.B. Moreno
  • Re: Union versus multiple join conditions, --CELKO--
    • Re: Union versus multiple join conditions, Geoff Schaller
• loop, geebee
  • Re: loop, Dan Guzman
  • Re: loop, Cleary
• Fastest way to Copy DB + Keys,Constraints to another server, xpander
  • Re: Fastest way to Copy DB + Keys,Constraints to another server, Dan Guzman
• Suspended bcp, Dan
  • Re: Suspended bcp, Erland Sommarskog
• Query question on joining information from two tables, Nobody
  • Re: Query question on joining information from two tables, Plamen Ratchev
    • Re: Query question on joining information from two tables, Nobody
      • Re: Query question on joining information from two tables, Plamen Ratchev
      • Re: Query question on joining information from two tables, Nobody
• Remote restore, Rob
  • RE: Remote restore, Rob
• Database roles execute, tshad
  • Re: Database roles execute, Erland Sommarskog
• ssms 2005 temp table issue, Keith G Hicks
  • Re: ssms 2005 temp table issue, Erland Sommarskog
    • Re: ssms 2005 temp table issue, Keith G Hicks
      • Re: ssms 2005 temp table issue, Keith G Hicks
      • Re: ssms 2005 temp table issue, Erland Sommarskog
      • Re: ssms 2005 temp table issue, Keith G Hicks
      • Re: ssms 2005 temp table issue, Erland Sommarskog
      • Re: ssms 2005 temp table issue, Keith G Hicks
      • Re: ssms 2005 temp table issue, Erland Sommarskog
• rank by number of rows, gv
  • Re: rank by number of rows, gv
    • Re: rank by number of rows, Tom Cooper
      • Re: rank by number of rows, gv
      • Re: rank by number of rows, gv
      • Re: rank by number of rows, Erland Sommarskog
      • Re: rank by number of rows, gv
      • Re: rank by number of rows, gv
      • Re: rank by number of rows, Erland Sommarskog
• Help finding first payment date and amount, Rocky20
  • Re: Help finding first payment date and amount, Tom Cooper
• Deploy script, JMMB
• Deploy script in DOS, JMMB
  • Re: Deploy script in DOS, Erland Sommarskog
• Convert string to uniqueidentifier?, James
  • Re: Convert string to uniqueidentifier?, Erland Sommarskog
    • Re: Convert string to uniqueidentifier?, James
  • Re: Convert string to uniqueidentifier?, John Bell
    • Re: Convert string to uniqueidentifier?, James
      • Re: Convert string to uniqueidentifier?, John Bell
  • Re: Convert string to uniqueidentifier?, Erland Sommarskog
    • Re: Convert string to uniqueidentifier?, James
• Need help T-SQL convert column to row., LN
  • Re: Need help T-SQL convert column to row., Tom Cooper
    • Re: Need help T-SQL convert column to row., LN
• Using LIKE in sp_executesql, Bassam
  • Re: Using LIKE in sp_executesql, Erland Sommarskog
    • Re: Using LIKE in sp_executesql, Bassam
      • Re: Using LIKE in sp_executesql, Erland Sommarskog
• Round to nearest whole number or x.5, Polaris431
  • Re: Round to nearest whole number or x.5, Tom Cooper
• MonthName Year to YYYYMM Conversion, Vijay via SQLMonster.com
  • Re: MonthName Year to YYYYMM Conversion, obiron via SQLMonster.com
  • Re: MonthName Year to YYYYMM Conversion, Plamen Ratchev
• SQL Command question, Pat
  • Re: SQL Command question, John Bell
• How to use GO with a sql string, Pat
  • Re: How to use GO with a sql string, Jeroen Mostert
• RE: Multiple sessions when using ADO, John
  • RE: Multiple sessions when using ADO, Erland Sommarskog
• Alternatives to cursors, Loren Z
  • Re: Alternatives to cursors, Bob Barrows
• Insert Trigger on a BulkCopy, Brian Shafer
  • Re: Insert Trigger on a BulkCopy, Erland Sommarskog
• Merge membership, qjlee
  • Re: Merge membership, --CELKO--
• Failed select query over linked server, need help please
  • Re: Failed select query over linked server, Erland Sommarskog
    • Re: Failed select query over linked server, ilya
      • Re: Failed select query over linked server, Erland Sommarskog
• Selecting largest for each group, David Olsen
  • Re: Selecting largest for each group, Tom Cooper
  • Re: Selecting largest for each group, obiron via SQLMonster.com
• UPDATE in UDF, DavidC
  • RE: UPDATE in UDF, Rich
    • RE: UPDATE in UDF, DavidC
• scope_identiry, jonpb
  • Re: scope_identiry, Jeroen Mostert
    • Re: scope_identiry, jonpb
      • Re: scope_identiry, Jeroen Mostert
      • Re: scope_identiry, jonpb
      • Re: scope_identiry, Jeroen Mostert
• ALTER DATABASE [...] SET COMPATIBILITY_LEVEL = 100 ---- giving err, Rich
  • RE: ALTER DATABASE [...] SET COMPATIBILITY_LEVEL = 100 ---- giving err, Rich
  • Re: ALTER DATABASE [...] SET COMPATIBILITY_LEVEL = 100 ---- giving err, Erland Sommarskog
• Partition Handling, CLM
• Re: Change Tracking Help?, SnapDive
• Singleton GetNext Behavior?, SnapDive
  • Re: Singleton GetNext Behavior?, Jeroen Mostert
  • Re: Singleton GetNext Behavior?, Uri Dimant
• Re: Few confusing things about transactions, trubar a
  • Re: Few confusing things about transactions, Erland Sommarskog
    • Re: Few confusing things about transactions, trubar a
      • Re: Few confusing things about transactions, Erland Sommarskog
      • Re: Few confusing things about transactions, trubar a
• IDENTITY INSERT issue with INSERT INTO..SELECT, Bodo
  • Re: IDENTITY INSERT issue with INSERT INTO..SELECT, John Bell
  • Re: IDENTITY INSERT issue with INSERT INTO..SELECT, Erland Sommarskog
  • RE: IDENTITY INSERT issue with INSERT INTO..SELECT, Bodo
• UPDATE over the linked server, simon
  • RE: UPDATE over the linked server, Binu T V
  • Re: UPDATE over the linked server, Erland Sommarskog
    • Re: UPDATE over the linked server, simon
      • Re: UPDATE over the linked server, simon
      • Re: UPDATE over the linked server, Erland Sommarskog
      • Re: UPDATE over the linked server, simon
      • Re: UPDATE over the linked server, Erland Sommarskog
• sunday is my week ending day, rodchar
  • Re: sunday is my week ending day, Maria
  • Re: sunday is my week ending day, Peso
  • RE: sunday is my week ending day, rodchar
• Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Iain Sharp
  • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, --CELKO--
    • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Tony Rogerson
    • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Simon Whale
    • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Iain Sharp
      • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Dooza
      • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Philipp Post
      • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Iain Sharp
      • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Simon Whale
      • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Iain Sharp
      • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Iain Sharp
      • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Tony Rogerson
  • <Possible follow-ups>
  • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Peso
  • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, --CELKO--
    • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Dooza
  • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, --CELKO--
    • Re: Query Question - Friend - Friend - Friend - Friend ... relationshi, Tony Rogerson
• stored procedure running only from code, vsiat
  • Re: stored procedure running only from code, Maria
  • Re: stored procedure running only from code, Bob Barrows
  • Re: stored procedure running only from code, Erland Sommarskog
  • Re: stored procedure running only from code, Peso
• Re: Stored Proc to Call Same stored proc, Iain Sharp
• Re: Using Union All in a stored proc, --CELKO--
  • Re: Using Union All in a stored proc, Geoff Schaller
• Forming a date, DavidC
  • Re: Forming a date, Bob Barrows
  • Re: Forming a date, --CELKO--
  • Re: Forming a date, Peso
• Re: How write this sql query, Erland Sommarskog
  • Re: How write this sql query, Plamen Ratchev

• Windows
• Science
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint

www.tech-archive.net  > Archive  > SQL-Server  > microsoft.public.sqlserver.programming  > 2010-06