richpurdey (2/22/2013)

---

I am just starting my journey to MS SQL DBA .

I wish to enhance my employability, I am already a time served Sys Admin/MCSE in the Financial Services sector.

Do...

I read the previous comments, and except for a very few, posted by us "oldtimers" which bought back memories of my first programming tasks in 1960. (Hard to believe that...

L' Eomot Inversé (2/21/2013)

---

Right now, I'm feeling embarrassingly stupid. :blush:

I was trying to put together a submission for QotD. But I thought I'd seen too many comments recently...

HERE it is from a table (Now I used a temporary table BUT ONLY for illustration IN your situation it would be the real table)

/* I...

If you import the data into a staging table, you could then execute:

DECLARE @D1 VARCHAR(20)

DECLARE @D2 VARCHAR(20)

DECLARE @D3 VARCHAR(20)

...

Before proceeding I suggest that you read this short, very short article by Jeff Moden. (It hopefully will assist you in increasing your understanding of your problem)

http://www.sqlservercentral.com/articles/IsNumeric/71512/

You may want to look at the procedure (in the Master DB) titled

[sys].[sp_MSforeachtable].

Review the T-SQL to determine if it will perform as you want it to, or if it does...

Believe what you may be looking for is the MERGE statement. For a discussion and example of how it works:

http://www.simple-talk.com/sql/learn-sql-server/the-merge-statement-in-sql-server-2008/

If you would/could post the table definition, some sample data...

Thanks ... I needed a laugh today

Not meaning any disrespect .. but use GOOGLE it returned

About 3,450,000,000 results when I used it.

here is one site that may be of use to you.

To help those who want to, and can help you please define the tables, and provide some sample data.

To do this please click on the first link in my signature...

okbangas

My explanation might not be 100% accurate, but this is indeed the documentation I found when I ran into the issue demonstrated in the question. That it indeed may work...

If you can NOT use the suggestion of opc.three

Read the following article by Jeff Moden:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Thanks .. nice clear question about something I needed to learn ...

Now my question to you: Is the company sponsored employee & spouse/partner formal dinner and dance, a benefit enjoyed...

Depending upon your exact needs, you could try the Express Edition, available as a free download.

http://msdn.microsoft.com/en-us/evalcenter/hh230763.aspx

or download a trial copy at:

http://www.microsoft.com/en-us/sqlserver/get-sql-server/try-it.aspx