Does [ACTUAL END DATE] exist in the spreadsheet? It looks as if you are creating it in the select statement "NULL as [ACTUAL END DATE] " and trying to...

1enter

2..

3..

now here no tab delimiter is there .. now i need a script that can import a 1st column into serverDB even if the txt file contains one column or...

Is the SQL Server Service running? Can you connect with Enterprise Mananger or Query Analyzer? Are you trying to connect via IP address or name?

Do you have both operating systems running simultaneously?

why not just add else '0'

SELECT

CASE

WHEN DATEDIFF(dd, AsOfDate, GETDATE()) BETWEEN 1 AND 30 THEN '1-30'

WHEN DATEDIFF(dd,...

You can do it in an activex script in a DTS package like this:

Function Main()

Set socket = CreateObject("MSXML2.ServerXMLHTTP.4.0")

socket.setTimeouts 300000, 300000, 350000, 350000

...

Thanks Matt, I had to add a couple of tweaks to get the starting minute and round the duration up but it seems to work well.

dateadd(second,-datepart(second,startd),dateadd(ms,-datepart(ms,startd),dateadd(minute,N-1,startd))) evttimemarker

where tally.n<events.duration+1

Banter enough and learn something new. I always thought that the calculated field would still take up space in the database. That said, I guess a datetime will...

Oh , but we have those reports based on actual date fields. The app records the sent date as it sends the emails. This one holds the displayed respond...

I think the developers are working on that. It has been that way since the last upgrade. If you paste them into ms word and then into QA they...

These are email campaign tables so they only get used once. The app has to have the date formatted for display since it doesn't have tha ability to format...

Thanks Jeff. It cetainly is shorter and looks nicer in my create table sp.

Thanks, I found the datename function in one of Phil Factor's articles and came up with this:

DATENAME(month,dateadd(dd,14,getdate())) + ' ' + datename(day,dateadd(dd,14,getdate())) + ', ' + datename(year,dateadd(dd,14,getdate()))

so anywhere there is a missing weekday defines the new interval?

what is the interval? The first one you have starts on Friday and ends on Tuesday , The second is just THursday and the next one starts on Monday...