TheMSsForum.com >> SQL Server Programming >> Archive Page 97 - The Microsoft Software Forum

view full version: back to formated view

33601: Clustering and Domain Groups
33602: backup on SQL2005EE
33603: Concatenating column values for each uniqueid
33604: Using Functions
33605: Update some entries of a table with values of a another table
33606: size of datafiles in sql
33607: Get First Row per Group
33608: tree select problem
33609: Join 2 tables in one column
33610: count rows with a dynamic statment
33611: update a column populated with a duplicate value
33612: Stored procedure > Cursor or other in output
33613: Storing Multiple Values in Single Value
33614: TableName as Parameter?
33615: Nested Loops vs. Hash Match
33616: UPDATE SP works in QA but not in VB
33617: matching saved searches to newly inserted record
33618: Why can't a LEN argument be passed to a CAST call?
33619: How to add strings to NTEXT data type
33620: Access Text Within A SQL Binary Field
33621: ALTER TABLE to add NOT NULL fields
33622: DELETING 100 million from a table weekly SQl SERVER 2000
33623: Six Degrees of Separation
33624: xp_cmdsh
33625: dts fired from sp
33626: Pivot SQL Statement in SQL SERVER 2000
33627: Unique Index Vs Primary Index in SQL Server 2000
33628: Index Tuning Multiple Queries
33629: Calling SQL Stored Procedure from ASP
33630: substitution
33631: how do I prevent duplicate ID in my situation
33632: Extended Stored Procedure creation error
33633: Clustered Index -minimize the cost of Page Splitting
33634: "Could not find stored procedure 'sp_sdidebug'" SQL 2005 VERY URGENT
33635: ReadOnly Cursor
33636: Query with OR never completes
33637: Transaction Log in a large delete operation performed in steps.
33638: Date issue
33639: Sporadic Behavior From ITW
33640: Date issue
33641: how do i say this...
33642: Subqueries... document reference? (sql2k)
33643: SQLBulkCopy WriteToServer timeout exception occassionally
33644: Program for scripting data
33645: How can I get a table reference knowing his name inside a system f
33646: [OT] SQL 2005 Launch - San Francisco
33647: how to process each record of select results
33648: Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.
33649: dayly table update
33650: Stored Procedure Development
33651: UDF and table variable
33652: How to add a "synonym" to a row ...
33653: Copy Columns
33654: Syntax error converting from a character string to uniqueidentifier
33655: DB Design issue
33656: Help selecting maximum number of characters
33657: Stop/Start SQLSERVERAGENT service with Transact-SQL
33658: best solution?
33659: ADO won't catch error while execute an Stored Procedure, Why?
33660: Query Analyzer
33661: Why does this code fail as stored procedure?
33662: SQL Join question
33663: Challenge! Trying to understand this piece of code
33664: SP not bring me a value
33665: How to calculate comparisons of fields between records
33666: UPDATE TABLE question, please
33667: SQL: How to Select MAX(Val1, Val2) ??
33668: Dynamic table processing
33669: How can I store the result to a variable in procedure?
33670: Truncate part of the record
33671: extrapilate data - create many rows from 1 row
33672: search for record with alpha characters
33673: Weird unc vs ip address
33674: Deleting large amount of data on sql server 2000
33675: Remote Query Join Performance
33676: query help...
33677: Attaching Database 'AdventureWorks'???
33678: Attaching Database 'AdventureWorks'???
33679: Display data by Weekly in a specified period
33680: Display data by Weekly in a specified period
33681: Display data by Weekly in a specified period
33682: Display data by Weekly in a specified period
33683: Next Friday
33684: dynamically creating temp tables
33685: limit rows in join
33686: SQL 2005 question
33687: Updating a column in many rows from values in other tables
33688: Order problem
33689: ORDER BY decreases performance by 40x?
33690: decimal datatpe with less than or equal
33691: Insert / Compare on multiple columns
33692: Why does the presence of a UDF (that is not referenced) in a view cause the execution plan to change?
33693: Query Help: Looking for Nextdate based on many prev date fields
33694: Stored Procedure question
33695: Dynamic SQL
33696: Visual Source Safe & SQL Server
33697: sysobjects.sysstat
33698: Row Count on all Tables in Database?
33699: Help with Syntax please
33700: SQL Server 2005 & Visual Studio 205 RC
33701: After insert trigger fires even though no insert actually occured
33702: Openquery issue
33703: grouping and showing concatenated varchar column?
33704: Code behaviour/performance on 2 machines
33705: AddNew then getting Unique ID
33706: Question abount how to make a Ranking
33707: Primary key is it a must??
33708: A list of all SQL Servers on my network.
33709: Help with dynamic select count() statment
33710: Design issue - advice needed
33711: how to SELECT by unique identifier
33712: Return Time only from Date/Time
33713: stripping 5 characters before rightmost semicolon in string
33714: SQL to convert in to a Proper Name
33715: display numbers in a specific format
33716: Date help
33717: SQL Count Problem
33718: please help
33719: Reading data from table
33720: Running sum?
33721: Rename tables and fields
33722: xp_sendmail fails
33723: Identity seed lost...?
33724: Urgent
33725: Query Help Needed
33726: select to return most recent records
33727: CHECKALLOC error
33728: Selecting and exporting large amount of data (rows) takes so long
33729: Job offer: ASP.NET/WSS/SQL Server/CMS Developer Nuernberg/Germany
33730: Changing table value being field name
33731: Sql Server Service Manager
33732: MSDE question
33733: Design Problem
33734: Returning 2 values from the same table
33735: MSDTC
33736: Urgent SQL query help, please !
33737: How to get field value from a dynamic table in stored procedure
33738: Joining two large queries as derived tables
33739: Joining two large queries as derived tables
33740: Joining two large queries as derived tables
33741: Divide By Zero in the Where Condition
33742: executing a DTS package
33743: Getting the host_name value used in dynamic filter when merge succeeds.
33744: Replication or clustering or load-balancing or something. Is this possible?
33745: SQL Server SmallDateTime Problem
33746: Select records with sequential numbers
33747: Retrieving row parameter from query
33748: Help with Structure for New Database
33749: Permission error on transfer to protected Excel worksheet
33750: for each record updated
33751: delete from table
33752: [SQLSTATE 42000] (Error 50000)
33753: Accessing Excel functions in SQL SP
33754: Update problem
33755: Select Distinct
33756: sysindexes table status = 0?
33757: Bulk Insert question
33758: EXISTS Clause behavior
33759: Mass Import of data into Sql 2000
33760: Method/Definition inside T-SQL
33761: Capture new and modified data
33762: Help with query that only returns filds with certain characters
33763: Best Technology for Reporting.
33764: Could you please help me?
33765: Any SQL equivalent of InStrRev()?
33766: Replication - Mirroring - Clustering?
33767: unicode and column separator
33768: Unicode problem
33769: Problem With Partition View Insert
33770: Index on foreign key [newbie] ?
33771: Compatibility problem SQL 2005 <-> SQL 2000
33772: Convert datetime
33773: Space and nvarchar column
33774: sp_trace_setstatus - How Do I know which SPID is running the profile Trace?
33775: Change Column Ordinal Position with T-SQL
33776: refrence
33777: How to check for keywords?
33778: how to - table join - either this column or that
33779: Construct datetime value from seperate date and time
33780: Access Hangs on "Delete *" from linked table
33781: Strange behaviour of query
33782: SQL Agent
33783: SQL2005 Embedded
33784: Which style for "if exists" is better
33785: Dropping the time
33786: Error - identifier too long
33787: avoid cursors.
33788: Loop through all User Tables
33789: INSERT multiple record statement
33790: question
33791: query
33792: Urgent:Error in UPDATETEXT across servers
33793: =?Utf-8?Q?Tough!_SELECT_Question=E2=80=A6?=
33794: Accessing remote SQL 2005 db using C# express edition
33795: Select Dates
33796: ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE
33797: SQL Select help
33798: Remove Character from a table?
33799: Return Values - parameters
33800: Array in TSQL?
33801: Where is sp_sendsmtpmail
33802: CHAR vs. VARCHAR
33803: Different Date Formats when using xp_cmdshell
33804: Table Variables to Real Tables
33805: Encrypt entire database in SQL Server 2005 ?
33806: Changing column name
33807: RowModCtr Not Updating ?
33808: INSERT INTO a cursor gives error
33809: Need Help with a Cursor
33810: Asynchronous Batch Processing
33811: Update substring
33812: SQL Blocking?
33813: DB design question...
33814: New data types in SQL Server 2005
33815: HELP w/Restoring db
33816: CASE Stattement With UPDATE
33817: Backup Job Failed
33818: Using Labels ON T-Sql
33819: SQL query help: data in one line
33820: Inserting into a table via a select statement
33821: trigger
33822: Repair/Recreate MSDB
33823: Copy Content from Db1 (inconsistent) to Db2
33824: Problem:fail to invoke remote RPC method
33825: Is portability dead? Do you follow strict ANSI SQL and not use vendor extensions?
33826: Information Schema Query on linked server fails.
33827: **defining public function**
33828: Update is taking too long
33829: "Bad variable type" error msg -- can't get past it.
33830: Chat: The Visual Studio Debugger, November 3rd @ 1pm Pacific Time
33831: Searching through separated list
33832: Unable to run sp_executesql
33833: Unable to use sp_executesql
33834: Creating a date range during runtime in SELECT
33835: if else with WHERE
33836: NOT IN....
33837: TSQL help - Case?
33838: Intersection of N sets
33839: string parsing
33840: If statements - I think
33841: Changing current database during local tx or xa tx
33842: Selecting the most recent date...
33843: What is an update-in-place?
33844: Restoring Tran. Log files
33845: Need help determining occurences of a specific value
33846: query to detemine trigger status
33847: nedd some help with datetime
33848: SQL system Procedure
33849: User specific tables
33850: Information Schema Query Question
33851: xp_cmdshell and terminating a bad shell command
33852: help with indexes
33853: Job and Stored Procedure Problems
33854: ADOX Datatypes confused
33855: Newbie: Computed column in WHERE clause - how ?
33856: Query a pricelist for price breaks
33857: SQL server character type
33858: Assigning permissions to a table
33859: How can I optimize this routine
33860: Null Column Question
33861: How to View Transaction Log...
33862: T-SQL statement performing quicker than same statement in sproc
33863: multi column subquery using IN clause
33864: Conditional join
33865: Date Times and execution plans
33866: BCP/Bulk Insert and Incoming Dates
33867: splitting names
33868: How can wrap a case statement around us
33869: Trigger BEFORE DELETE to SET NULL into child
33870: Troubleshooting stored proc performance heisenbug
33871: need help to find a set based solution
33872: Doubt aboult loop in trigger?
33873: Database Security Question - Can this be done?
33874: Microsoft Distributed Transaction Coordinator call failed.
33875: Where to find Unique Value indic of index in sys tables
33876: how to send query from SQL Server using post method
33877: find missing numbers in a continuous serie
33878: Need assistance
33879: Version and SP
33880: Identifying row with duplicate column entry with different Primary
33881: remove duplicate row
33882: Date/Time formatting
33883: Where to get Query Analyzer SP3
33884: Format number with 2 decimal places
33885: Problem with HOST_NAME Function with Linked View
33886: Aggregate Problem
33887: set @var = (exec stored proc)
33888: Percentage calculation in SQL Server
33889: Trigger rule problem
33890: Trbasaction in trigger?
33891: Check constraints
33892: Improving Joins
33893: Connection Broken
33894: Computed field with a maximum
33895: Joe Celko Theory
33896: Finding the latest datetime from SP
33897: Stored Procedure Variables
33898: Most efficient way to poll a table?
33899: Another Newb SQL Question
33900: Creating Tables on the Fly
33901: Syntax Problem
33902: Ignore errors?
33903: DTS is rubbish
33904: Pivoting a one-many relationship into 1 row
33905: unique constraint to a column from another table
33906: Retrieving Login Name?
33907: user Associated with a pid
33908: week number within the month
33909: SQL 7.0 and VS.NET 2005
33910: error handling and logging within a trigger - how much of this would work / would be required?
33911: HOWTO Build single query to query a remote SQL Server
33912: Got err: There is already an object named '#TEMP' in the database.
33913: Backup Failure
33914: Searched Column w/Case for column name: Invalid column name 'TACD'
33915: LOCK & SELECT Behavior
33916: How to upload Image into Table
33917: re: Host_Name & IP address
33918: DTS problem
33919: Need help with the sequel statement please.
33920: HAVING vs. WHERE
33921: Sort Help
33922: displaying found duplicate - both records
33923: Query DTS packages
33924: Cannot get to work a sentence with NULL results
33925: Host_Name & IP address
33926: Re: Script out "Trigger rules"
33927: Scripting data values
33928: How to detect INSTALLED SQL version?
33929: Help with Case Statement
33930: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID X) was deadlocked
33931: re: Script out "Trigger rules"
33932: Script out "Trigger rules"
33933: Re: newbie select and update thanks
33934: BCP Help - Incorrect host-column number found in BCP format-file
33935: restructure on query
33936: help with Check contraints
33937: Help tranlating values and Nulls
33938: Urgent -- Access QRY to SQL Server QRY
33939: Cannot register a server
33940: why this date conversion?
33941: ARITHABORT problems
33942: Login not allowed to do bulkinsert?
33943: thousand seperator problem
33944: Passing results from select into exec
33945: stored procedure hangs
33946: Time zones
33947: How to lock only the lines in the result set ?
33948: How to do an update only if it will not be blocked by a lock ?
33949: Cursor for dynamic sql
33950: how can i pass dataset to stored procedure