Viewing 15 posts - 1,606 through 1,620 (of 8,731 total)
You might want to take a look at this article.
http://www.sqlservercentral.com/articles/BCP+(Bulk+Copy+Program)/105867/
February 2, 2017 at 6:18 am
Something like this might help. There's no need to go row by row when you can do all projects at a time. You might want to consider dividing this into...
February 2, 2017 at 6:11 am
February 1, 2017 at 6:20 am
Come to...
February 1, 2017 at 6:19 am
Don't think i'm crazy 🙂 but i remember there was a known bug on sql...
January 31, 2017 at 9:47 am
How do you add a primary key to a function? That simply makes no sense.
Maybe you're talking about adding a primary key to a table variable inside a function....
January 30, 2017 at 8:04 am
I'm assuming that it's only one table with 4 different alias. It could be handled by a left join.
Select c1.personID
,c1.enrollmentID
,attributeID=case when c2.value...
January 26, 2017 at 1:26 pm
BIGINT (-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)) can store a...
January 26, 2017 at 10:05 am
ShawnBryan - Thursday, January 26, 2017 6:59 AMLuis Thanks It worked..
Great!
Do you understand why/how it worked?
January 26, 2017 at 7:02 am
You need to understand what you're doing with your GROUP BY clause. If you don't have the correct columns or expressions, you'll never arrive to the expected results.
[code...
January 26, 2017 at 6:29 am
Viewing 15 posts - 1,606 through 1,620 (of 8,731 total)