Viewing 15 posts - 31 through 45 (of 52 total)
Yes, but I think I have not placed my question properly.
The vehicle will send every minute data, so if i group by vehicle , i will get each and every...
September 16, 2008 at 3:52 am
first thanks for reply and secondly i would like my answer as below
ABC ...
September 16, 2008 at 3:34 am
Thanks Grant for the reply.
Actually the reason I did not put the whole code was the number of fields in each table.
Yes as you rightly said, there is no...
September 10, 2008 at 6:37 am
Thank u All,
The delay was becuase we had to call another stored procedure in the way to insert.
Bulkcopy to do insertion was not the culprit.
Many Thanks
Regards
Hema
September 2, 2008 at 6:56 am
This is the way we make a bulkcopy
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(MyCon))
...
September 1, 2008 at 10:40 pm
Thanks for answering all the questions.
One last question, which one will act faster using like or using full text search
eg. I want to find employees whose name start from 'a'.
In...
August 6, 2008 at 6:08 am
Ok Marcus many thanks
Now suppose i have the words
where are you going
are they going
why are they going
Is it possible to find out the words which has ARE and GOING
If yes,...
August 6, 2008 at 4:58 am
Thanks Markus
And if possible can i know the answer to the second one
August 6, 2008 at 4:24 am
Thank You , It has been resolved
July 21, 2008 at 6:59 pm
Thanks, everything works, I got the result too, But it seems in one of the stored procedure, I am using a temporary table.
And may be there lies a glitch, how...
July 21, 2008 at 3:00 am
Unfortunately my output parameter will not return one single value, it will return some 20 rows, Of course i can put a coalesce and take in single row with a...
July 19, 2008 at 11:09 pm
I tried to use the ForEach Loop Container.
What I tried was created an Execute sql task and gave the stored procedure, the stored procedure is as below
alter procedure Return_TableNames
as
begin
select tablename1...
July 19, 2008 at 5:06 am
Meanwhile I attempted passing through command prompt as below
dtexec /file c:\package1.dtsx /Set \Package.Variables[tblname];gpsdata_history1
and this works
But I had one problem, in my stored procedure I had given
begin catch
...
July 18, 2008 at 11:01 pm
Thanks for the reply, Now I need one more help, I want to pass parameters to the stored procedures, How can I pass. Secondly I need one more advise.
I have...
July 18, 2008 at 4:30 am
Brilliant Swamy, thanks it works.
July 14, 2008 at 11:17 pm
Viewing 15 posts - 31 through 45 (of 52 total)