cycle90210 (1/13/2016)

---

This is definitely possible and the table I do load it in to is a "staging" table of sorts (with interface status columns, date loaded, filename loaded, etc).

The issue...

Quick suggestion, load the file into a separate table (ie. bulk load), check if everything is there (row count, sum etc.) and simply truncate the table if unsuccessful.

😎

What...

The query hint is the READCOMMITED, why are you using it? Is it because you are...

😎

WITH (READUNCOMMITTED)???

MMartin1 (1/12/2016)

---

Thus if we have 10 rows for tables 1 and 2 each .... and table two has three columns to consider for one column from table1 -->

then...

There are no effective predicates in this query, it will return all rows and the most effective way for the server to do that is a table scan.

😎

Assume you are running Enterprise edition, otherwise DBCC CHECKDB does not do parallel execution and obviously the Resource Governor is also an Enterprise...

jeffsaks (1/12/2016)

---

Love your forum!

Here's the story.

I have 20 computers running an MS ACCESS application, all connected via ODBC (SQL Server Native Client 11.0) to a SQL Server 2012.

Everything works great,...

You are very welcome and thank you for the feedback.

😎

The two queries are not equal,SELECT * FROM information_schema.ROUTINES will return all routines regardless of the type, filtering on ROUTINE_TYPE = PROCEDURE will still return CLR procedures which SELECT *...

Phil beat me to it 😉 Here is a slightly different version

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(HearingDate,HearingTime)

AS (SELECT CONVERT(DATETIME,X.HearingDate,120),HearingTime FROM (VALUES

('2001-10-06 00:00:00.000','0830')

,('2010-02-22...

sys.all_sql_modules stores all sql modules, comparing tables it a bit more of a task, strongly suggest using 3rd party tool such as SQL Compare for this. A option could be...

snomadj (1/12/2016)

---

I don't know access but I have an access db that somehow interfaces with an old SQL database I need to move.

So I need to figure out how the...

Missing root note reference and root note namespace

😎

Another way is to use XMLNAMESPACES

DECLARE @TXML XML...