SQL-DBA-01 (8/1/2016)

---

Strange. I selected the right answer but I declared me that my choice was wrong!

SELECT SERVERPROPERTY('productversion') as ProductVersion, SERVERPROPERTY('productlevel') as ProductLevel, SERVERPROPERTY('edition') as Edition, SERVERPROPERTY('ProductMajorVersion') as ProductMajorVersion, SERVERPROPERTY('ProductMinorVersion') as...

Given that your reply...

Use the SSIS syntax.

DATEADD("dd", DATEDIFF("dd", (DT_DATE) "1900-01-01", GETDATE()) - 1, (DT_DATE) "1900-01-01")

Have you tried using SSIS? It's great for this sort of things.

tskelley (8/1/2016)

---

Yes, and thank for your pointing out the sarcasm. I have removed it from my reply. I was a little frustrated on this one, and found the...

Maybe like this? Why do you have different validations for names and other values?

UPDATE [MEMBER].[IMP_MEMBER_INT]

SET

[ContactLastName] = CASE WHEN LEN(LNAME) >...

To do what you're asking for, you need to split the values and store them in individual rows. Of course, you can split them and join them again in a...

You don't have a Code column in your derived table (subquery). Either you add it to the query or remove it from the join clause.

Here's probably the best option for versions 2014 or lower: https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/

Although, my suggestions would be to stop storing JSON in SQL Server and normalize the data.

In SQL Server 2016 there's...

The lack of mention of the Service Pack when querying @@Version might not be a bug from 2014, but one depending on the way it was installed.

My local installation of...

You know? Sarcasm isn't a good idea when...

It's working as designed. If you try to concatenate a string with a NULL value, the result will be a NULL value.

Check the following example:

SELECT field,

field...

Since Lowell already posted something, I'll just post the short version.

update Table1

SET Field1 = ISNULL( @Field1, Field1),

Field2 = ISNULL( @Field2, Field2),

Field3...

ChrisM@Work (7/29/2016)

---

Sean Lange (7/29/2016)

---

ChrisM@Work (7/29/2016)

---

It's Friday, you can get anything you...

DEEPAK GUPTA-378433 (7/29/2016)

---

Hello All

How could I use Column for Table1 within subquery. I know this is not possible but there should be a nice way to achieve this.

SELECT *

FROM Table1...