View Full Version : SQL
- VBA-SqlServer: stored procedures, jobs
- Cracking the ice
- A question for Squealers?
- Going beyond SELECT *
- Anyone care to explore
- SQL via Logparser
- Big Kahuna: SQL Server, XML, Logparser
- Solved: Something Else worth discussing
- 2 more for the Road
- Joins
- ORDER RECORDSET BY NULL WITH DAO
- SQL Server 2005 - Using Regular Expressions
- A Few Resources
- SQLServer Nvarchar unicode test [for Tommy et al]
- Solved: vb-ado-access mdb
- [SLEEPER:] SQLServer XML Query
- Nice-Neat XSD file generation
- Nice....
- Query Browser
- Export Excel Workbook to SQL Database
- SQL Syntax Question - LIKE Operator
- ...and back to XSD
- Sleeper: Decode function
- Not sure I'll get an answer
- Solved: Conditional ORDER BY in MS SQL
- Solved: Using SQL to translate Nulls into Empty Strings
- Solved: Is it possible to "ORDER BY IN" ?
- Update Query
- Solved: Help with JOIN statement (SQL Server)
- wData
- Query Status in Excel
- Record Macro won't complete query lenth
- What's with the "@" symbol?
- Solved: difference between types of databases
- Syntax Variations
- Sending data to Access via VB
- [SOLVED:] SQL Server, SELECT DISTINCT [joined tables]
- Execute Insert Query and get the key
- max at the same time of 3 fields
- coding for custom function
- Excel and MYSQL
- Solved: Complicated SQL for a VB user
- Solved: Access-SQL Server Update Query
- SELECT INTO via OpenRowset
- SQL Server: ADO Select Between 2 DB's
- Gosh!
- Sums change when I add Inner Joins
- Efficient: HasRecords?
- Access/SQL Sever - to link or not to link
- Closest date in a set of tables
- [SOLVED:] Excel connection to SQL Server
- Solved: String Length
- Solved: SQL Convert() datetime issue
- Jet 4.0 ISAM "INSERT INTO....."
- Is a SubQuery Possible
- Solved: Recordest Filter
- Recordest Filter(2)
- Unique retrieval from timestamp
- Solved: Upadating from one table to another
- [SOLVED:] Create Table (SQL) in VBA using an Array and String Variable
- Excel to Access
- Banner
- Write into SQL
- This is how to write into SQL db table using excel VBA
- How to run query, sum the columns, transfer to a table?
- SQL help - date ranges
- Solved: Implementing DBCC calls from ADO
- SQL Server Reindex Via ADO: Redux
- Solved: SubSelect on Same Table
- Solved: sql qurey to arrange by months
- INNER JOIN problem
- Multiple SQL Statments in Excel
- Solved: 8 decimal date field?
- Select nearest date
- export data from Excel to Oracle using ADO
- SQL Server - Multiple Left Join
- Solved: date format in vcarchar
- Hexadecimal Represented As Varchar
- Solved: Online SQL Database - access via VBA from Access 2007
- [SLEEPER:] Counting String Null Values
- How to connect to SQL Server from VBA use ADO
- Connection string for Access Database (LogParser)
- Copy records with new date in the same table
- Date Groupings
- Date part
- Auto Item Send Error
- Update Statements
- CrossTab Query
- Problem with Update Statement
- vba sql datetime format
- Solved: Simplify SQL
- Vba Code to insert data from access table to mysql table
- Solved: Report From query issue (access SQL)
- SQL Enterprise Manager (View) IIF Then
- Error 3001 when calling stored proc
- Excel api and databases
- Wildcard in SQL
- LogParser SQL - basics
- LogParser SQL - basics++
- Newbie - Excel data from MySql on server
- Solved: SP_HELP
- How to call a Stored Procedure in Word
- Stored Proc question
- Solved: Stored Procedure not executing from scheduled task?
- Inner Join 2 Excel Sheets with ADO?
- Logparser SQL and HTTP/SOAP: redux
- Solved: Testing current date...
- Pivot Tables question
- SQL query to retrieve only rows from 60000 to last row
- Fun with SQL Policy Manager Exported Results (XML)
- Solved: SQL Server 2005 Connection Problem
- Concurrent Installs of MS SQL Server 2005 And MS Sql Server 2008 Express
- SQL Compare Databases
- veiw sql query for the output.
- Solved: D*MN Column Headers!!!!
- Data import from closed workbook omits cells
- Retrieve SQL Server data from remote server
- Excel to SQL
- SQL Relationship
- Solved: Convert Varchar to Date format
- [SOLVED:] Connecting to Commercial Software
- Friendly inquiry
- Solved: SQL Server Express - Free Download
- [SOLVED:] Installing SQL Server on a Server
- ODBC in SQL error
- Field Name unknown in SQL with VBA excel
- How to learn VBA excel with use ODBC connection SQL query
- QueryTable.ResultRange includes header row
- Querying dates fails
- Solved: Using SQL to build a drop-down list
- VBA Check Box
- How can i link my website to the result generated from excel (VBA) ? I have no idea !
- Solved: List grid solution for a user form
- Solved: SQL Syntax for querying two tables with specific columns
- SQL and Word Connection - finding data to put into word
- SQL Server 2008 book recommendation
- Odd 'Where' statements
- Can't create table from script
- SQL Query in Excel VBA - Runtime Error 1004
- Solved: Populate a comboxbox and Listbox in a excel userform with an sql table data
- Solved: Alter table script
- Solved: Extract data from SQL Server table into excel
- Solved: New SQL user
- SQl server 2000
- access 2007 update query using CASE
- select multiple foxpro databases for query
- Use a stored procedure in Access 2007 ..
- Solved: Help required in SQL Statement.
- SQL help, ms access
- Solved: Specific Order?
- Solved: Convert 12-hour to 24-hour
- Solved: Count include 0?
- getting value into a string using sql statement in VBA.
- get list of items which are there in result of 1 query and not there in another query
- Solved: nested loop on sql statement
- Update query in ms access
- MS Sql Reporting Services configuration problem
- Syntax to display last day of current month
- SQL Server Export Specifications
- Solved: VBA-SQL Type Mismatch
- SQL Express, Access front end deployment
- Batch processing SQL query strings
- SQL COMMAND ISSUE
- Quick question - Sql server
- SQL Syntax Error
- Access Format vs SQLS Convert
- Solved: Type conversion error with SQL query
- ODBC connector
- Store Procedure that deals with nested tables?
- Feeding data set into a sql stored proc using VBA
- Solved: ACE.OLEDB and SELECT INTO [Excel
- Solved: vba to solidDB
- SQL problem with Null
- Solved: How to fill all sheet name into Combo in ADO
- SQl VBA Access 2007 -filter not working properly
- Best Practice Advice
- Sleeper: Create Subtotals
- Solved: Remove duplicate records
- Access - SQL Query to repair table.
- converting Access db To SQL Server
- TO_NUMBER SQL function not work
- Update Script
- ListBox.Value inside an MySQL Query
- SQL Download
- Merging into one....
- Solved: ADO error: syntax error or access violation
- Notifying Excel 2007 about changes in a database in SQL Server 2008 R2
- Get all results from where clause even value doestn exits.
- Solved: Table Design / SQL Design Advice
- If argument in SQL query
- Setting Parameters or Query def for Access 2003 DAO SQL query
- different version of versions(dialects)
- Excel to SQL Server (SqlBulkCopy method)
- SQL Server Database Integration with EXCEL
- Sending a SQL String to SQL Server 2008 from Excel?
- Multiple JOINS without NESTING
- empty recordset when multiple entires in parameter
- Database Design for Multiple Filters
- VBA code to export SQL extract result and formatting
- ADO Connection Problems
- Specified Procedure Not Found
- Advanced SQL Sorting
- sql excel vba connection problem
- Solved: Need to Store query results for use by another query
- Can't get RecordCount of a Query Output from Oracle DB using VBA
- Urgent : How run BCP command using .bat/.vbs file from Excel VBA?
- Converting A date Function from VBA to SQL
- Plz help a newbie understand SQL
- Present SQL result in Word???
- SQL insert
- VBA ,SQL Data type
- Solved: Loop to create repeating SQL statment with incrementing variables
- creating random future dates with datediff()
- Oracle SQL
- Filter by previous week
- Statement Help
- Solved: Update Query
- Can't resolve "Query too complex" error
- Excel Front end, SQLServer backend???
- Connect to oracle from excel
- Count unique instances of a column in relation to another column?
- Doing a calculation on a derive column within an SQL statement
- Solved: ADO Parameter query.. from text file!
- how to automatically update sql results in ActiveX Combobox?
- How to pass combobox/textbox selected member into sql string in main module
- SubQuery Amnesia???
- VBA code to get data from Mainframe
- Solved: Visual Studio Form Control
- creating bounded groupings
- Solved: Table Autonumber and Visual Studio VBA
- CopyFromRecordset vs. GetString()
- Automation Error:
- VBA [Excel 2007] to SQL Server [9.0]
- Return multiple results if multiple strings
- [SOLVED:] transitioning from vba/access sql to T-SQL and errors
- LocalDB installation
- vba to sql
- SQL string syntex problem
- only local SQL databases?
- BULK INSERT Text Files into SQL/Oracle
- Emails
- Book
- [SOLVED:] Excel Formula To TSQL
- [SOLVED:] Filter DataBase Between Selected Start and End Dates w/ Visual Studio 2012
- VBA - SQL Syntax checker function
- VBA Code
- AdventureWorksDW2012
- How to query oracle using VBA
- Getting an error in this VBA
- SQL Embedded in VBA using Queryopen
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.