Viewing 15 posts - 2,416 through 2,430 (of 2,452 total)
try this
'LC' + CAST(CAST(RIGHT (RTRIM(ID), 3) AS INT) + CAST(LEFT (LTRIM(ID), 3) AS INT) AS char)
please follow the advice in the link below ... you will get faster and more...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2009 at 5:44 pm
John Rowan (8/5/2009)
How are you handling when more than one column's value is updated?
I am interested in this as well...I import files where potentially any one (or many) of 40...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2009 at 5:06 pm
Hi
as long as data length is as provided:
'A' + CAST(CAST(LEFT("yourdata", 3) AS int) + CAST(SUBSTRING("yourdata", 5, 3) AS int) AS char)
regards Graham
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2009 at 4:40 pm
Howdy Wayne
without any more info its really hard to provide an answer
but maybe that GROUP BY and SUM (use BOL) will assist
you may find that if you follow the advice...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2009 at 12:55 pm
Hi Hugh
you may find that if you follow the advice in the link below that you get faster amd more detailed response...paritcularly if you provide example of what you expect...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2009 at 12:47 pm
Patrick...stumbled across this...may be worth a look at the Word docs
http://www.sqlservercentral.com/Forums/FindPost765551.aspx
regards gah
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2009 at 10:00 am
Bob Hovious (8/5/2009)
Hmmmm party encounters a Spamming Troll...Roll 3xd10 for saving throws against annoying misspellings....
Wizard casts Ancient Programming Languages...
Elf has shot the food!
xyzzy 😀
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2009 at 9:39 am
Patrick.I (8/5/2009)
Gah,I was thinking about this method already if i decide not to use SSIS. 🙁
By the way my records could be over half a million records.
Hi Patrick...I do use...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2009 at 8:39 am
Hi Patrick
not knowing the volumes of data you have, the following method may not be appropriate, but this is one method I use to import up to 30K records into...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2009 at 5:07 am
You really ought to read the advice given here
http://www.sqlservercentral.com/articles/Best+Practices/61537/
if you follow this advice then i am sure that you will get more response and answers that provide tested code.
Because I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 4, 2009 at 7:29 am
Since earlier post I have been searching this site for something that better meets my personal requirements and have come up with the following...you find this useful
USE tempdb
GO
--===== If the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 3, 2009 at 6:55 am
I am not sure that I fully understand the question without seeing the data and the expected results....however I have done something similar in the past which may provide you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 3, 2009 at 3:35 am
try this
http://www.aspfree.com/c/a/Microsoft-Access/On-Using-Passthrough-Queries-in-MS-Access/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 9, 2009 at 1:18 pm
jrw39 (7/8/2009)
I connect in Access 07 to a data warehouse using ODBC.
I have linked tables from access db to SQL Server.
I need to be able to copy or...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 8, 2009 at 3:30 pm
How are you connecting Access 07 to SQL 2005?
Are you using an Access Project (ADP) or are you using linked tables to SQL?
regards graham
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 8, 2009 at 2:23 pm
Viewing 15 posts - 2,416 through 2,430 (of 2,452 total)