if the datatype is vachar, then it will concatenate instead of addition.

you'll most likely have to explicitly convert to decimal, or money:

select convert(money,'77.41') + convert(money,'4')

if this is a column of...

CoreFTPsupports Sftp and other secure ftp types, and can be scripted and. Called via a command line or Process.Start in. Net.

Ive got it in place for a regular batch process....

it's not horrible to do, i've thrown some time at it a couple of times, and a simple search can find you someone elses script they already wrote to change...

i think you want to use the TO_CHAR function on the oracle side...something like this, depending ont he desired format:(what is the timestamp(6) expected value? does it include TIME?)

SELECT TO_CHAR(DATE_VALUE,'YYYYMMDD')...

statistics auto update when a count of rows equal to 20 percent of a total rows have changed.

on small tables, that s fine, but on large tables, say a million...

yeah, you have to change the collation of each individual column that is char/nchar/varchar/nvarchar as a seperate suite of steps...man it's a lot of work, especially when some of the...

if the integer was something like 40891, we could infer that it was 40891 days since the beginning of SQL time, which would, by coincidence, be today (12/16/2011.

without a frame...

that's normal, because you most likely have a group the user belongs to as a login into the database; it might even be an admin group.

try either ofg these two...

if you wanted something like elapsed time, you really have to do it between two dates, and not from an integer...the elapsed number of months depends on whether the month...

the DATEADD function can do this...adding those 366 days to a desired starting date...by default SQL is 1900-01-01, soe something liek this will return the following:

--returns 1901-01-02 00:00:00.000

SELECT DATEADD(dd,366,0)--same as...

Adding the moon thing came about with the question "when is the next...

here's a copy of mine named TallyCalendar, which generates dates from the SQL beginning of time (1900-0101) to 100 years in the future compared to today.

the advantage is i've added...

at least for US data, Here's a copy of one of mine; 42K zip codes, mapped to Cty/County/State;

CITYDATA_INSERTS.txt

populating city/county/state if you know the zip is no problem, but

if you...

durai nagarajan (12/16/2011)

---

Hello,

are you firing a Stored Procedure or query?

Kindly try the SP or query with the parameter directly on database and check. if the problem is there in DB...

yep, here's a proof of concepty suite of scripts to test with; worked fine for me:

create login ClarkKent with password = 'NotARealpassword'

EXEC master..sp_addsrvrolemember @loginame = N'ClarkKent', @rolename = N'dbcreator'

EXECUTE AS...