Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
daniel.newman@bis-web.net
Yak Posting Veteran
71 Posts |
 Posted - 2001-05-24 : 11:10:58
|
| Someone's going to have to point me in the right direction here, as i'm totally miffed.I'm creating a temporary table, and then filling it with possibly three queries. These all just pull data from other tables to populate my temp table.Here's my code so far:SET DATEFORMAT mdy CREATE TABLE #FulltextSearch ( Code varchar(10), Title varchar(255), Summary varchar(4000), ReleaseDate datetime, AppearanceDate datetime, Rank int )IF (@TitleTerms IS NOT NULL)BEGIN -- Insert all those with these search terms in the Title INSERT #FulltextSearch (Code, Title, Summary, ReleaseDate, AppearanceDate, Rank) SELECT Main.Code, Main.Title, Main.ReleaseDate, Main.AppearanceDate, Summ.Summary, Search.[Rank] FROM PressReleases Main INNER JOIN SummaryText Summ ON Summ.Code = Main.Code INNER JOIN FREETEXTTABLE(PressReleases, Title, @TitleTerms) AS Search ON Main.Code = Search.[KEY]The problem I'm getting is with the datetime columns on my tables. The columns fro the original tables are in fact datetime columns, so why should I be getting a "Syntax error converting datetime from character string", when they're clearly not character strings?Anyone know how I can fix this, as I need those dates in the temp table?If you're not clear on anything, just ask.Thanks, Daniel. |
|
|
|
|
|
|
|
What the hell's going on here then?