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. sql query with sum and max in two tables
  2. How can I get 2 rows as first reply when databse has more rows with same keywords?
  3. Backup
  4. Finding occurence of value in a given string
  5. Getting Total average
  6. Sum() function wont work because of group by, what to do?
  7. SQL SUM HAVING Problem
  8. Sql error 40 on client machine
  9. Conditions on outer joins
  10. How to find records that are present in one table not in another in sql server
  11. How to Query SQL Select with 2 table
  12. Joining to different tables based on a condition
  13. SQL Armenian
  14. Visual Studio Reporting Services - MultiValue Parameters
  15. Login failed while synchronizing via merge replication
  16. MS Access Validaiton rule in SQL Server
  17. UPDATE makes cells NULL
  18. Connect SQL server (64-bit) to Sybase SQL Anywhere 5.0
  19. sp_linkedservers did not help in linking server
  20. how we can display two columns according to the same rows in each column rowwise
  21. Select query execute very slow
  22. which database perform updation faster sqlserver or Ms access
  23. Joining tables in different databases instance and SQL servers
  24. SQL Starting issue
  25. need help with CASE function
  26. In Crystal, what does COUNT ({table.column1},{table.column1}) do? & SQL equivalent?
  27. Copy table from one SQL database to another SQL database
  28. @@ROWCOUNT always 0 :(
  29. append query
  30. Validating records in a table
  31. Validating records in a table
  32. Update a thousand rows with specific value
  33. is this update query works
  34. A CASE statement using another CASE statement as it's expression
  35. Why would SELECT returned record sequence change? SQL Server 2005
  36. How to go to the previous record with non consecutive ID numbers
  37. Go to previous record in sql query
  38. Date/Time Problem with SQL
  39. NULL In IN clause
  40. how to solve the following
  41. Sql server
  42. how to convert 2 rows into one column
  43. when I insert table, value is a string contains apostrophe - it throws an error there
  44. porblem of string
  45. Can I do this in a trigger?
  46. DTS package query
  47. Update using a join in the where clause
  48. Database import fails and prints "insert table failed for eventLog" - what issue?
  49. i need to start row number as 100
  50. i want to send sms from SQL SERVER 2000 or 2005
  51. SQL Server Express 2008 Off Domain Authentication
  52. Why is SQL Server faster than Access?
  53. Retriving 10 records per page through stored procedure
  54. Create username and password for my SQL Server 2005 database
  55. Update statement for whole table
  56. Unusual ordering of values in SQL
  57. Concatinate user defined variable with select statement
  58. pick the values separately from a column field
  59. combine data from different databases
  60. The request failed or service did not respond in timely fashion
  61. Sql Express installed using Package deployment does not provide change 'sa' password
  62. Linked tables in SQL Sever-ODBC connection
  63. Get sql row count
  64. Sql Server Error
  65. Divide a single column data to put into different rows.
  66. SQL SERVER 2000 T-SQL Problem
  67. Select Columns using nested select statement.
  68. WHERE question
  69. Copy &Inserting the dataStructure from one table to other table?
  70. login problem
  71. Inserting into multiple related tables using table valued parameters.
  72. Many to many relationship problem
  73. What other database can i use besides Microsoft SQL Server?
  74. MSSQL ID generation
  75. SQL NULL value logic
  76. connect web with a data base
  77. how to work with macrons and ms sql 2000/2005
  78. Subqueries are not allowed in this context. Only scalar expressions are allowed.
  79. HOW could i DO PIVOTING in SQL SERVER 2000
  80. Get the id of the next closest location
  81. Parametrized ADO Stored Procedure from C++
  82. HOW COUld i use POVIT ing sql server 2000
  83. recursive logic with sql server
  84. H0W Could i Get Next Day Date Of the Day Function in the Sql server 2000.
  85. Sorting
  86. moving sql servers to a new ou
  87. Query On DTS package
  88. DTS - import from excel ended with more records
  89. Select Between 17:00 Yesterday and 17:00 Today
  90. how to select the colums value as Column header?
  91. SQL 2005 and Ad Hoc queries not taking advantage of parallel processing.
  92. How to add data from two coloumns
  93. SQL Server 2005 Dev Edition : Data Flow Task error
  94. Interfacing to sql
  95. Issue of Full text search -- ContainsTable
  96. Selecting a specific value from an audit log
  97. General Network Error while running an ERP application on SQL Server 2000
  98. using currency in a stored procedure
  99. get last 3 most recent results based on a column
  100. Database (cache) memory allocation
  101. Help need in performance tuning
  102. MS SQL filter list of records
  103. how to display nth record from table
  104. How can I uninstall SQL Server 2005
  105. Dynamically Pivoting Rows to Columns in SQL Server 2008
  106. order by for 3 columns
  107. db design and performance for bulk insert
  108. Give a range in a query
  109. Doing a query through php to sql server 2005 and get query timeout
  110. what is meant by meta data in sql server??
  111. How to identify the ID of row which has been modified?
  112. How to deal with html source in SSIS packages..?
  113. join multiple tables
  114. connecting multiple table
  115. Question about differential restores (SQL Server 2005)
  116. Trying to update certain rows and its not producing the results i need
  117. How to add an identity column to a table with existing data
  118. how to insert the value of a function in the coloum
  119. How to convert row data into columns
  120. how can i update my table with the elapasedsecond as a new coloumn
  121. SQL Express Management Tools and Standard Edition Tools
  122. Selecting MAX date from a group of records
  123. Trigger in a certain period of time of day
  124. is there anysql equivalent to inner join ins on ins.address like '%a%'
  125. What is the Query?
  126. what are break points in sql server?
  127. Getting a proper Count for a month
  128. Why would I use a different table owner other than dbo
  129. SUBSTRING in where clause
  130. is there a chance of mixing up of data in secondary file?
  131. Writing a cursor with do while loop
  132. top 5 on the basis of a zone
  133. Date Peak
  134. Reducing Data type Lenght
  135. Problems with crystal after sql server protocol encryption
  136. Is it possible for sort select query based on input string?
  137. Export datas to a Excel file using query without openrowset method
  138. How to query another server with stored procedure
  139. Query across Multiple Tables MAX()
  140. Month to month yearly results - hard and slow help...
  141. SQL Query aggregate phone numbers
  142. query for relation between 2 fields
  143. The INSERT statement conflicted with the FOREIGN KEY constraint
  144. How to convert rows into different columns
  145. how i convert dbf file int sql file
  146. Can I calculate between different datasets?
  147. Query Engine Error after Forced Protocol Encryption on Crystal Report
  148. How to query untyped xml data
  149. TSQL query
  150. role permission of tempdb due to server restart
  151. Want to track the user who last modified the procedure
  152. How can i convert this query into sql server whereas this is working in MS ACCESS
  153. Insert table values from other table
  154. sql query
  155. Return all items in an order then add the shipping cost to only one item
  156. Raise Error problem when connecting to SQL Server through ODBC
  157. UPDATE and SELECT Combination
  158. openrowset works in sql 2005 but not Works in SQL 2000
  159. Use Excel modified date in Stored Procedure
  160. Using a pointer to a local varaiable in Dynamic SQL
  161. Unable to join 2 tables which are in 2 differenet servers
  162. trick for displaying result? SQL Server 2005
  163. Open SQL connection using T-SQL
  164. I'm trying to run a package in integration services
  165. SQL Server, how to the next value of identity(1,1) before insert
  166. How to publish Stored Procedures into a database
  167. sql query groups and min value
  168. How to split long string function in sql server?
  169. Easiest way to convert Microsoft Access SQL code to T-SQL code in SQL Server
  170. problem in query
  171. How to find the System Date Format?
  172. How to check if a value (null/non null) exists in database table using stored pro
  173. Job disappeared from Enterprise Manager
  174. Error : Calling SSIS package from .Net
  175. What values can a datetime data type hold other than date and time??
  176. RTF file in SQL Server 2005
  177. Automated Data Import from Excel
  178. I want to query of getting hour from date field
  179. Report Maker
  180. SQL server
  181. fit record in one page in SSRS
  182. Sql Compact Installation
  183. Sql update command question
  184. passing db table values from one sql server instance to another sql server instance
  185. Selecting seperate fields from file - each based on different criteria
  186. DTS Task not running... wierd...
  187. Connectoon timeout
  188. Query Data and Column Names
  189. Using aggregate fucntion to calculate standard deviation
  190. identity column (int) overflow
  191. SQL server 2000 - cannot telnet to port 1433
  192. Using extended properties on the DB objects. What is it?
  193. Problem in creating stored procedure.
  194. Using Joins
  195. Join or Transpose?
  196. How good to use Partition table?
  197. Database switching to read_only mode randomly
  198. How can I restore a database remotely from a different server?
  199. Adding leading zero's (padding out)
  200. sqlce in Xenocode
  201. Can you make a new table from query results in tsql?
  202. design a single normalised table
  203. How do I delete duplicates in a row?
  204. Table with various subfleets
  205. Multi-part identifier error
  206. Error converting data type varchar to numeric
  207. Need a script to backup db on one server and restore that db to another server
  208. How to tune this SQL
  209. Why does MSSQL server allow the attached code to work
  210. Converting String To Decimal
  211. removing duplicate records
  212. Problem with NULL values
  213. Stored procedure problem
  214. Australian Postcode with longitude/latitude
  215. SSIS import full text from html or combine rows
  216. Synchronization
  217. Query
  218. having trouble with joins
  219. how to use replace and substring correctly.
  220. Split a string where newline, carriage return
  221. Select with conditions
  222. replacing the 8th character in a varchar string
  223. insert rows dynamically
  224. Transferring data
  225. Help in Insert into select from SQL
  226. How to select top 1 from table1 where table2 contains a list of values to select on
  227. Violation of Unique Key contraint during update
  228. how to call Function
  229. How to convert a char value to date?
  230. Get employee with least work
  231. Taking Automatic Backup Of sql server database
  232. Dynamics column in SSRS 2005
  233. Embed a Google Map in SSRS
  234. SQL Server Import and Export Wizard steps
  235. Substring in SQL server
  236. Conditionals in a WHERE clause?
  237. Combining Multiple Projects
  238. Retrieve date now
  239. SQL Server 2008 SP1 not for XP?
  240. which sql download from net
  241. SQL Server Compact timed out waiting for a lock
  242. Quick question
  243. SQL query
  244. Report Builder 2.0
  245. How to use where wiht variable
  246. I am new to Sql and looking for some help with this error. Any advice would be apreci
  247. Select DISTINCT (This part of the query only)
  248. I have deleted the .MDF file accidently. I have never created a backup early on.
  249. Multiple results from a Case statement in a Where clause
  250. merging rows for the same time stamp
  251. Where is error-I need exec in function - result is without error,but not return data
  252. Conditional Having Statement
  253. ISNULL With date..
  254. Condition check for If table exist
  255. converting access 2007 update query to sql server 2005 update query
  256. Insert and Select statements for same table in begin trans and end trans
  257. Extracting documents from SQL database
  258. Help converting .xml feed to SQL
  259. sql create tables
  260. Quick questions About SQL Server 2000
  261. Best way to index a mostly static database
  262. How Access reads data stored in SQL Server
  263. How to run a scheduled AutoExec Macro that requires an ODBC password
  264. select addresses with distinct email address
  265. Can any of you SQL Guys help us olde Access boys out with this Thread?
  266. The LIMITations of ms-sql. Equivalent to MySql's LIMIT
  267. How to join update statement with select?
  268. How to decide optimum type
  269. Count group by query
  270. Multiple select
  271. Problem with MID() function
  272. Working with Multiple CASE WHEN Comments
  273. Find empty fields
  274. Bulk Load Copy - nvarchar is not recognized
  275. Trouble converting Access query to SQL Server
  276. Need guidelines - Query Optimization
  277. How can I detect changes in a row of some table?
  278. two questions: 1) Joins 2) Selects
  279. error "Could not open a connection to SQL Server"
  280. MSSQL "A network-related or instance-specific error" and IIS application pool
  281. Create Function
  282. problem with installing mssql - dot net framework
  283. Attempting to do an update in SQL Server 2005 with query originally created in Access
  284. running web application in MSSQL on server with MySQL; 4CRM SQL & EMS MSSQL Manager L
  285. converting queries from access 07 to sql server 05
  286. Multi-table JOIN issue
  287. How to insert Unicode data into table when pulling data from another table
  288. how to divide one column to two columns
  289. Create Function
  290. using union, temp columns, in a SQL based search string
  291. How i know if a report has Data in Reporting Services 2005?
  292. Am i able to insert into a table data from a temp table?
  293. Can I use LIKE with IN?
  294. How to update one sql table from another table
  295. Converting Text to Decimal
  296. If exists table using dynamic sql
  297. Need help urgently, have to compare dates between 2 rows in one table
  298. retrieve a last value from sql
  299. Use sub reports in the header of a report in SSRS
  300. Cannot specify an index or locking hint for a remote data source
  301. How do you change the default encoding on SQL server?
  302. SQL Query
  303. Transpose into fixed column
  304. Transpose into fixed column
  305. Multiple SQL servers in same query
  306. Cannot Reindex.
  307. Computed Binary Field
  308. Using parametrized "IN"
  309. question about cursor
  310. Nth location of string
  311. Remote server Problem in Sql server 2005
  312. Configuring Error Messages in SSRS
  313. make one table from merging two
  314. Dynamic SQL in an INSTEAD OF trigger causes recursion
  315. Dynamic user security in Reporting Services
  316. Questions about Foreign Keys
  317. substitute for 'PRINT' in server
  318. Combining Rows into 1 Column, and joined with another table
  319. scope_identity not working
  320. Filename Increments
  321. The INSERT statement conflicted with the FOREIGN KEY constraint
  322. sql AS function not working
  323. sql deletion with delimiters
  324. sql statement writing
  325. How to build a query based on four tables
  326. Concatenating Row Values into 1 Record/String
  327. Parameter query problem
  328. SELECT yesterdays records
  329. Issue when reading data from excel sheet
  330. Using an alises in the WHERE clause
  331. problem with writing arabic into database from out
  332. Current day
  333. retrieve n number of rows from table
  334. insert into - add multiple values in a column
  335. How do i phrase this simple query
  336. How to handle high-volume inserts?
  337. Multiple Functions
  338. Complicated Query by date
  339. no access to new instance of sql server
  340. Importing .txt to SQL 2000
  341. calling a pl sql procedure in Reporting Services
  342. SQL Query - Eliminating Duplicates
  343. Scheduled DTS Problem
  344. Distinct Count - SSAS
  345. SQL Server 2000 XML Element Order
  346. SSAS 2005 help
  347. Syntax error converting datetime fom character string
  348. Autonumber not updating fast enough
  349. Connecting through .adp file (not working on Vista/SQL Server 2008)
  350. How to compate two versions of the same database
  351. Set based solution instead of Cursor
  352. Find Credit Card numbers in text field
  353. Question using SP_ADDLINKEDSERVER
  354. Query with Counts Help...
  355. Select every 79th record
  356. Database Locking
  357. Return records 5 thru 10
  358. remove duplicated fields depending on time
  359. Inserting concatenated data with while construct
  360. Extract Numeric Data from text field
  361. Trying to get a case statement to work correctly
  362. Connect to DB2 server from SQL Server 2005
  363. Sql insert cursor
  364. Display flag if record exists in table
  365. Quary Confusion
  366. While loop with dynamic sql
  367. Linking from Access
  368. sql server compact edition 3.5
  369. Database normalization question
  370. Search a row by Primary Key
  371. generate & compare id from table in sql storeprocedure
  372. get tables
  373. Views in SQL server
  374. list of countries and their states
  375. How to Create an XML in MS SQL Server 2000
  376. Two instances on one machine
  377. need your help please
  378. SQL Error: Cannot resolve the collation conflict between "SQL_Latin1_General_
  379. Using SET statement in stored proc.
  380. Calling a UserDefined Function
  381. MSSQL Datetime snafu
  382. General Network Error- works if exe name is changed
  383. Using Single Quotes in a dynamic SQL
  384. Best way to send email from SQL
  385. simple question about date compare
  386. Move MDF From 2005 Back To 2000
  387. Trigger Before Insert or Update
  388. Problem inserting ' and ; in DB
  389. Problem with nestd query
  390. Need help with join - it's returning duplicate rows
  391. How can we generate a Script with all user permissions of all users in a particular d
  392. determining if an SQL database exists, etc.
  393. When to use trigger, constraint and when one cant
  394. SQL Query
  395. Help with Query To combine results from two Columns
  396. Problem with query
  397. problem in Updating database in windows application
  398. SP that updates a table according to optional parameters?
  399. problem with joins and aggregate functions
  400. Exporting data with Stored Procedures
  401. where's the dgDetails class?
  402. Stored Procedure Error
  403. proper Save location for SQL stored procedures
  404. one-to-many relationships
  405. Getting a count on one table using data from another table.
  406. how to “store” stored procedures
  407. Getting the count from two tables as rows not columns.
  408. SQL Query becomes too much
  409. learning sql server
  410. Pivots
  411. dataAdapter.Update / SQL PasswordHash NULL problem
  412. PasswordHash NULL problem
  413. query to store null
  414. How do I get PasswordHash value?
  415. displaying an auto-incremented identity column
  416. GetDate() with time-ignore
  417. Multi Table Query With Max Per Grouping
  418. datatype smalldatetime now requrement is there to store nil
  419. SQL / Access (Average Code)
  420. Only One Record
  421. why deadlock in this SPROC
  422. mapping error
  423. SQL Server Users and Roles
  424. System DB not able to restore
  425. auto-increment identity column
  426. How can I make SQLServer known to DB2 control center so that I can Federate?
  427. Need help with a query - may be easy for you but not me
  428. INSERT IGNORE duplicates
  429. Is a solution possible/viable?
  430. dataAdapter.Update problem
  431. Last Sales Price
  432. DataBase Size/space Query
  433. sql parmeter problem
  434. mssql
  435. SQL Server 2005 - Open SQL file with Query Analyzer behavior
  436. Loop through all databases
  437. Sql server 2005
  438. sql network
  439. collating records from different SQL Server tables
  440. Recursive stored procedure
  441. SQL Server connection problem
  442. How to uninstall AdventureWorks sample databases?
  443. ELSE IF statements
  444. ELSE IF statements
  445. database security
  446. Help me with SQL
  447. How to import ".mdb" files into SQL Server 2008?
  448. Can SQL Server 2008 access Northwind or Pubs databases?
  449. Access add record command button not working with SQL backend
  450. Optional Parameter in a SQL Function -- selecting all
  451. binary data in char field
  452. What will happen in such case to the table
  453. Calculating the Weekend Days(Saturaday,Sunday)
  454. AdventureWorks mayhem
  455. server database
  456. SSRS report parameters are not wroking properly
  457. PHP SQL Server 2005 suddenly down
  458. how to make SQL commands more dynamic?
  459. Problem with SQL query newbie
  460. Pub sample database
  461. Default file group
  462. set password
  463. Data Manipulation
  464. select statement
  465. Two or more select statements in a single query
  466. I can’t install SQL Server 2008 Express with Advanced Services - Help!
  467. SQL Query with some problems
  468. createing database problem
  469. how to obtain SQL Server FullText Search service?
  470. SQL2008.AdventureWorks install problem
  471. Any other SQL or MS Access / OleDb databases available?
  472. COUNT Duplicates using partial string
  473. dataset
  474. parent row
  475. LIKE Condition while using parameters
  476. Creating Custom data sets in reporting services
  477. How do I create custom Datasets in SSRS?
  478. Normalization
  479. How to solve memory leak in SQL 2000
  480. Find remaining balance - not a simple SUM()
  481. Custom WordBreaker for SQL Server Full-text
  482. Curser in SQL(for coonectiong to deifferent servers)
  483. Very weird bug with 'like' function
  484. Sql query to select Date between the range
  485. Error occured in execution of Procedure
  486. Recover SQL 2000 database restored over in error without backup
  487. Copy table to table, how?
  488. Covert Data in .DBF files to MS Sql
  489. Searching between 2 DateTime Values using SELECT stmt in Vb.Net
  490. conversion from varchar
  491. No error Description
  492. Condition as part of FROM statement???
  493. Subtracting sequentially from multiple sources
  494. Cursors
  495. local html webform page to local sql 2005 database possible?
  496. Intelectual property protection
  497. Getting unmapped records with mapping table query
  498. Subtracting from lowest value
  499. pivot
  500. Duplicate Entries
  501. How toRetrive XMLdata into database Table
  502. How to copy column(s) from one excel sheet to another using sql server.
  503. Sql server 2005 Installation problem
  504. Fixed Width File Spec for SQL Server
  505. per seat , per server , per processor
  506. columns operation
  507. sql connection
  508. saving userlogon time
  509. Can somebody please kill my cursor
  510. Update rows in
  511. How to eliminate selecting repeats in a statement
  512. Does SQL Server 2000 support foreign key in partitioning?
  513. how to create backup in sql 6.0 using sql command
  514. How to handle NULL parameters,EMPTY parameters and ERROR HANDLING in stored procedure
  515. creating a table
  516. How to migrate mysql stored procedures to sql server manually?
  517. Single stored procedure for multiple databases?
  518. Registration Form
  519. HELP ME Understanding the concept of Foreign
  520. Sql server date question {C#}
  521. Variable locking up query ??
  522. insert new columes
  523. Migrating DTS Packages from SQL server 2000 to SQL server 2005
  524. problems when trying to use the import wizard on mssql2005
  525. Regarding stored procedure help me
  526. Look at every *Third Tuesday* of the month on record ...?
  527. query that filters out those schoolcode
  528. Single table condition in join or where
  529. SQL query related to Date.
  530. Single Trigger for "SELECT" execution happens irrespective of any table.
  531. Data Conversion in ssis
  532. using a trigger to get values from one table into another
  533. Restore Database error in SqlServer
  534. trigger error
  535. Constraint on existing table, multiple columns
  536. How to recover database from MDF?
  537. BULK INSERT row terminator issue
  538. Convert mssql to mysql
  539. SQL server does not exits....
  540. how to put the sql-logfiles online?
  541. how to find whether particular value is present in database
  542. Need Help - Multiple Column in Group By clause with Data Type Error
  543. query to search even when user skips in between text
  544. CASE statement in subquery
  545. Multiple SUMS SQL Query
  546. Select/Insert/Update a column with out a header
  547. SQL Stored Procedure Insert List of variables
  548. speed uo to read rset from SQL Express
  549. executing block of code whenever a condition is satisfied
  550. fetch multiple columns value in stored Procedure