Viewing 15 posts - 1 through 15 (of 18 total)
Hi,
I don't understand the variable length computation. Why do you use the max aggregate and not the sum ?
Thanks
Patrick Duflot
February 19, 2009 at 4:07 am
I had the same problem but I don't remember how I fixed it 😀
It could be one of the following :
- Try using another protocol in the ODBC client configuration...
Patrick Duflot
March 26, 2008 at 7:09 am
That's right, changing server's collation is not appropriate in this case.
COLLATE DATABASE_DEFAULT worked fine for me.
Another solution could be to use a table object instead of a temporary table.
It looks...
Patrick Duflot
March 26, 2008 at 6:53 am
Aaaaaah DATABASE_DEFAULT that's what I needed 🙂
Many thanks Jonnie !
Patrick Duflot
March 18, 2008 at 3:05 am
It looks like there is a fourth collation level : server level.
So, yes, I know the problem is that the collation differs between the temporary table in the database table......
Patrick Duflot
March 17, 2008 at 8:32 am
Hi,
Be sure you apply 'WITH NO LOCK' on every table of your FROM clause...
On the other hand, I think you should first find which INSERT/UPDATE statement holds locks for such...
Patrick Duflot
March 17, 2008 at 3:06 am
Thanks for yout reply.
Yes, SQLGetDiagRec gives me the right error message. I cannot make the difference between an error and a warning with this information.
On the other hand, SQLGetDiagField with...
Patrick Duflot
May 11, 2007 at 1:25 am
Try this
SELECT MI.MainItems, '' AS Substitute, MI.Quantity
FROM MainItemsTable MI
UNION
SELECT MI.MainItems, SI.SubstituteItems AS Substitute, SI.Quantity
FROM MainItemsTable AS MI
INNER JOIN SubstituteItemsTable AS SI ON MI.MainItems = SI.MainItems
ORDER BY MainItems, Substitute
Patrick Duflot
April 8, 2005 at 9:03 am
I got quite the same. I also included year and day of year in the group by clause to work on more thant one day.
select ct.Location, ct.Name, datepart(year, startdate) as...
Patrick Duflot
April 7, 2005 at 9:25 am
Thank you very much for your reply, it really speeds up the query
Another question comes to my mind. If I need to return...
Patrick Duflot
March 11, 2005 at 2:11 am
This is what i was looking for. Thanks John.
There are a bunch of set options I am not aware of. I should have a...
Patrick Duflot
March 2, 2005 at 4:09 am
Here is the code of the sp. its goal is to linearly distribute positions across the range [0..INT_MAX[ while maintaining 25% free slots at the end of the range.
create procedure...
Patrick Duflot
March 1, 2005 at 1:14 am
Hi,
I tried to solve your problem as an exercise. don't know if it helps.
I image you could you the following schema
Table Employee : Id as Int, Name as char(50), Title...
Patrick Duflot
January 20, 2005 at 8:37 am
You can start SQLServer service with SQL DMO as in the following VB code.
Public Sub StartSQLService(MachineName as String)
Dim MySqlServer as SQLDMO.SQLServer
Set MySqlServer = New SQLDMO.SQLServer
MySqlServer.Start False,...
Patrick Duflot
November 18, 2004 at 2:15 am
I'll check that out
Thank you Markus
Patrick
Patrick Duflot
November 9, 2004 at 6:55 am
Viewing 15 posts - 1 through 15 (of 18 total)