I don't think you need to go to all the trouble of an SSIS package. Just make data connection direct to your uploaded csv (assuming is is Excel) or just...

Just saw the edit to your OP. I don't know what the best search phrases would be either, or even how to explain this process in 2-3 words. I am...

That certainly removes several of the "what ifs". I think I might approach it as a multi step (page) process. Have your upload page, this page would have your html...

Not sure which web technology you are using but this is going to be pretty challenging. Probably more difficult than it seems like it should be.

The challenge is that...

Only for significantly large values of 2. 😛

Well you say you want to convert but then you want to make it central time. I am a little confused.

Convert is used for presentation (which really belongs in the...

Are you just trying to format the UTCOccurrenceDateTime column?

llawws (1/11/2012)

---

when i am using bellow query i am getting problem.

select * from table --> no issue table result is showing.

where as when i use the column it was showing...

If you have to do this in a single query you are...

Can you post ddl (create table scripts), sample data (insert statements) and desired output? It is pretty tough to figure out what your data and queries look like.

Take a look...

emre.celik00 (1/10/2012)

---

Thanks for your reply.

I need to use with join.

Can I find Max value in Where clause?

or

like this

Left outer join table1 t on t.xyz= ........ and t.xyz is...

bill.akin (1/10/2012)

---

the following query

select member_number, date, time_in, time_out from member_time where time_out <='9:30 am' gives the following data

member_numberdatetime_intime_out

25501/9/20127:55:31 AM1:08:15 PM

25631/9/20127:55:59 AM4:30:00 PM

7551/9/20127:56:31 AM8:00:00 PM

22291/9/20128:00:00 AM9:00:00 AM

12651/9/20128:26:25 AM12:06:15 PM

24791/9/20128:33:10 AM12:02:37...

This might be a start...

declare @string varchar(100) = '20110101,glp,100.0,50.0,25.6 hgl,29.0,28.0 jlp, 30.0'

set @string = REPLACE(@string, ', ', ',')

select *

into #Results

from dbo.DelimitedSplit8K(@string, ' ')

--validate the initial load

--select * from #Results

declare...

js_0505 (1/10/2012)

---

I have a string that looks like the following:

20110101,glp,100.0,50.0,25.6 hgl,29.0,28.0 jlp, 30.0

how can i split via space and comma so i have the desired output into a sql table.

20110101...

Run DBCC USEROPTIONS on both servers. That will show you the dateformat.