Viewing 15 posts - 12,166 through 12,180 (of 13,469 total)
just to be sure, can you exec sp_help History and also exec sp_help LM_Date1 so we can be sure the columns H.Paid_Date and LM_Date1.Paid_Date are both datetime?
January 18, 2008 at 8:09 am
We recently upgraded, but we did not do it the way you described.
we brought up a new server, and made sure it had access to the san.
depending on the database,...
January 18, 2008 at 7:53 am
the only way i see that happening is if the columns with the date is being treated as a varchar...but you said you were sure the fields were datetime data...
January 18, 2008 at 7:47 am
i think it's because the script was generated in compatibility 90 syntax, but you are creating the table in V80:
i think this part is not 80 compatible on line 35...
January 18, 2008 at 7:34 am
Without more details, I'd build a prototype job that looked something like this:
IF EXISTS(SELECT STATUS FROM SOMETABLE WHERE STATUS='READY')
BEGIN
SET XACT_ABORT ON
...
January 17, 2008 at 10:17 am
Karthika Raman (1/17/2008)
January 17, 2008 at 9:09 am
i put to gether the table and data, but didn't have time to continue; this might help in the analysis:
create table #SpreadSheet(
Zip varchar(9),
City ...
January 17, 2008 at 8:38 am
see this page for someone else who had the same issue:
http://www.sqlservercentral.com/Forums/Topic419269-146-3.aspx
January 16, 2008 at 8:42 am
there is a function called Propercase in the script contributions section.
with that function installed, you could then simply do an update:
UPDATE SomeTable
SET NameColumn = dbo.Propercase(NameColumn)
Proper Case A String Or...
January 16, 2008 at 8:34 am
we had to maintain level 80 compatibility for a while;
tracing the application, we found that some sql statements which you could get away with in 80 fail in 90;
specifically it...
January 15, 2008 at 9:49 pm
a function is a special, more limited type of stored procedure. it is specialized, so it has more limitations.
here's some high points, but there's a lot of infor to google...
January 11, 2008 at 8:11 am
select * from sysindexes where name like '_Wa_Sys%' in sql 2000 or 2005.
SQL server collects statistics on every query you run....those statistics can be used to determine whether a...
January 11, 2008 at 7:47 am
I'm properly chastized for talking without testing...
my answer is appropraite for WHERE statements, but not a replace...
LIKE '%%%%' would be where a percent sign exists in the data, for example.
January 10, 2008 at 3:51 pm
two of the same character in a row is the escape for any special character in sql:brackets, percents, single quotes, etc.
replace(somecolumn,'%%','') to get rid of a percent sign, if it...
January 10, 2008 at 3:45 pm
maybe i read your attachment too quickly, but i didn't see a worksheet with the data, only the sheet with the column definitions.
if there was a worksheet with just data...
January 10, 2008 at 1:39 pm
Viewing 15 posts - 12,166 through 12,180 (of 13,469 total)