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