Viewing 15 posts - 256 through 270 (of 1,183 total)
If you MUST use the table structure defined above then you'll need something to define a unique record (PK)
I've added it for demonstration purposes.
DECLARE @CH TABLE
(nDex...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 27, 2011 at 7:10 am
Please post what you've tried already. 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 26, 2011 at 7:44 am
Only a slight bit more "bulky" ...
DECLARE @test-2 TABLE
(
id INT IDENTITY(1, 1),
string_with_date VARCHAR(100)
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 21, 2011 at 10:53 am
I would suggest, use UNPIVOT in your query/proc along with your normal data collection to add in the string combination of your values. Search this site, there are many examples....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 21, 2011 at 10:02 am
Faye Fouladi (7/21/2011)
this problem was posted long time ago. I no longer work on this project, therefore, I cannot test it.
You mean you don't work on the same issue for...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 21, 2011 at 8:35 am
I know this is NOT addressing your problem, but in case you didn't already know about this nifty tool from MS. If you're just planning on synching them once in...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 21, 2011 at 7:16 am
A Soft Delete would be the case if your records had a column that defined the state of the record. i.e. an isActive bit column or an endDate column. Something...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 20, 2011 at 8:24 am
M10.May10_Ad4 is repeated twice?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 20, 2011 at 8:19 am
Krasavita
Please check the article linked in my signature to get better responses from user on this site.
Please define "Not Working Properly"
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 20, 2011 at 8:17 am
That really depends on your system. Do you have the ability to "soft delete" or mark records inactive. How are these records tied to other data? Will you be creating...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 20, 2011 at 7:58 am
Pardon me for stepping in here, but going directly to '08 is a bigger can of worms than going to SP4. :hehe:
EDIT: Not that it's a bad idea, just more...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 20, 2011 at 7:51 am
Try this 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 20, 2011 at 7:47 am
Since you want columns not included in the MIN function, you'll need to use a subquery to get those min values by material ID then join to that to get...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 20, 2011 at 7:22 am
bopeavy (7/19/2011)
That at least helps give some sort of direction, Thanks.
It may have but what opc provide will help me see the pattern yours was alittle harder to...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 19, 2011 at 12:11 pm
Am I wrong or doesn't my "solution" above find these patterns?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 19, 2011 at 11:46 am
Viewing 15 posts - 256 through 270 (of 1,183 total)