PDA

View Full Version : Microsoft SQL Server

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 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119
  1. How to convert number to 2 decimal?
  2. Can I import a .txt file by string start/end position
  3. Count and using IN
  4. XML Schema
  5. Record Completion Issue
  6. SQL standard & Express on the same machine
  7. SQL Server Query
  8. Need help to access reprting service
  9. How to walk through all the columns of two different table
  10. Deserialize JSON to SQL Server Table
  11. Bloated tables
  12. delete stored procedure with some complications
  13. in memory db for MS SQL Server
  14. Fetching Next previous and current rows
  15. Query to retrieve records that sum to a field in another table
  16. How can I get columnnames against each record in a table
  17. Process for Removing Duplicates in Table
  18. 10 DBs on one Raid10 or on two Raid1?
  19. Select last record by group
  20. Overlapping full backups
  21. Using COALESCE and retrieving data
  22. sum of group by two columns
  23. Help upgrading access database
  24. Mapping workstation applications
  25. MS SQL Synchronisation - Question
  26. error in using alias column name as function parameter
  27. Finding an occurrence that does not exist
  28. Removing duplicates?
  29. Confusing Order By Query
  30. need help with DB architecture
  31. Table Configuration
  32. unable to attach database
  33. Combining two selects (budget/actual)
  34. setup new database
  35. Query Help?
  36. DTS Vs Link server ???
  37. Replace logic is required
  38. Quering DateTime Field and Summarize just using date
  39. using cursor for update statement
  40. read only database restore brining database in single user mode
  41. Using Left and Right functions.
  42. How to make view name dynamic
  43. Select Case Columns
  44. max avarage salary
  45. DTSX package not generating double quotes properly
  46. Best dataype to store a version number
  47. How To Generate/populate already existing column with sequential data
  48. Best practice protecting database integrity
  49. UPDATE query with ORDER BY clause
  50. How to transfer Oracle 10g to SQL Server 2005.
  51. Duplicate Result Rows from 2 table join
  52. SQL 2008 disk configuration
  53. table joining
  54. Export Import Script
  55. replacing nodes of an xml variable using sql update with xquery
  56. xquery
  57. using xquery to populate a table var from xml
  58. Sum Columns from multiple tables
  59. Unable to connect to DB using windows authentication when using VPN connection
  60. TADOQuery Error While Executing The SQL Second Time
  61. how to draw trend for Line chart in SSRS 2005
  62. Check Constrain Based on Another Column
  63. bcp export w fmt
  64. check user supplied date range is in between startdate and enddate
  65. Log File Auto shrink 'Yes' is good option?
  66. Migrating SQL to a new Server
  67. Due to deadlock , application stuck.
  68. Dynamic Update for multiple tables
  69. power shell script or windows batch file for sql server
  70. Inserting data into one database from another database
  71. Dynamic SQL
  72. Windows 2008R2 Active / Passive Cluster
  73. help with creating table in sql
  74. Can this loop be replaced with a set based SQL command?
  75. ODBC Connection to SQL Server Error:10060
  76. NEWBIE: QUERY to create VIEW/REPORT
  77. Trigger HELP!!!!
  78. SQL 2000 run .exe
  79. Modifying SP When Exporting Data With SSIS
  80. Stored procedure sort records - possible?
  81. Listing orders without a date
  82. assigning datatable to a object type variable in SSIS
  83. upsize access 2003 to sql server 2005
  84. SQL 2008 High Availability options
  85. Sum Columns then limit the output
  86. Database Replication problem
  87. Pass parameters to a query using a subquery
  88. Server Performance
  89. Need help.. Substrings. Ugh!
  90. Sql avg
  91. SQL Help with distinct
  92. Fill Factor
  93. SQL server : maximum row size exceeds the allowed maximum of 8060 bytes.
  94. How to include a set of different attributes from same dimension in MDX crossjoin
  95. My Second Database Design
  96. How to Assign ID Randomly
  97. At what period Reindex require?
  98. Is there an easy way to ignore data on inserts that violate a rule?
  99. All emails received as junk or spam folder
  100. Recursive queries
  101. Dynamic file name for importing
  102. tutorials/Video
  103. SQL SELECT Statement
  104. How to pull existing table from Database and merge in to new database.
  105. SQL Server output data to text file
  106. in T-SQL can I use a formula from a table cell?
  107. Which exam to take?
  108. Need Help with an ERD Model!
  109. Failed to convert parameter value from a String to a Int32.
  110. Sql
  111. How to know what scripts an Application sent to DB?
  112. Looking for SQL DBA job: hold MCTS and OCP DBA certificates, with limited SQL server
  113. How to connect to SQL Server?
  114. Yearly Production
  115. Database management??
  116. Select works, update does not
  117. FK Constraint from one column to two different tables
  118. checking 2 sql columns and displaying result in 1 column
  119. database schema
  120. Join on multiple columns
  121. Why does this simple update take so long?
  122. SSIS Derived Column using DATEADD
  123. From SQL server to Data feed in and pull out
  124. sql query
  125. Multiple DB versions, intermittent connection
  126. Storing multiple values from a dropdown list
  127. Edit / Updates Query
  128. A few queries that I need help with
  129. calling a SSIS package in VB
  130. Connecting to DB2 on zOS in an SSIS Package
  131. Best Method for Displaying Data from SQL DB on Website?
  132. Combined Sum of Query From Two Tables?
  133. Multiple joins to the same column
  134. Create New Table From Several Existing Tables?
  135. Miss
  136. PLEASE help - query failed: Duplicate entry '2' for key 'PRIMARY
  137. forming a sql query
  138. How to compbine 2 query from diffenent table
  139. Bulk Insert Help
  140. Table Structure Help
  141. Connect to MSSQL on remote, with windows authentication, JAVA
  142. DISTINCT Selection problem!
  143. Quantum distribution database
  144. Trouble after adding field / table to existing SQL db
  145. To find Missing month(s) by matching against a range of dates across different yeasr
  146. Introducing Microsoft SQL Server 2012 (ebook)
  147. DTS Package vs SSIS
  148. Find and print
  149. Lowest Year & Month
  150. SQL Server 2000 problem
  151. Add to Pivot Query
  152. Database File Configurations
  153. Message Users before Killing Spid
  154. Access to SQL Server
  155. Excel file to sql server
  156. How to Gain SQL Server Work Experience
  157. migrating servers
  158. Help
  159. Data Sycing in SQL Table Help
  160. Migrating Access Database to SQL server
  161. SQL 2008 R2 doesn't support CLR 4 (4.0 .Net Framework)?!?
  162. How to connect to BMC Remedy ARS with ms sql server?
  163. Date minus 1 day help please
  164. Dynamic PIVOT
  165. Cross table Multiplication Query
  166. No further entries of a value in table
  167. Drop procedure
  168. All emails received as junk or spam folder
  169. Interface link between 2 database
  170. need algorithm help for determining a range of values
  171. Max id if multiple records exist help please!!
  172. Alter a Column to and Identity
  173. site for querry performance
  174. Join On only '1' Match
  175. looking to performance tune this query
  176. Openquery/openrowset
  177. How do I aggregate a column by concatenation?
  178. Time Between a Customer's Transaction
  179. Sql server database synch b
  180. Help with my constraints and pkey thnx
  181. Import Access 2010 Report into SSRS 2005
  182. Multiple self joins
  183. could contain usefull data for you guys
  184. Convert PDM to SQLserver
  185. ER diagram from functional dependencies
  186. Front/Back end question
  187. Query Question - Display First Date
  188. Very slow looping
  189. Is there a more efficient way to write this?
  190. Help
  191. MSSQL to Oracle DTS
  192. SQL Get latest records when date & time are seperate columns?
  193. Archive off data
  194. database convertion
  195. Merge Replication
  196. How to convert bigint to timestamp
  197. SQL Server question about time
  198. New Columns from Row Data
  199. speed loss between set-based, cursor-based and object-based processing
  200. Splitting Dataset in 2 parts
  201. Add Column Between Two Columns
  202. SQL 2008 R2 + Slipstreaming SP1
  203. Duplicates
  204. SQL Server and Protégé
  205. Basic Query problem
  206. Accidental dump
  207. sort by relenvance
  208. Windows batch and bcp of sys table data
  209. SQL Syntax
  210. SQL Server DAtabase- Uploading Staging tables
  211. why isnt this query working??
  212. SQL Help Please
  213. Grouping Help
  214. Query Question (searching two columns)
  215. Help
  216. Handling Multiple Search Criteria
  217. performance of update query
  218. TSQL to run all "SQL Jobs"....umm. Help.
  219. Will you help me with MSSQL Syntax in VB?
  220. physical table Vs tem table
  221. Drop command issues
  222. Combining two field results
  223. Where clause with conditions
  224. Need an urgent help!!
  225. how to select earliest record?
  226. Help!!!
  227. Distinct help
  228. SQL Server 2008 R2 Express Edition
  229. How to replace data from one col with another col??
  230. Sql-Server Jobs/ASP.NET Challenge
  231. Change the name of the constraint
  232. Linking ID from one table to data in another table
  233. SQL: Select Case when ...
  234. Field name with [ ]
  235. Microsoft Business intelligence studio - install???
  236. Need code converted from VBA to SQL
  237. My T-SQL script, what's wrong with it?
  238. Linked server: "Cannot start more transactions on this session."
  239. alter table name error and table column
  240. Incorrect syntax near
  241. Displaying results in an aggregate query without grouping everything?
  242. Procedure to Select entries from yesterdays date
  243. SSRS Charts
  244. SQL Server 2005 simple select statement not working
  245. URGENT: Need to trim the text data stored in image column
  246. small clarification
  247. Filegroup name modify error
  248. SQL- Table Creation using Cursors
  249. Removing Junk Characters
  250. getting uniqe rows from multi table query