Viewing 15 posts - 3,616 through 3,630 (of 8,731 total)
It basically adds a value to the Description property of the column. It changes only the metadata of the column for documentation purposes. You could also do it using the...
December 29, 2015 at 1:22 pm
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',...
December 29, 2015 at 1:01 pm
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.
December 29, 2015 at 12:55 pm
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...
December 29, 2015 at 8:51 am
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
(
...
December 29, 2015 at 8:08 am
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...
December 28, 2015 at 2:30 pm
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...
December 28, 2015 at 2:09 pm
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?...
December 28, 2015 at 1:35 pm
What's the error/problem that you're having?
Are you assigning the correct data types in the wizard?
December 28, 2015 at 10:59 am
Lee Nadelman (12/28/2015)
An April Fools joke on Christmas certainly goes against the spirit of the season.
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
December 28, 2015 at 10:50 am
It seems like your code can be rewritten like this
SELECT *
FROM TblMain m
Where EXISTS ( SELECT 1
...
December 28, 2015 at 10:24 am
Eric M Russell (12/28/2015)
TheSQLGuru (12/28/2015)
December 28, 2015 at 9:55 am
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;...
December 28, 2015 at 9:31 am
Either use the "Allow multiple values" option in SSRS. Link
December 28, 2015 at 9:21 am
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
December 28, 2015 at 9:18 am
Viewing 15 posts - 3,616 through 3,630 (of 8,731 total)