Forum Replies Created
Viewing 15 posts - 31 through 45 (of 46 total)
-
RE: Select where one date must include others
I guess this is what I would call the difference between one who knows and one who doesn't !
Jean-Luc
www.corobori.com -
RE: Select where one date must include others
That is working fine. I need to go another step further (I tried !).
When running the select the result should be like this:
Funds, Subscriber, Date, Total Funds, Total...
Jean-Luc
www.corobori.com -
RE: Clearing connection before detachDB
Don't know if it's what you're looking for but since I originally posted this message I solved this problem by running the following code prior of detaching the db
Jean-Luc
www.corobori.com
RE: Retrieve default user database
Is this correct:
SELECT dbo.sysdatabases.name
FROM dbo.sysxlogins INNER JOIN
...
Jean-Luc
www.corobori.com
RE: Unable to load localized strings
Solved, I had to change my INI file for my language.
wz700: what is PSS ?
Jean-Luc
www.corobori.com
RE: Upsizing problem
Sorry the message was saying Overflow. I'll ask my client to see if it has the latest SP installed,
thanks
Jean-Luc
www.corobori.com
RE: osql and accents
Solved: from the Query Analyzer I had to save my .sql file into a Unicode file using the Save As and changing the File Format from ANSI...
Jean-Luc
www.corobori.com
RE: Update in SQL Server CE
quote:
From my understanding it should be. The parser is pretty much the same.
Actually the reason...
Jean-Luc
www.corobori.com
RE: Speeding up query
quote:
Have you checked the execution plan for this query.
Yes but I don't understand what it...
Jean-Luc
www.corobori.com
RE: How to retrieve the last comment
quote:
Is there a field taht is unique and even if two records have the same date time it will be incremented or...
Jean-Luc
www.corobori.com
RE: Join, Group by: can't have it right
It looks like its working.
Thanks
Jean-Luc
Jean-Luc
www.corobori.com
RE: Join, Group by: can't have it right
Just try the following code and you'll see my problem
create table News
(
News_Id int,
News_City int,
News_Date DateTime
primary key (News_Id, News_City)
)
go
create table City
(
...
Jean-Luc
www.corobori.com
Viewing 15 posts - 31 through 45 (of 46 total)