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. Show Multiple rows of data in line line
  2. How do you get the sum of all the detail rows in a BIDS report?
  3. error '80040e31' Timeout Expired but runs fast in Query
  4. Repeating in sql query, how to remove
  5. Bulk import CVS file (comma delimited)
  6. How can i upload a file in jsp and storing it in sql server using servlets?
  7. What is the best data type for storing different file types in ms sql server 2008 r2?
  8. How do I aggregate rows into a single row?
  9. My append query won't add new records.
  10. How to load data into table with foreign keys
  11. Import data to SQL DB Using Bulk Upload
  12. Incorrect Syntax near the keyword 'IN'
  13. MS access updating to SQL Server Identity Column potential weakness
  14. Bulk insert fails sometimes for a given file
  15. Function is Causing Deadlocks
  16. Using LIKE syntax in nested query
  17. Cannot attach mdf file named master
  18. SSIS job fails intermittently only on production.
  19. How can I find Miscrosoft SQL Sever 2005 notepad?
  20. SSAS and SSMS memory limitations
  21. Replace logic is required
  22. How can I set values of variables using a loop?
  23. sftp batch file
  24. load data from one DB in a server to another DB in another server
  25. ssis execute sql task
  26. Spatial index hints don't work in SQL Server 2008?
  27. Text searching
  28. SQL error 2714
  29. how to caluculate average of duration(starttime-endtime)
  30. Join T1.distinct_identifier to T2."choice"_identifier
  31. Please help writting this query
  32. How to Add an Auto-Increment Field With a Unique Name
  33. how sql server decides datetime format to use implicit conversions?
  34. Modify "Script Table as" template
  35. need to convert data
  36. Invalid column name 'RowTimestamp'. In Snapshot Replication(SQL Server2008)
  37. Is it possible (if so , how) to filter out Distinct values from a Query that uses two
  38. how to normalize tables
  39. text direction right to left for arabic text input
  40. Val() is not a recognized function name?
  41. A SQL query on the existence of columns in two tables
  42. Return value from stored procedure is "nothing"
  43. Jsp-Sql Server 2005-Unicode Symbols
  44. HHSS calculation
  45. set blank password for sqlserver 2005 for XP?
  46. T Sql join query
  47. MAX Date Value
  48. Restarting System?
  49. Transfer Data from one table to another table
  50. Inserting only time in the database
  51. Repeatable Read doesnt prevent this or am i wrong about it
  52. How to find Uppercase text in a text field
  53. SQL Server Report Builder 3.0, and I can't get the data to the formated report.
  54. Could not open a connection to SQL Server
  55. sql-Violation of UNIQUE KEY constraint 'UNQ_SID_PID_DOCTYP_DELMETH_SRC'. Cannot inser
  56. How to Add Dependent Variable into Where Clause?
  57. automatically run a SQL statement quarterly or monthly
  58. How to transpose this table ?
  59. Updating Datetime field in sql server database
  60. Dynamic date on Leap Year
  61. select max
  62. problem with trigger
  63. SQL agent Error - Critical
  64. using group by in tables joined together in sql server
  65. Joining tables on columns with differing data types
  66. How to speed up query that returns nulls and dates within a range
  67. Set timeout for a stored procedure across a link to another server
  68. Undoing a delete operation
  69. How to create a jobb that sends an email
  70. Performance Improvement of Stored Procedure
  71. Stored procedure to cancel an order
  72. SQL Server 2000 Temporary table(#temp) issue
  73. i want to calculate base on condition
  74. Picking latest 'duplicate' entry and linking to second table
  75. Change mdichild on runtime
  76. Update query with split funtion
  77. Help on selecting current record from one table with additional fields
  78. How to get rid of generated constraints?
  79. How can I hide my code from a stored procedure
  80. Case statement insde where clause
  81. Putting attribute on root node using FOR XML PATH & With XML NameSpaces
  82. Workstation Components
  83. Zip Count
  84. Rollback
  85. DB design for Privacy setting
  86. Combine more than one column in the same table and display the result as next next li
  87. Case statement and group by clause in function
  88. How to read from a text file in SQL query ?
  89. Median Calculation on a Column in a Table
  90. Nested Query
  91. substract two date
  92. Concatenation of Two Strings
  93. sql after insert trigger
  94. Not in or Not exists sql help please
  95. Case when statement in where clause
  96. creating an insert update trigger in sql
  97. WHERE clause with IN clause with CASE WHEN...
  98. COALESCE with MIN
  99. select count(*) from table_name not showing desired result
  100. How to validate textbox control in vbSql?
  101. How to correctly use join i sql queries
  102. Complicated date selection
  103. Multiple Queries from the same table ordered by user not working
  104. Right Join and Left Join acting different
  105. SQL Server query connecting through SAS
  106. Reset Database to default/initial state
  107. How Do I Retrieve job Information that how many times it occurs in a week?
  108. Transferring Data from one database to another located on the same server
  109. Msg 262, Level 14, State 1, Line 1 CREATE DATABASE permission denied in database 'mas
  110. How do i compare 2 rows from the same table (SQL Server)
  111. The conversion of a char data type to a datetime data type resulted in an out ofrange
  112. SQL Query to display records that dont match in consecutive rows
  113. Combine multiple records into a date time line.
  114. Sub query Question
  115. Sqlserver Instalation in command prompt with Mixed mode?
  116. Sql Server Tuning
  117. I am new to SQL can anyone tell me what this hint does?
  118. how to recover deleted records in sql table?
  119. how to fetch total working hours from the table for every employee for a week
  120. Disctinct query plus total column value
  121. subtract two datetime values
  122. Automating Sql(2008R2) backup/Restoration process
  123. Sql Transaction log for database is full
  124. data from Four table
  125. sp_who
  126. ssis derived column
  127. Output type of following query
  128. how to find working hours
  129. Remove Single Quotes from data
  130. Call .sql from .sql
  131. Converting number to text for concatenation
  132. SQL server VS2005 Between Date problem
  133. Ho Do I find List of file names on specified location in SQL Server
  134. To update single column of multiple table
  135. Printing File using SQL Procedure
  136. Txt File Print in SQL
  137. ssis derived column
  138. How do I Find Best Match of Disease from Symptoms
  139. IF ELSE to cause a WHERE
  140. SSIS send mail task
  141. call dll file in sqlserver
  142. How to Get Indian Standard Time in Sql server 2005
  143. getting the first letter of each word
  144. string vs varchar
  145. Ms sql
  146. Filter duplicate value
  147. Searching between 2 Date Values using vb sql
  148. date Form Datetime using Where Clause
  149. How do you select current record data to assign to variable in While statement.
  150. Case Select on 1 to many record relationship
  151. Question about RowNumber
  152. how to convert the unicode string to four byte signed integer
  153. How do I Set a defined variable = fieldname?
  154. Mutilple rows should write into one row with TAB delimited
  155. How to format a date from a form for SQL server
  156. I'm trying to import from a table of a password protected Ms Access database by using
  157. How to check indices with other columns?
  158. I got an error message when I am trying a select Query to import a table from Ms Acce
  159. The name "xxxx" not permitted in the Context (insert) ???
  160. GROUP BY troubles
  161. Avoid Duplication
  162. SQL Server Index Screwup??
  163. Choosing to select a column based on null values
  164. Using SQL Developer to work on SQL Server
  165. Timer for Executing the procedure automatically
  166. how to find the data type of a field in a table
  167. How does one do the reverse of a union query?
  168. sql exec copy file failed
  169. Converting from SQL server 2000 to SQL server 2005
  170. How to send tables as XML files?
  171. Help About Stored Procedure In Sql Server 2008
  172. Inserting values using INSERT INTO
  173. SubReportprocessing - RDLC
  174. Help in stored procedure Using Sql Server 2008
  175. How Can I Do Stored Procedure ?
  176. Batch script for database restoration
  177. Can one copy data dynamically from ms SQL to DB2
  178. getting error which says to create unique aliases for duplicate fields
  179. bulk query
  180. select sql query problem
  181. Insert into table after update trigger
  182. Sql database
  183. Dynamic SQL query Multiple rows based on table names linked in another table
  184. Update Last Record in SQL Server 2005
  185. SQL Server: Create an ID field (PK) based on two fields with a trigger-- HELP!
  186. How to Display Column Data in Comma Separated Form in SQL Server
  187. Can not connect to SQL Instance without specifying Port.
  188. migration
  189. How to provide password to SQL Database
  190. Bulk Insert with Errorfile
  191. SQL select query
  192. Is it possible to skip a bad record when selecting records from one Table?
  193. How to display the first record of the group in the group header in SSRS
  194. New to sql server could someone point out the error in this query
  195. Change php mysql to php mssql
  196. how to exec a query stored in table field and the field is TEXT
  197. Problem with a complex SQL Query for SQL Server
  198. Query multiple fields in same table.
  199. Sql, mysql
  200. Update statement in sql server timedout
  201. Using a variable in VARCHAR
  202. SQL Query
  203. SSIS packages - Transformation Help Require
  204. Result of comparing null
  205. SQL Query to text file "WHERE" syntax
  206. Can I safely disable VSS Writer?
  207. Return Only Sat/Sun dates in a date range
  208. Looking for some help with JOIN logic
  209. sql year function
  210. Bulk load: An unexpected end of file was encountered in the data file.
  211. Merge data from one table into another
  212. SQL Server mail won't alert my phone by text message
  213. Scheduling stored procedure to run once every hour
  214. How to get a cumulative total of fields up to a date specified in each record?
  215. sql if conditons
  216. server msg :207 errror
  217. Enter into database only new values found in the SQL statement, skip the ones already
  218. SQL Server Native Client
  219. SP to add next sequential user ID
  220. Prompt for User Input
  221. How to edit dataset.xsd created in sql server 2005 in sql server 2008?
  222. Delete error: Key column information is insufficient or incorrect
  223. Error in inserting multiple records
  224. Number of people logged onto SQL database
  225. updates in sybase
  226. append from table1 any sql equivalent query
  227. Connect to programme from other pc's
  228. Role Based Authorization to pages in an Application
  229. Maintenance Plan schedule fails
  230. Japanese sorting In SQL
  231. punctuation in between characters
  232. Agent Job Duration exceeds manually launched program duration
  233. Trigger to update multiple tables
  234. How can I transfer an encrypted stored procedure in SQL Sever 2008 R2
  235. how to join based on substring in sql query
  236. Insertion Into Multiple Tables Through Stored Procedures
  237. How to remove unwanted ASCII character in a SQL column
  238. How to decrypt the encrypted stored procedure in sqlserver 2008
  239. Pass throughs / UDF / Stored Proc / Views.. The differences in my upsize..
  240. SQL Server drive died, data drive is OK... now what?
  241. copy rows for a speadsheet that matched a word in a partuliar coloumn
  242. Our developers suddenly need to specify port number.
  243. Multiple foreignkey in single column
  244. Connecting Php with MSSQL server 2008 remotely
  245. SQL: what is the diff between "any" and "all"
  246. Error while using Aggregate function(sum) with joins in sqlserver
  247. sql server 2000 database file unable to attach in sql server 2008 ?
  248. SQL login error
  249. subtracting 2 datetime values
  250. PIVOT or CASE? - Combining multiple rows into 1 row..
  251. Fix Error SQL Server 2005 Reporting Service
  252. Transaction log
  253. Setting up Linked Server on multiple servers with mulitple types of authentication
  254. How to copy rows from one table to another with same structure
  255. Get records based on month and year
  256. how to extract an email from the FROM field
  257. How to retrieve column name of table in SQL 2005 and display in dropdownlist in ASP
  258. Report Service Subscription
  259. Data conversion
  260. How to get required output in sql
  261. Stored Procedure Sub-Select?
  262. find nearest meximum date
  263. How to remove carriage return and line feed at the last record of the flat file
  264. Is Microsoft SQL Server 2008 Standard version compatible only to Windows Server 2008?
  265. How can i use a different NT user (not the login one) to connect to sql sever?
  266. CLR for sql server 2005
  267. LIKE Parameter Problem Stored Procedure
  268. Update WHERE checking with another database
  269. Using a max for the Added Date
  270. Highlight max value in a subtotal row of a crosstab
  271. dynamic variable names from table
  272. SQL Server Express 2008 R2(free version) from SQL Server 2008 R2 Management Studio
  273. Displaying Query Result Vertical Display
  274. scientific notation to original numbers
  275. Installing ODBTP
  276. sql 2000 security sa password problem
  277. alter statement
  278. INSERT INTO EXCEPT doesn´t work
  279. removing redudant data
  280. How can I do a "Grouped TOP 1"?
  281. Comparing data in two tables to find missing records
  282. Getting current date as part of an Stored Procedure
  283. Add not null
  284. Dynamic order by
  285. Crystal report date parameter and sql expression
  286. update customer id numbers
  287. calc % from 1 col 1 table
  288. create after insert trigger
  289. Corruption of Metadata in Analysis Services
  290. INNER JOIN Options
  291. Trace Table in Sql Profiler
  292. bulk insert rowterminator issue
  293. How can i take my DB mapping?
  294. Last deleted record
  295. Copy of Production DB into Reporting DB on daily basis.
  296. how can get below output?
  297. What is the best practice for databases containing People and Organizations?
  298. error 26 connecting to named instance sql server from network share
  299. Installed SQL Server 2008, how to create an instance
  300. How to remove duplicate rows from a temp table
  301. Adding Active Directory User as Sql server users
  302. Id reset every 12am
  303. Displaying Data Accross
  304. Update a column when..
  305. SQL rows to columns plus calculations
  306. connection error with sql server 2000
  307. select count with table join
  308. Error while opening my Executable file?
  309. 95th percentile and Median functions in SQL server 2008/2005
  310. Query to Find Unmatched Data
  311. The dependency service or group failed to start/
  312. Transpose Data into Buckets
  313. Time Out Expires messages during printing and transactions
  314. Replace the variable value with new one (in all SP's)
  315. DBA member updated the data. How to confirm that he did the update.
  316. Updating ',' separated values in sqlserver with different values
  317. Encode special character for sql insert statement
  318. best book for SQL server 2008 design and implementation (70-433)
  319. Snap in Creation Failed
  320. SQL 2008 vs pervasive
  321. How to get reference information between parent and child tables (MS SQL Server)?
  322. Log Shipping inital Backup left in (restoring...) mode
  323. MS SQL Trigger only for insert.
  324. Overpunch Character Conversion
  325. how to write a trigger after insert
  326. SQL Table = Access DB Table = Excel Spreadsheet
  327. copy table data from ane database to another
  328. Import and Clean Dirty Excel 2007 Files to SQL Server 2005
  329. How to include count to complex 3 table query
  330. Outer Right Join on SubQuery
  331. Alter all tables of a database having one column common
  332. MSSQL - Search and Ranking - Strange Occurrence
  333. How to add years to date?
  334. Convert Access 2003 to SQL SERVER 2008
  335. Get table sizes from DB
  336. How to return results for multiple words in query?
  337. Invalid column name
  338. Inventory counting system advise/critique
  339. SSIS package script exception: device is not ready
  340. size limitation for dynamic SQl query
  341. What is the maximum number of records SQL Server 2000, 2005 and Oracle 11g can handle
  342. Visual Studio "freezes" when connecting to MSSQL
  343. SQL database design question
  344. eliminate comma from string
  345. Excel data to populate SQL tables
  346. Using Like statement in parameters
  347. sql query with sub clause
  348. Filter Scalar Subquery
  349. how to update a value in other table
  350. Data Of AutoGenerate ID Columns Of Sql-2000 Server
  351. SSIS: Comparing/Manipulating multiple .CSV files
  352. Sql Update Query
  353. Creating team match ups using unique combinations
  354. How to load records into a subform using stored procedure
  355. Cannot Start SQL Server 2k To Restore DB's
  356. SSIS Taking to Long in Pre-Execute phase after switching to Access 2007
  357. How to set dates in a single row?
  358. How do I arrange my tables information in alphabetical order
  359. Single login for multiple database.
  360. Help With Query to Get Totals Sorted by Month & Year
  361. how can i convert my DB access to MS-sqlserver?
  362. Should i create separate login table??
  363. how do I join two complex Statements with different number of targets
  364. Error converting data type nvarchar to float?
  365. how can transfer the data?
  366. database not support arabic language
  367. Getting results using Union
  368. Sql Server Works Slow in Network
  369. SQL Server 2005 how to partitioning an existing large table
  370. creating Trigger for every table in a database
  371. About syntax
  372. What is a SQL Injection?
  373. What is the exact meaning of sql pooling ?
  374. Select the first string
  375. Problem in installation of SQLEXPR32.EXE
  376. Anybody know how to restore sp_addlinkedserver procedure?I dropped accidentally..
  377. i have got an error when i execute an internal representation of the XML document.
  378. Need help for NOT EXISTS query
  379. VARCHAR(MAX) only contains 8000 characters?, Need more than 8000
  380. The column prefix does not match with a table name
  381. Importing multiple tables
  382. Only printing 8000 characters after using varchar(max) instead of max(8000)
  383. Getting error :- Msg 170, Level 15, State 1, Line 18: Incorrect syntax near 'MAX'.
  384. How can I grant "deny access" to all but 4 tables in a schema?
  385. How to update data in a table based on holidays of the specific year?
  386. SQLMail sitting in outlook
  387. Getting an error When i am going to convert my SP as dynamic
  388. get start date and end date sequence
  389. Login failed for user
  390. How to update the data using stored procedures code?
  391. Finding MAX value from emp_id column using SQL query?
  392. SQL Syntax Error
  393. Slow SQL Server Express (50 times slower than on other machine!)
  394. sql2000 with windows2008
  395. Query Req:of having same days
  396. DateAdd Function
  397. How do I create a trigger that will insert only changes to a field?
  398. Stored Procedure or Trigger for the login
  399. how to write script in datafolw from Excel to DBTable?
  400. Ambigiuous column name
  401. How to transfer Data from Multiple Excel sheets to single Database Table?
  402. Coverting decimal to a date value
  403. What is the syntax for nesting a query in mssql2005
  404. Sql pivoting dynamically
  405. nested query
  406. Increasing by percentage
  407. File Browser for Access 2010
  408. Sql SUM and Update
  409. How to install microsoft sql server 2000 as server tools on Windows XP?
  410. How can i use REGEXP_LIKE() in sqlserver?
  411. How to use concat method in sql server?
  412. How to use sequence method in sqlserver?
  413. How to select Max ID following Insert Statement and direct it to the following page?
  414. How to fix "Error : Source file or directory missing or cannot be read" error?
  415. How to connect to sql server 2000 on a LAN?
  416. My computer's SQL server is not working properly.
  417. Cannot create link from SQL Server to MYSQL
  418. How to fix "Source file or directory missing or cannot be read"
  419. How to query for conflicting values in a table?
  420. How to create an EXCEL file in advance and want to export data to it in sql2008?
  421. Error when using openrowset for particular record
  422. How to fix error "invalid column name"even though the column exists in the table?
  423. Calculating Min/Max Timestamp Intervals For Inserted Rows
  424. Who to return two counts in the recordset?
  425. how make stored in sql to search between 2 date and search by date only without time?
  426. SQL 'FOR XML' query
  427. How to modify records in tables on web server using desktop application?
  428. HELP: error 3154 when restoring a backup file
  429. how can i use NextVal() method in sqlserver?
  430. Hellp Convert MS Access Pivot querty to MS SQL
  431. Junction Table or bit field?
  432. SQL Create Dynamic Table View From Another Table
  433. How to Import CSV into MS SQL?
  434. Insert into two related tables
  435. Is there any equivalent for Oracle's NEXT_DAY function in SQL Server?
  436. How can I connect Sql Express?
  437. How to convert database from ms sql server to mysql?
  438. Recordset becomes NULL after first read/use
  439. Information-Schema and Sys user accounts
  440. How can I use output parameters to return some values from database usin sql server?
  441. MS Access connections issue with SQL server
  442. How to insert Arabic characters in MS SQL Server 2005?
  443. TSQL on SUBSTRING
  444. How to resolve error 233 in sql server 2005 in windows 7?
  445. How to pull multiple fields into one query row?
  446. How to create a job to run a query and save the output in .xls format?
  447. SQL 2005 Tables seem to have become read only from Access database
  448. two queries summing into a single value
  449. sql parameters
  450. How to convert rows into columns?
  451. check all data from a SQL table dependent upon another two tables
  452. Why unique takes only one null as we know all null are not equal?
  453. How to fix error 26 when trying to connect to a database file?
  454. How to fix Invalid object name errors on working query?
  455. i want to restore backup from Network drive in MSSQL server 2003
  456. How to search 3 or 4 numbers from a string?
  457. How to compare date and time field in sql query?
  458. How to sort calcuation by date and transaction id?
  459. How can we add bulk data into a variable in SQL Server using Stored procedure?
  460. How to delete records of one table that exist in another table have no keys?
  461. How to take averages of data and place them into a temp table?
  462. How to calculate the next available Sunday to the following Saturday?
  463. How to fix syntax errors in this query?
  464. Is there a way to use like with an array of values?
  465. How to propagate date table automatically?
  466. How to select all records one criteria, but not another?
  467. How to redirect the Web Site Adminstrative Tool or create the Security DB?
  468. How to Retrieve Records of any other Date IF Current Date Record is not present?
  469. Is it possible to cast the return value of a compute avg(X value) to show 4 decimal?
  470. Is it possible to use .MDF file without installing full SQL Server?
  471. How to save in Sql Server or Filesystem?
  472. How to mark a date stamp and also 2 fields as yes?
  473. How to drop & recreate all indexes via script?
  474. How to show dates from Sunday through Saturday?
  475. Getting error message ORA-01008: not all variables bound.
  476. How to convert rows into columns and vice versa in sql 2005
  477. Help! SQL select statement for an uncommon task
  478. How to convert commas into periods?
  479. send mail through sp_send_dbmail in sql 2005
  480. Query optimization - where - ISNULL
  481. Rounding up to the nearest minute
  482. Can a table be both parent and child to another table.
  483. How to get Max value from a column?
  484. Converting a stringbuilder object to a stored procedure
  485. Need help recovering a corrupt SQL database
  486. How to move mssql data to mysql database ?
  487. What am I doing wrong on this one?
  488. How to increase the users to connect SQL SERVER 2000?
  489. Problem with updating dates
  490. Query of SQL Server
  491. SQL Case Syntax Issue
  492. General question about specific SQL problem
  493. Is it possible to generate xml from a sql server database using php?
  494. Select queries with columns populated with Null
  495. How to make column data into column headers
  496. Invoking stored procedure takes a long time to start
  497. Street Address Clean up using sql server
  498. How can i get records from table A which is not in B in sql server. eg A-B
  499. Get all Records from table1 and the correspond values from table3 verify MId table2
  500. Need help with scripting
  501. How to solve this syntex error?
  502. SQL Loading where to start?
  503. possible to use @variable in function?
  504. How to display a numeric value in different formats depending on value
  505. Job action completed Exception occured:unable to export file [0x80020009 ]error
  506. To copy the data in Excel file,XML file into a database?
  507. How to get list of tables linked to current table
  508. fetch value without duplicate column
  509. what is wrong with my select for the retrieval of function data - getting error 216
  510. Unable to connect to DB using ODBC
  511. Converting Number to Time in SQL
  512. Performing desktop queries vs. server based
  513. How to delete a unwanted university field from my instructor table?
  514. when I wright the statement in SQL 2005 error
  515. How does data indexing work in MS SQL?
  516. Is it possible to rename table to datetime?
  517. Why are leading zeros not displaying?
  518. Difference between oracle 9i and sql server 2008
  519. How can I compute my Age_Group field? It's based on a calculated field, CURR_BAMTIME
  520. Adding a primary key to a table
  521. Do i need to shrink database
  522. Update table with result from stored procedure/query?
  523. how can I retrieve the data '2010/05' by using the getdate variable
  524. how to select specific year/mo from table stored as varchar(7) '2010/05' in query
  525. How to select yesterdays records in sql server 2008?
  526. Why does an SQL2000 database appear to change size, then revert to original?
  527. execute procedure automatically at the specified time...
  528. How to setup replication between different Domains?
  529. Is it possible to use Case in Where clause as follows?
  530. SQL in dev and live environment
  531. How to most recent records from the following recods sets in SQL Server?
  532. SQL to Excel [Paramater Query Syntax Issue]
  533. How to integrate the data from SQL database to quickbook?
  534. UPDATE Query : Incorrect Syntax
  535. How to copy or insert records into the previously created table from another table?
  536. how to join these two queries?
  537. Query by date optimization
  538. convert nvarchar(number with thousandsseparator) to integer
  539. Condensing Multiple Rows Of Data into One Row of Data (into Columns)
  540. Changing Rows to Columns
  541. how to join 2 sql queries
  542. How to transpose (partially) table fields
  543. How to run a Inner join on same table?
  544. How to pull the most recent transaction based on entry date?
  545. simple problem with a table value function
  546. Update and replace query error
  547. How to import data from ms access 2000 to sql 2005?
  548. How to copy users, roles and permissions from existing DB to new DB?
  549. SQL Server error '80040e31'
  550. How to compress backup files and delete old backups?