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