ChrisM@Work (6/13/2016)

---

Y.B. (6/13/2016)

---

Maybe something like this would be better suited...

IF EXISTS (SELECT 1 FROM SomeTable WHERE ID = @id)

UPDATE SomeTable SET SomeText = @SomeText

ELSE

INSERT INTO SomeTable VALUES (@ID, @SomeText)

EDIT: Although...

This is a scary idea. I'm not sure that letting people modify the schema.

That being said, it could be done by using a trigger and dynamic SQL.

As I'm against this...

It seems like you're looking for the syntax from this example.

CREATE TABLE TableA( id int identity, value varchar(100), somedate datetime DEFAULT GETDATE());

INSERT INTO TableA(value) SELECT 'One Value';

CREATE TABLE TableB( id...

Use the conditional.

TOKEN( @[User::AgeBucket],"-",1) == @[User::AgeBucket] ? TOKEN( @[User::AgeBucket],"+",1) : TOKEN( @[User::AgeBucket],"-",1)

Chiefs

Are you aware of the TRUNCATE TABLE statement? It might be a better option if you're deleting all the rows in a table.

You could also use a derived column to insert a default value to those columns.

kevin 26531 (6/10/2016)

---

Thanks Chris but it's a dynamic query. There could be 10 columns (after the pivot) or 100 so I can't hardcode fields into the script.

Had thought about...

Brandie Tarvin (6/10/2016)

---

I'm going to say Yes only because DB Mail is incredibly...

The title was a big hint. I just had to make sure it wasn't misleading. 😀

Yes.

Import/Export wizard

SSIS Packages

I'll just leave this here. Be sure to understand the solutions or you'll have lots of trouble maintaining them.

You might want to read the following articles:

http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/Crosstab/65048/

DECLARE @sales TABLE(

...

patrickmcginnis59 10839 (6/9/2016)

---

I don't understand, if you don't care if its right, and additionally the applicant can apply zero thought to it and its still acceptable, whats the takeaway for...

There's no way to know if it changed from 3 to 2 or from 2 to 3. There's no way to define the order in that table.

SQLUSERMAN (6/9/2016)

---

I have unpivot the table and although the result is getting close to what I need, it is still not what I want.

Below is the query I've used, please...