Maybe they're talking about something like this:

EXEC sp_addextendedproperty

@name = N'Description', @value = 'ICD 10 code type',

@level0type = N'Schema', @level0name = 'dbo',

@level1type = N'Table', @level1name = 'CODE_MAP_IN',

@level2type = N'Column',...

This should help:

https://msdn.microsoft.com/en-us/library/ms189773.aspx

Unless what you're looking for is the UNION ALL or UNPIVOT.

For better help, read the article linked in my signature.

If you're sure that there won't be any missing/duplicate entries (two consecutive enroll dates without disenroll dates or viceversa), this can do the trick.

WITH cte AS(

SELECT...

I was going to provide an alternative using LAG, but I didn't want to spend much time testing and guessing the exact requirements. Especially with those offsets.

WITH

te_basis AS

(

...

Is your csv separated by tabs? If not, you should correct the format file accordingly.

Are the files (csv and format file) located in the server? You're using local paths which...

Can you post what you're doing?

This doesn't give an error.

DECLARE @cmd_bcp varchar(8000)

SET @cmd_bcp = 'bcp "SELECT BusinessEntityID, PersonType, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailPromotion, AdditionalContactInfo, Demographics, rowguid, ModifiedDate FROM...

What do you mean by "using @cmd_bcp to generate my BCP command"? Are you storing the command in a variable? Are you using the correct data type for the variable?...

What's the error/problem that you're having?

Are you assigning the correct data types in the wizard?

Today is the equivalent of April fools in Spain, Hispanic America and the Philippines. https://en.wikipedia.org/wiki/April_Fools%27_Day#Comparable_prank_days

It seems like your code can be rewritten like this

SELECT *

FROM TblMain m

Where EXISTS ( SELECT 1

...

Eric M Russell (12/28/2015)

---

TheSQLGuru (12/28/2015)

---

Ooh, another thing I will chime in with. Some of the WORST things I see done on SQL Server have nothing to do with the databases/applications...

A small correction from Eirikur's code and two additional options.

SELECT

SI.invno

FROM dbo.TBL_SALES_ITEMS SI

WHERE SI.SIC IN ('111','222')

GROUP BY SI.invno

HAVING COUNT( DISTINCT SI.SIC) = 2;...

Either use the "Allow multiple values" option in SSRS. Link

Or use the DelimitedSplit8k in your query. Link[/url]

Shouldn't it be like this?

SELECT COUNT(*)

FROM dbo.G_MASTER_CODING_RESULTS AS mcrWITH (NOLOCK)

WHERE mcr.REVIEW_TYPE = 'A'

AND MCRNUS.Col_A <> 96

AND MCRNUS.Col_B <> 100

AND MCRNUS.Col_C <> 100

AND MCRNUS.Col_D <> 100

Be aware that an identity column might have gaps, so you might need to create an artificial key.

Something like this:

WITH cteLog AS(

SELECT ROW_NUMBER() OVER(ORDER BY SNum...