TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
21001: Speed??????
21002: A pivot table/Report with dynamic columns??
21003: SQL 2005: Why does DECLARE varchar(MAX) in Stored Procedure not work?
21004: HOW TO: PIVOT for unknown number of column headings?
21005: Programmatic package execution - SQL Server 2005
21006: Assistance with SQL Script
21007: View fails though underlying query works in QueryAnalyzer
21008: How do I Convert this Statement to T-SQL Code?
21009: query to return month strings for year
21010: Oracle string functions conversion to T-SQL
21011: Single to Multiple columns
21012: where datetime between 2PM and 3PM
21013: Database Performance query
21014: Query Help
21015: Incease Database size
21016: SQL permission problem
21017: SQL contacts to mobile phone
21018: Best way to document databases ?
21019: SQL Query
21020: How to concatenate strings from a column into a single row (with NULL value)?
21021: Creating a view do display normalised data flattened
21022: avoiding table lock whe updating million of records at a time
21023: sql time out
21024: How to use ROBUST PLAN in the query??
21025: Copy diagrams from one db to another
21026: sql injection question
21027: PICKLIST IN SQL
21028: How to select a single varchar combined by many rows?
21029: need help on sql
21030: OPENROWSET
21031: passing a table from one sp to another sp
21032: SQL problem to solve...
21033: How to utilize the rowId in sql server
21034: Temp Table Indexing??
21035: Query help
21036: Shipping 2
21037: training
21038: data disappearing in a trigger
21039: done in a single statement
21040: Need help with self-join
21041: done in a single statement
21042: xp_cmdshell - works with string in one format but not in another -
21043: What is the best SQL to always keep 50 latest rows in a table?
21044: Are operations in a stored procedure treated as a transaction
21045: getting sa password
21046: SSIS and SLowly Changing DImension Transform
21047: SQL query
21048: Update Statement
21049: Date Range
21050: Ship
21051: Case-sensitivity and LIKE - not working in 2000?
21052: OpenrowSet querry
21053: UDF Permissions
21054: Problem with repeated use of temp tables
21055: large result sets
21056: How best to create a unique identifier across two or more tables...
21057: Win Server 2003 SP2 - SQL2k5 Performance Improvements
21058: Date Query
21059: Small problem with NOT EXISTS...
21060: Small problem with NOT EXISTS...
21061: UNDO
21062: Linked Server Error: Login failed for user NT AUTHORITY\ANONYMOUS LOGON
21063: Converting Rows into columns
21064: Statistic Problem
21065: Simple SQL query for counts and Sum
21066: Union with the results of two SP
21067: XP_SENDMAIL Overload in SQL 2005
21068: Operator on a table that has UDTs and returns a table of UDTs
21069: how to do this
21070: Resetting Identity/Auto-increment Seed
21071: Time recording query
21072: SSIS package for adwentureWorksDW database
21073: DTS Newbie Exported Package to VB: How can I tell from the VB if Parallel
21074: Query help.... with CASE
21075: Aggregate columns in a UNION
21076: Transfer Data From One Database to another Database
21077: get autogenerated id after insert
21078: Help with query...
21079: sorting problem
21080: How to get the SP name in the SP?
21081: SQL Syntax - Incorrect Syntas near '1'
21082: T-SQL
21083: get counts for each unique value in a column
21084: what is the code to see the all the indexes
21085: Length too long
21086: Bulk Insert Unix Text files
21087: Bulk Insert To Temp Table - Security Issue
21088: UPDATE TOP 1
21089: sql 2005 faster than 2000?
21090: Full-Text Searching
21091: Is it possible to trace all statements to a specific table?...
21092: Any need for TEXT/NTEXT column types in SQL2005
21093: Multi Record sets from SProcs
21094: Deleting a record dynamically
21095: Errors
21096: Select Right From A Specific Character
21097: What am I missing with this simple query?
21098: Passing username to sql server from an app
21099: Updategrams and Application Roles
21100: For insert trigger problem
21101: Joined Query With Optional Data
21102: Data page storage
21103: joining results of query to another table
21104: SQL search for similar records with different dates
21105: Sequentially Numbering Groups of Records
21106: rowset returned from sp when using sql debugger
21107: Different result from Script and SP
21108: Set Database Context inside a stored proc
21109: OSQL doesn't set ERRORLEVEL
21110: Lock and unlock a database
21111: Little bug in sql2005?
21112: Need Consecutive Query
21113: Table Design
21114: Max lenght (8000) in string in OpenQuery
21115: Passing tableName as parameter to SP
21116: problem with synonyms
21117: Performance Question
21118: xml and self referencing table
21119: date
21120: Explain this please!
21121: TABLE FUNCTION
21122: Generate intervals
21123: help me
21124: **SORT THE PHYSICAL ORDER ON A TABLE'S COLUMNS**
21125: INSTEAD OF TRIGGERS DO NOT SUPPORT DIRECT RECURSION
21126: Dynamically flattening a table
21127: **SET NULL**
21128: XP_CMDSHELL Problem
21129: How do I GRANT TRUNCATE TABLE?
21130: [sql2000] create login and create user?
21131: Trying to do a blog join (entry columns, and # of comments) without success
21132: How do I.....?
21133: Assign A Flag Value
21134: SQL 2005 slower than 2000?
21135: Problem connecting to a 2K DTS pkg
21136: TSQL array
21137: HELP WITH QUERY
21138: running a DTS package from an SP
21139: Dynamic SQL and column-values
21140: Re: Connections List
21141: Other ways to run this query?
21142: SSPI
21143: validate statement before execute with sp_executesql
21144: Select into existing table
21145: Separate Records Into Multiple Records
21146: Authentication and Auditing: Incorrect username in Audit Tables
21147: Connections List
21148: A .NET Framework error occurred during execution of user defined r
21149: sql statement (how to)
21150: Update Information in SQL from a VBS script
21151: Query question
21152: Cannot Deploy CLR Function...
21153: Converting Orcale DECODE stmt to T-SQL
21154: Setting up the SQL Server alias programatically
21155: Login
21156: Dynamic SQL load into dynamic table
21157: Return a City in a column on max count from another column in a group by
21158: Need help with select statement
21159: Matching values within a column
21160: Trasnactions in triggers
21161: Profiler problem
21162: SQL Select using parameter
21163: Trigger
21164: Want to display the execution time of a SP
21165: CAST and CONVERT Dates
21166: SQL 2005 MCDBA Preparation
21167: sp4 installation
21168: SQL statement increase question
21169: timeout expired
21170: The opposite to DECLARE..
21171: Two instances of sql on one server causes problems
21172: Help me performance optimize
21173: Strange result
21174: Case order by
21175: how to query this linkedserver
21176: Query question
21177: Tree table
21178: How to configure the Active Directory users to SQL 2005 Database with selected permissions
21179: Search for text in pdf stored in database?
21180: Need CheckSum Algorithm
21181: Need CheckSum Algorithm
21182: Programatically Accessing Maintenance Plans through SMO
21183: General question
21184: How do I run a DTS package from vb.net
21185: Server: Msg 8623 - The query processor could not produce a query p
21186: Cannot see system views?
21187: Data Manipulation
21188: How to calculate a 5 minute running average?
21189: Script for importing Windows active directory domain user accounts?
21190: CURRENT DATE
21191: Execute AT <linked server name>
21192: Money formatting
21193: execute checkpoint command in stored procedure for specific databa
21194: Is "inner join" the same as "join"?
21195: number spread over a few quarter
21196: Using XML templates
21197: SQL2K: Query to consolidate multiple rows into single row with additional data?
21198: ACCESS TO MSSQL Incorrect syntax near the keyword 'AS'.
21199: ACCESS TO MSSQL Incorrect syntax near the keyword 'AS'.
21200: Database Design ROI White Paper
21201: Trouble with Stored Procedure - SQL 2005
21202: Deadlock Victim!!!!
21203: error-checking in dynamic SQL?
21204: how do i add the records
21205: getting the records returned by one query and not another
21206: local variable not recognized when executing dynamic sql
21207: Delete duplicate records
21208: NDF and file groups
21209: Syntax error converting datetime from character string
21210: Tool to compare SQL Schema?
21211: Trigger ID
21212: URGENT - Cannot find bad data in table
21213: query optimisation
21214: SQL Challenge
21215: Database Id prb !
21216: Fast "InUse" flag.
21217: c sql server library?
21218: Using EXECUTE AS
21219: Service Broker
21220: Rollback actions of SP
21221: Synonym Schema Issue (Change in Schema Version)
21222: How to pass a list of parameters from Select Table
21223: Read system catalogs for a from another user
21224: Storing all Upper Case value
21225: SELECT IIF(True,Null,'' ) equvalent in sqlserver
21226: Backup of mssql server in LAN
21227: Application design help: ADO.NET
21228: VARCHAR(8000) Does Not Work
21229: Database design question
21230: Selecting minimum between 2 values - Sybase SQL
21231: What is it that I don't understand about varbinary and datatype co
21232: best way to bulk update
21233: sproc variable question-newbe
21234: Running Average Query ? A Challenge
21235: SQL 2005: Pivot question
21236: Problem with full text index in farsi language
21237: Which function can convert number value to string with lead zero?
21238: Displaying time as 1:20 PM
21239: I have no blog
21240: Trigger logic - this ok
21241: Trigger question
21242: xml file into table
21243: 'System.OutOfMemoryException' ?
21244: Formatting and returning Time from Text
21245: Deferred drop
21246: rows to column sql server 2000
21247: Copying data from 2000 to 2005. Indentity insert not working
21248: Views Vs Stored Procedures!
21249: "Order By" Parameter to a Stored Procedure
21250: Migrate data from Access to SQL 2005
21251: Migrate data from Access SQL 2005
21252: Can an email trigger a DTS Package?
21253: ALTER TABLE
21254: HOW TO CALL A USD IN A SP
21255: Alter Seed value of Identity column
21256: Order by causing query to return very slow
21257: SELECT INTO temp table - Pros and Cons
21258: Even after year of coding I ask...
21259: SQL Server 2000 setup issues
21260: can't connect to sql2k5 server remotely
21261: Challenging query
21262: How to implement transactions
21263: Making Sql Server public?
21264: how to return only numeric chars from column?
21265: Top 2 max operations
21266: error debugging in query analyzer
21267: Is it possible to return all parent rows but only first child row of each parent for a t-sql join?
21268: How to tell if an Index has ever been used...
21269: Passing a table into a function
21270: Help with SELECT statement
21271: can Case test for < or > values?
21272: Mdf and Ldf files
21273: Trigger testing
21274: Can I create an index on a varable table
21275: Trigger Tricks ?
21276: Case-Sensitive Text Comparissons
21277: UDF function
21278: Update row with cursor joining to another table
21279: Exec cannot see Inserted?
21280: INSERT LOTS of values
21281: Query Works fine in Access but not in SQL Server
21282: Query Works fine in Access but not in SQL Server
21283: Query Analyser Debugger
21284: pull table Schema
21285: Query Problem
21286: Update/Insert and Delete Query Optimisations
21287: Check constraint script problem
21288: Get last date in result set
21289: Managed Stored Procedures
21290: Rounding datetime
21291: Deallocate cursor overhead
21292: query same table twice for different users in one query?
21293: How to limit date Range
21294: Log Shipping & Query Plans
21295: Access current active workbook from DLL
21296: DECLARE and table strucutres
21297: Visual Basic 6.0 vs .NET Framework
21298: SQL Guru's - please help paging with a distinct recordset
21299: Attach and detach a standby database in SQL 2K5
21300: use sp as default column value
21301: Are SProc parameters stored in a system (2005) table!
21302: Import XML using FOREACH Loop container
21303: xp_smtp_sendmail send out corrupted email message for large attach
21304: inner join in an update
21305: TOP 10 for each group
21306: Computing Medians The Joe Celko Way
21307: UDF that take a UDT as a parameter (CLR)
21308: Help with SQLServer2.Connect()
21309: Table reaching max value of identity very early
21310: Crosstab, Pivot?
21311: using variable as servername?
21312: conditional driven Stored Procedure
21313: Paging with ROW_NUMBER on filtered records (SQL SERVER 2005)
21314: encrypt a field in a table
21315: FOR XML AUTO, ELEMENTS Problem
21316: how do I test the cost of udf?
21317: trying unsuccessfully to produce OSQL error
21318: sql query similar to excel pivot table
21319: Question: How to pass ADS username from C# to trigger
21320: Delete with inner join
21321: current Date query
21322: Unable to debug Stored procedure with VS 2003
21323: Problem tuning procedures with temporary tables
21324: INSERT query
21325: Swap field values in UPDATE
21326: SQL Server 2000 Driver for JDBC SP3
21327: SubtractWorkingDays
21328: Number of page per table in the cache
21329: Select from a diffrent database in a Stored procedure.
21330: XP_CMDSHELL error
21331: From a browser insert or update data to a SQL Server 2005 table?
21332: My scheduled task failed!
21333: Split zipcode + city
21334: Working Days
21335: Retrieve PDF Image in Sql Server
21336: Error Message
21337: SQL 2000 Database Performance
21338: Best table structure for that?
21339: Slow data transformations from Oracle into SQL Server 2000
21340: How does a view work
21341: Feed Newline Character Into SQL Command?
21342: Create Table code by Sql Management Studio has error
21343: CONCAT Function
21344: Help - How to Evaluate for and Strip Duplicates?
21345: Change Query Table
21346: Getting latest status record
21347: Duplicate Database Table Names
21348: Best way to insert data into tables without primary keys
21349: Consolidating Rows into Columns
21350: Changing data