gvdamn (11/2/2010)

---

Hi Maxim,

Thanks for your reply.

To be honest: I'm not familiar with multi value parameters. Do you have any good (web) references?

How is it going to work out with ADO?...

Hi gvdam

You could pass all 100 dates to your proc as a multi value parameters, join with your stock price table and return all the rows in one call.

There are...

Thank you, I knew there was something

Very nice article

My pleasure, we all get caught by the absorbing nature of the NULL at some point! 😉

Hi black,

You want to...

Hi Mike

Is it possible that @compname has a NULL value?

If you concatenate a NULL to a string the string = NULL.

Try something like

SELECT 'my string' + 'my other string'

SELECT...

Hi

One way to do this is using osql.exe

http://msdn.microsoft.com/fr-fr/library/ms162806.aspx

Create a .cmd file with your osql commands, in this case one command per database/server

osql -Syourserver -dyourdb -E -icommand.sql -oOUTPUTFIL.txt

Create the command.sql file...

This should be in SQL Server 2008 forum.

This was resolved on the MSDN forum:

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/5968e421-c387-4e91-921c-7e9b1f3d1c90

http://support.microsoft.com/kb/955726

Hello YTZ

The desynchronization between the user SID and the login SID happens after the restore because the SID are server specific.

Use this script to display desynchronized users

SELECT

sysusers.sid,

sysusers.name,

syslogins.sid,

syslogins.name,

*

FROM

sysusers

INNER...

Very inspiring story, all the best to Josef and his family

... another vote for NCHAR(1)...

Excellent thread 🙂

Hi

How exactly did you retrieve your index list?

Using sp_helpindex or sys.sysindexes?

You will find stats in sys.sysindexes but sp_helpindex returns only indexes.

Hi

I understand you still have the dev's computer?

Try login on his machine with a local administrator and access the database with Windows Authentication. Default installation have the group BUILTIN\administrators...

You can find two excellent articles from Jeff Moden on cross tabs and pivots here that should help you tackle this challenge.

Cross Tabs and Pivots, Part 1 – Converting...