Viewing 15 posts - 691 through 705 (of 3,666 total)
jpserra3 (6/10/2015)
Have i stated a problem that no-one has seen? does this screen (Review Data Type Mapping screen) show up for everyone else?
Well, I never use the wizard, and...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 1:06 pm
See if this works:
Street1: SUBSTRING(Street,1,50 - FINDSTRING(" ",REVERSE(SUBSTRING(Street,1,50)),1))
Street2: SUBSTRING(Street,LEN(Street1) + 1, 50 - FINDSTRING(" ",REVERSE(SUBSTRING(Street,LEN(Street1) + 1,50)),1))
Street3: SUBSTRING(Street,LEN(Street1) + LEN(Street2) + 1, 50 - FINDSTRING(" ",REVERSE(SUBSTRING(Street,LEN(Street2) + 1,50)),1))
This...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 1:03 pm
The syntax I posted is all SQL. If I'm not mistaken, FINDSTRING might be what you need to use instead of CHARINDEX in SSIS expressions.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 12:43 pm
W4Designs (6/10/2015)
My supervisor-imposed requirement is that I NOT use SQL to do the conversion and to use some alternative method inside the package. Obviously SQL is the most simple...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 12:27 pm
If #Temp2 had a RowNumber column, with values that reset to 1 for each grouping, then in your update statement, you can add the join on the row number to...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 11:59 am
You could try something like the code below, in the query that extracts the data from your source table.
SELECT
CHARINDEX( ' ',REVERSE(yourAddressField), 1),
Street1 = SUBSTRING(yourAddressField, 1, 50 - CHARINDEX(...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 11:54 am
I'll have a solution for doing did in the SQL query after I come back from lunch.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 10:45 am
All the records of #Temp2 were updated when I ran your scripts.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 9:47 am
Eugene Elutin (6/10/2015)
I would suggest to do exactly that.
Store data in the database table as supposed to; report/display it as you wish (comma separated...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 8:45 am
I hope this is a homework question. I have trouble imagining the data presented as realistic.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 7:50 am
David Burrows (6/10/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 7:44 am
Eric M Russell (6/9/2015)
Alvin Ramard (6/9/2015)
Matt Miller (#4) (6/9/2015)
Clearly have a profile on LinkedIn, but making massive changes and/or listing yourself as looking for work...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 9, 2015 at 3:42 pm
ricardo_chicas (6/9/2015)
I have a 50gb database, with 3 files at the primary filegroup, each one of those has around 16gb
I truncated 2 tables releasing 33gb, so the database should...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 9, 2015 at 3:40 pm
Matt Miller (#4) (6/9/2015)
Clearly have a profile on LinkedIn, but making massive changes and/or listing yourself as looking for work in this scenario might cause...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 9, 2015 at 3:29 pm
sharonsql2013 (6/9/2015)
If we need to calculate the Percentage of Closed Purchase Orders .
Does that mean we need to implement like this ?
SUM(of Purchase...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 9, 2015 at 2:58 pm
Viewing 15 posts - 691 through 705 (of 3,666 total)