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