View Full Version : sql server answers


Pages : 1 2 3 4 5 6 7 8 [9] 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

  1. Database backup
  2. NULL values in a SELECT in another SELECT
  3. Quering data from database for the specific date period,SQL
  4. Sql Server Error
  5. Only Unique Data required of a table. Please help with this Query.
  6. Data Model for Searching large databases
  7. help me join same table
  8. Subquery returned more than 1 value
  9. Tricky insert query
  10. Need help with SQL Statement checking for nulls
  11. SQL error cannot connect
  12. Trouble obtaining database table values...
  13. new to this site.............
  14. Query Question
  15. Getting Unique values with GROUP BY
  16. Enable/Disable Job through another job
  17. Get data from last week of the previous months to the 2nd last week of current month
  18. Isnull
  19. Plssss Help needed in SP
  20. sql server 2005 transaction problem(sql server experts this question for you :))
  21. How to insert image into sql server 2000
  22. Collate
  23. MSSQL server 2000 ObjectType Trace Event Column
  24. SQLServer
  25. Insert columns from selected rows
  26. removing unused objects - SQL Server 2000 or 2005
  27. Timestamp Precision
  28. Bezu:-To calculate two column
  29. Access 2000 and SQL Server 2005
  30. importance of order in the ON statement
  31. Join these 2 views and make one stored procedure
  32. How to identify a user of concurrent users in centralized sql server database
  33. Reveres of TOP function?
  34. Stored Procedure to list out user access
  35. I need to know where mssql server stores its data.
  36. how to split a coloumn into 5 coloumn
  37. Sql Server 2005 Mdf File Blank
  38. permission issue connect sql server table from MS Access
  39. GOOD LINKs for studying advanced sql
  40. TempDB won't shrink
  41. Will Mysql clash with exchange 03
  42. conect MSSQL 2000 to visual studio 2005
  43. Integrity Check help
  44. How to get the username that invokes a SQL Job inside job
  45. INTERSECT in MSSQL 2000 on the same table
  46. Nested Query Help
  47. SQL Split and insert
  48. Design question regarding junction tables
  49. T-SQL Loop on selected query
  50. Variables in SQL-script SQL2005
  51. Pls HELP needed in DTS
  52. Merge two tables in one
  53. Cannot insert duplicate key
  54. SQL 2005 Activex conversion help
  55. difference
  56. Excel and MS SQL Server...Calculations for statistics
  57. Multiple Column Rankings
  58. interview questions
  59. sql mager
  60. SQL Sort Problem
  61. Script to Start Sychronization
  62. Adding 2nd Datafile Server 2000
  63. Listbox
  64. Selecting a filtered group result
  65. Add data for unknown name columns
  66. intersection data in MS SQL 2000 server
  67. Grouping with two Criterion and time point structure
  68. Crosstab Query
  69. Please reply
  70. Need SQL Function Brainwave
  71. data type
  72. functions
  73. duplicate checking
  74. SSIS packages
  75. A dimension playing off another dim
  76. Need Help Importing Data from Excel to My SQL Database
  77. Adding a column in query
  78. Biztalk vs SSIS as an ETL tool
  79. Security Issues when linking two databases
  80. how to generate date backward from end to start
  81. using a variable in the column_alias of a select
  82. import file
  83. Error 823: I/O error (bad page id) Attach recovered database file in the enterprise m
  84. How to connect Access to SQL Server (which engine?)
  85. A philosophical question about inserts
  86. Excluding certain rows from query
  87. correct row ID but not the text
  88. help me -CURSOR backward insert from End Date > to Start Date
  89. Could not find the path specified
  90. SQLServerException: The TDS prelogin response is incomplete.
  91. 16GB Ram 64-bit server, what configuration to use?
  92. T-SQL Sudoku Game
  93. SQL 2005: Transactional Replication > Executing sp on subscribershould execute on publisher
  94. Save a function as a function.
  95. Convert to Datetime
  96. sql server
  97. Select Case Where Like?
  98. Is ADO really dying?
  99. When a report was run
  100. SQL SERVER 2005 SP2 post upgrade issue
  101. SQL Help
  102. Maybe something very easy?
  103. data base in sqlexpress 2005 in .net 2005
  104. reports
  105. Datagridview
  106. Is any compression technology available in Database?
  107. Updating 1 table from another
  108. error when connecting to sql db
  109. Datagridview Issues
  110. Store Image To Mssql Server 2000 Table
  111. Datagridview
  112. Textbox
  113. Queries Log on SQL Server 2000 ???
  114. URL to download
  115. For XML Explicit Syntax to Normalize a table
  116. Output to text-file
  117. Decimal value
  118. Formatting Numeric Value in Computed Column
  119. Insert three columns from one table into one column in another
  120. check the word whether correct or not
  121. How to store a doc file as it is in a field?
  122. How to prevent duplicate successive inserts in a certain timeframe
  123. Running SQL from command line
  124. Import Data error
  125. how to make deployment of our project
  126. Create Delete Trigger on Table1 to Update a filed on Table2
  127. problem in Updating a column
  128. problem in update..
  129. Delete duplicate record
  130. Embedde Sql Server in VB 2005
  131. [Announce] DataDirect XML Converters 3.1 Released - HL7 Support
  132. using freetds tsql
  133. VBA Project password protected
  134. working with a local db copy
  135. Altering a function while it is being referenced
  136. Function to see if Table exists in sql server
  137. Conversion problem with SQL Server 2005???
  138. Create View ?
  139. Deploy windows based sql database application
  140. Sql
  141. Prblem in getting the rows affected values in sqlserver to C# class.
  142. Calculating Variable Date in TSQL
  143. Dropping an active connection on an attached database
  144. Error and output variables in stored procedures
  145. Inserting a file into sqlserver
  146. Stored Procedure fails to carry out delete.
  147. trigger to control table size in database
  148. A transport-level error has occurred
  149. Founding differences between the old and new database to update the old database
  150. Selecting SUM and COUNT, but not straightforward..
  151. Answer to avoiding Duplicates with an INSERT
  152. how to update DATE column (month only)in a table
  153. Add new Column problem
  154. DB2 Tutorial
  155. reading of .ldf files from sql server
  156. Opening .ldf Files
  157. Invoice
  158. Select Max values from queries for multiple Schedule_Number
  159. Migrating database from development server to hosted server
  160. Complicated question re: Saving a file from SQL server
  161. SQL 2k - xp_cmdshell
  162. Stored Procedure With Bulk Insert Not Working
  163. SQL Server Performance
  164. copy of a table
  165. SQL MSDE installation problem
  166. Token Replacement in SQL Server - any down side to turning it on?
  167. Reporting Services: Collapse / Expand for Table
  168. ? about users
  169. Sql query
  170. Form Post
  171. FOR XML EXPLICIT can't get element 4 going
  172. How to write output of a query to a file
  173. MSSQL Equivalent for SHOW CREATE TABLE
  174. Division Precision
  175. not all code paths return a value
  176. SQL Query - Help
  177. Listing available SQL Servers in a network/pc
  178. Crystal Reports
  179. Datediff help needed
  180. Search with multiple strings in single parameter
  181. information_schema.key_column_usage system table
  182. Nested SELECT FROM WHERE AS IN
  183. SET TRANSACTION ISOLATION LEVEL What is it all about?
  184. Response.redirect
  185. Invoice System
  186. SSIS Mapping Columns from Flat Files
  187. Multiple joins in SQL Server
  188. Run a Query that will bring back a report on "bad data"
  189. Complex query (compare records in same table / join a 2nd table)
  190. Error handling in stored procedure AND checking
  191. Active/Active cluster on 2005 - can I oversubscribe RAM now?
  192. help!!
  193. Change _ to a +
  194. Replacing repeating blanks with a single blank
  195. Prompt for User Input
  196. Date problem
  197. Calculations in a query
  198. run SQL stored procedure from Excel
  199. Converting Informix OUTER statement to SQL Server
  200. "Merging" results from two queries
  201. Pass through query from MS Access
  202. Delete
  203. Bulk Insert
  204. reading as array
  205. Position of Table Columns
  206. Help With INNER JOINS
  207. Difference between sql server 200 and 2005
  208. M I.5'Perse cution ' Capita l Radio - Chris Tar rant
  209. Data Manipulation
  210. Alter Table AND Update Table with Variable MS SQL
  211. sql server alert
  212. database optimization
  213. Globar Variable in DTS:: Urgent
  214. backup advise
  215. Copy DataBase
  216. Find Columns
  217. sorry
  218. Instance name vs servername
  219. list of users and authorizations sql statement
  220. Sql Endpoint creation and consumption on inter domain network
  221. how to get data from SQL server 2005?
  222. Query Update - subquery?
  223. sqlserver query
  224. Using SUM in Query to total hours based on Months.
  225. Extracting Duplicates from SQL Server 2000
  226. Convert SSIS Package into C#
  227. learner a ms sql
  228. Query - Select two tables where a.id=b.id
  229. web access of sql tables
  230. Problem with select criteria with conditions
  231. SQL Datatype
  232. To Pass Parameter
  233. extended procedure
  234. counting distinct posts by a users within the past 10 days - SQL2005
  235. DTS from SQL2000 to MS Access
  236. Multiple table data retrieval into separate table
  237. Format Number on Select
  238. Clearing temp tables
  239. Database manpulation without connecting to a server...
  240. just to do a select
  241. to introduce exist in sql script
  242. SQL 2005 INSERT statement inserts two rows
  243. sql server 7
  244. Primary key violation
  245. select numeric value from varchar data type + sql server
  246. Trigger on Insert made a strage information,
  247. Database Tripled In Size!!
  248. Indexes
  249. SQL 2005 XMLBulkLoad field length
  250. Advice for grouping stored procedures?
  251. Connect to remote MYSQL From the local mssql
  252. MSSQL2000 DTS error "Too Many Fields Defined"
  253. Convert MS Access Pivot Query to SQL Server 2005
  254. Question on MSSQL 2005 database import
  255. Problem with using an a subquery in an update
  256. SQL2005: Running TSQL commands in single-user mode
  257. Loose ODBC conection
  258. sql stored procedure parameter problem
  259. probleum in changing the data type of column
  260. abt Stored Procedure ...
  261. Row into Columns
  262. Added users to a logged shipped database
  263. Need help with a query
  264. How do I calculate minutes worked by 15 intervals?
  265. RECOMPILE / REFRESH UDFs?
  266. Time Dimension Design Question
  267. Restoring database hangs SQL Server 2005
  268. Help needed in this DATEDIFF SQL Query
  269. URGENT! Never ending loop
  270. Insatalle the Sql 2000 Sever to Win xp 2000 machine
  271. Sql Server Agent Service Account
  272. How to delete a table with about 2000 rows
  273. How to connect to a server (sql server 2005
  274. fractional truncation message
  275. Select Just Primary Keys from db?
  276. Please HELP
  277. find records which are in between 2 dates....
  278. Which is better(in terms of both memory & time): join or subquery
  279. doubt in using serveral datasets?
  280. Sqlserver2005: How to get the error message thrown from Storedproc to C#
  281. What is the sequence of execution of an SQL select query in SQL Server
  282. Key column information is insufficient or incorrect. Too many rows were affected by u
  283. Is there a tool for verifying data after merged access to mssqlserver
  284. Index problem...
  285. Problem with Sum.... Noobish.
  286. Setting Up A Remote SQL 2000 Connection
  287. Data Mart
  288. Wrong Greek characters on Windows 2000
  289. i want to use remote mssql server database
  290. Difference between MS SQL 2000 and MS SQL 2005
  291. Differences between MS SQL 2000 and MS SQL 2005
  292. Update Column with Type datetime
  293. sys.objects WHERE type
  294. Table Rows Into Columns
  295. Table Creation Date
  296. merging a date only column and time column into SQL from CSV
  297. Moving data from one table to another
  298. SQL query help
  299. Foreign Keys Either/Or Design
  300. Stored procedure date question
  301. Compex SQL Query containing UNION, Needs Filtering
  302. how we change one data type into another in sql
  303. DateTime format
  304. Relational Algebra & SQL newbie needs help!
  305. Step SQL Server Integration Services Package Error in SQL ServerAgent
  306. Problem with MSSQL? .NET application? or Win Server?
  307. export db tables for use locally on another pc
  308. The product level is insufficient for component "Data Conversion 1" (117)
  309. truncating data older than 30 days
  310. Update multiple columns
  311. Stored Procedures: Returning values
  312. SQL Express connection via VPN
  313. SQL login and user creation
  314. Complex SQL Query
  315. SQL Server
  316. SQL Server does not allow remote connections.
  317. Column size in emails generated using XP sendmail
  318. How to use value of a variable in defining data type
  319. Using select results for a new select
  320. New to SQL and need a query creating help cant figure out how to complete this
  321. how to throw out a 'group' of values based on different rows
  322. Help with SQL Sever Mobile foreign keys
  323. Problem In This Code
  324. DTS Package Transfer Help
  325. SQL Server 2005: How to turn multiple rows into a single column
  326. Replace Query
  327. bad bind variable trigger
  328. Ident authentication over local sockets
  329. Transfer/move data from one server to another
  330. Yellowfin Business Intelligence Version 3.3 release
  331. Entreprise Manager error message: "[Microsoft][ODBC SQL ServerDriver][SQL Server]Login failed for user '#####'. The user is not associatedwith a trusted SQL Server connection.(28000,18452)"
  332. Need help generating a Query
  333. deadlock and high cpu - chicken or the egg
  334. Query Help
  335. Remove a $ from data field
  336. Find all chars in table that are ASCII code 128 and Greater
  337. Update Query--help
  338. Help with SQL 2005 performance problems.
  339. Help With Script: CSV Import, SQL 2005
  340. sqlserver book
  341. Query Performance
  342. Service Name
  343. what is library path
  344. difference between pause & stop sql server
  345. data transfer from sql server to oracle
  346. begin and end transaction and transaction log
  347. left outer join/inner join statement
  348. Warning - Cannot retrieve...
  349. SQL Constraints Problem
  350. Do I need a Totals Column, if related table holds the individual amounts
  351. SQL Server writers, we need you!
  352. Best disk config for SQL 2005
  353. Database/Table Design Question - Object/Event Model
  354. Generating BCP input file from Perl/Unix
  355. how to send sms through notification services
  356. database new line problem
  357. Importing from Excel problems
  358. running a vbs file as a step of an SqlServer job
  359. How to write loop in Sql server 2005
  360. Substring after character /
  361. DTS-Package sends mail and files before the job finishes
  362. Import a notpad file into Sql server 2000
  363. Duplicate records - SQL Below
  364. Help with this query, please
  365. help with setting up a reminder
  366. Number grouped rows....please help!!
  367. SQL Server Agent has no Access to Path
  368. What is the use of Resource and Distribution System Database
  369. Lookup Function in SQL
  370. How to Attach Database to an Instance
  371. stored procedure to avoid data redundancy
  372. SQL Server BI - metadata
  373. SSIS Package Log File Configuration
  374. join with table on another database not working
  375. SQLDMO.Bulkcopy diagnostics on failed load
  376. performance test issue
  377. sql server 2005 180 day trial version installation failed
  378. Database design
  379. cnnecting an sqlserver instance to a site
  380. Stored Procedure compilation question: Doing disparate things in aproc
  381. insert column in union select statement
  382. Create Trigger within T-SQL statement
  383. Need SQL Script
  384. SQL Server compatibility with SharePoint workflows
  385. question regarding slow performance an PAGEIOLATCH_SH locks on sql2005
  386. MSDN Search made easy
  387. Managed Code in SQL advantage confusion (C#)
  388. How can I list the students in the CIS department? (SQL Server Query)
  389. varbinary to varchar
  390. Several Counts and grouping the results...
  391. Once a week or once a month
  392. Check constraints on clustered columns
  393. EMAIL from SQL express
  394. Newb: Managing multiple queries
  395. what is the diff b/w sqlserver 2000 enterprize editon and sqlserver2000 personal edit
  396. Row numbers
  397. To see spcific records
  398. Joining Tables
  399. Regarding Type4 driver Connection..........
  400. help me plz.
  401. Can i use Top keyword in SQL Server 2003?
  402. Comma delimited
  403. Query using schema to determine if Trigger exists
  404. SQL Statement: Needing some code
  405. Storing image to table
  406. SQL command to show only databases that contain a particular table
  407. Launch DTSRun with a stored proc
  408. Connection problem to Informix from SQL Server 2005 with Unicode data
  409. Copying data
  410. Global variables in SQL - ORACLE DTS Package
  411. Script works in DTS, but has problems as a Stored Procedure
  412. Please help with this SQL statement
  413. how to pass Average value of a parameter to another parameter in SQL
  414. Insert Trigger?
  415. Add a datestamp to an existing table
  416. What is the purpose of the ROWGUIDCOL property?
  417. Can anyone help with waittype 0x0044?
  418. Learning sql server 2003
  419. Trigger which updates the other Rows
  420. How to fetch data from other data base
  421. Insert query firing Insert & Update trigger at the same time
  422. multi column sub select equivalent for sql server 2005
  423. Detecting the conflict time and date 2
  424. how to protect db while working in ms sql
  425. Capturing data inside double quotes text
  426. Uploading Tiff Files into SQL Serevr 2005 Database
  427. Using updatable views when moving tables from one DB to another?
  428. Scheme login can't access tables owned by scheme
  429. Count problems
  430. Find out owner of database for SQL 2000 and 2005 databases
  431. give me the sql statement
  432. give me the sql statement
  433. problem in comparing date
  434. Passing multiple values to stored procedures
  435. QUOTED_IDENTIFIER & ANSI_NULLS
  436. sp_MSforeachtable Usage in xp_cmdshell, Know this!
  437. math notation in db?
  438. strip numeric portion of a string
  439. Problem with Script task in SSIS along with WSDL file to call a web service
  440. Sq server 2005 : Table Update when date field value cross current date
  441. bcp utility
  442. Query rows of an entry into columns
  443. SQL server certification
  444. SSIS is pathetic with ODBC connections ...
  445. Problem counting records
  446. load balancing cluster
  447. Windows 2003 SP1 won't let me set the lock pages in memoryoption...it says I need Sp2.
  448. stored procedure that retrieves next unused value
  449. Populating List/combo and text boxes from a MySQL databases
  450. I need samples of how to simplify Access's graphically nested Joins!
  451. Translate from OPEN FOR USING and FOR LOOP from Oracle to SQL SERVER
  452. How to Audit SQL Queries not generated from a Specific Application
  453. Using case statement or if logic
  454. Trigger to update table.
  455. SELECT then DELETE versus extra clause in SELECT
  456. Import From excel
  457. Max limitation of image datatype in sybase
  458. sql server database backup
  459. Get table row size
  460. Getting System Time From SQL Server
  461. Function that replaces ntext and compares ntext with nvarchar
  462. Connecting to Double Byte Progress (MFG-PRO) databases from SSIS...
  463. Select distinct rows from duplicate rows....
  464. Spatial Data and MS SQL SERVER
  465. What the difference is between CREATE PROC and CREATE PROCEDURE?
  466. Stored procedure for DropdownList
  467. How do you find the Existing Per Seat License info
  468. Data insertion too too slow...
  469. Clustering, Security, Performance, Load Balance
  470. SQL Server moving to larger drive
  471. Help with pivot table
  472. Selective blocking of Inserts and Updates
  473. Off Topic - Databindings and XML - Binding Text between XML Tagsinstead of XML Tag Atrribute Information
  474. sql query way tiring for sync()
  475. Importing data into SQL Server 2005 via ODBC
  476. Direct access to SQL Server 2005 from Windows Mobile
  477. SQL Server and TCP Fragments
  478. Need help on my query(sql statement)...
  479. many "or" operation make system choose incorrect index
  480. export from sql to excel
  481. Trigger doesnt get fired everytime
  482. Local DB Affected By VPN
  483. relation schema SQL Server 2005
  484. Ms Sql Stored Procedure
  485. SQL Joins
  486. SQL server
  487. Update query from another table on datechanged field
  488. TRUNCATE TABLE @table_name
  489. How to work in SLQ Server 2005
  490. The multi-part identifier "ticket.ticketid" could not be bound.
  491. Select help
  492. Library Database
  493. "select statement cannot compare one data with multiple data"
  494. Making a table to store photos
  495. Appropriate Query Optimization Technique(s) Sought for the FollowingCase
  496. ASP Vs Query Analyzer Different Results
  497. SQL Server 2005 : Insufficient memory to continue the execution
  498. SQL Server 2005 article
  499. About join
  500. how to Calcullate Two Dates
  501. Sql Questions
  502. SELECT INTO Another Database Problem
  503. Running a DLL in the Query Analyzer
  504. SQL query for calculating the cost price of invoiced items
  505. How do UPdate a last row in the database
  506. Concat instead of SUM when grouping results
  507. IS NULL being ignored
  508. need help
  509. error enabling AWE to access >2GB of memory
  510. foreign keys - on which kind of keys do the base on?
  511. Microsoft SQL 2005 Server Express Edition Install Error
  512. Totalling 2 columns in a table by multiplying
  513. Upsize from mdb to SQL Express 2005
  514. using modify table command
  515. SQL Server Express 2005 @@SPID
  516. Sort by the values in an IN()?
  517. importing a CSV file
  518. append date to exporting file name in SQL reporting service
  519. sqlcmd and escape characters
  520. Find Current Date Time Span SQL
  521. Multi Value Parameters
  522. Launch storedquery for each record
  523. Diary Schedule Insert
  524. data type for 32-bit
  525. Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied
  526. UPDATE from Sub-select problem
  527. linking to client server
  528. Convert cursor to set-based sql statement - HELP
  529. Variable in UPDATE query
  530. Self join one table
  531. FOREACH LOOP container and looping through record set ...
  532. Saving changes
  533. Integration Services
  534. help needed with extracting XML data
  535. Storing Calculated Fields
  536. Any way to find user who did update in SQL SERVER?
  537. Finding the user who do update in Query Analyser?
  538. MS Sql Error converting data type varchar to numeric.
  539. MS SQL for returning no values
  540. Problem On Font....
  541. need urgent help
  542. Problem Changing Data Directory in Server 2005
  543. Problem with reporting and queries
  544. How to replicate database for Dev purposes...
  545. pass parameter to If Exist statemetn
  546. Backup Files
  547. How to pass user defined variable to Select statement
  548. Can I combine Log Shipping and Clustering?
  549. ISNULL for a date to char conversion
  550. SQL 8.x: Exporting Data into Excel