Nice straight forward question --- Thanks Steve

Oops here we go again .. blog postings show up in the Forums page, but this one is super special ..

It is wishing us all a Happy New Year...

You stand a better chance of getting tested help if you would post your table definition, sample data and required results in a readily consumable format.

...

Unfortunately I am not a fan of SSIS, the only further assistance I can suggest is to read the "Starways" articles for SSIS

http://www.sqlservercentral.com/stairway/72494/

First lets get some data into a table

CREATE TABLE #Order(Quantity INT,Placed DATETIME)

INSERT INTO #Order

SELECT 100,'1/20/2011' UNION ALL

SELECT 1,'2/7/2011' UNION ALL

SELECT 2, '3/1/2011' UNION ALL

SELECT 2, '2/5/2011' UNION ALL

SELECT 3, '4/18/2011'...

Probably not the best method, but you could use SSIS to import the data into a "Staging Table" and then execute a T-SQL statement to do what you want to...

I would suggest using GOOLE, for example I entered

"temporary employment agencies in cleveland ohio". and found reference to 47 different agencies.

Clicked on a few to visit their...

Whoops incorrect forum .. sorry about that

Here is something to get you started

CREATE TABLE #t(Empcode INT, BasicPay Money, Rent Money)

INSERT INTO #T

SELECT 65, 800, ...

Have you considered using the MERGE statement? Greatly modified to NOT change anything simple to find those rows.

MERGE dbo.Departments AS d

USING dbo.Departments_delta AS dd

ON (d.DeptID = dd.DeptID)

WHEN NOT MATCHED...

tilew-948340 (2/23/2012)

---

I finally understand why I see the N' in some queries and why I got "H e l l o " instead of "Hello" (with space between chars) when...

Have you installed the lastest software updates for 2008R2 ?

http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/70092/

and remember that ALTER DATABASE syntax replaces the sp_dbcmptlevel procedure

corrected spelling error

L' Eomot Inversé (2/23/2012)

---

Nice easy question, nice straightforward answer and explanation.

I guess that particular collation was chosen to demonstrate that not all T-SQL is case insensitive even when the collation...

Read this article by Jeff Moden about the "ISNUMERIC" function and how it can result in returning a field is numeric, when it fact it is not, much akin to...

Hugo Kornelis Posted Today @ 9:19 AM

2. If model is read-only, newly created databases still default to read-write. However, the SSMS GUI "cheats" by sending an ALTER DATABASE to change...