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