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