Database

http://www.codeproject.com/Messages/3447012/Re-Connecting-to-sql-server-files-error.aspx[^] Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Prolific encyclopedia fixture proof-reader browser patron addict? We all depend on the beast below.

Try using SCOPE_IDENTITY rather than IDENTITY - check BOL for the (significant) differences. Bob Ashfield Consultants Ltd

A stored proc (or any other sql query) returns zero for success and non-zero for an error Bob Ashfield Consultants Ltd

Thanks for the input, appreciated. The old SQL Server 7/2000 version generates the old VB/ASP code for calling a stored proc, though I haven't got round to changing it for the 2005/8 version as yet. I would be interested to see your code generation software. BillyTheKidney

Thank you so much , it;s worked like charming , However I added a little "END" word to the first statement , SELECT MAT, SUM(CASE TYPE WHEN 0 THEN Qty ELSE -Qty END) AS CurrentQty FROM MatTable GROUP BY Mat thank you , for you code , it's so simple and brilliant :) I know nothing , I know nothing ...

No problem. :) Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Prolific encyclopedia fixture proof-reader browser patron addict? We all depend on the beast below.

I am assuming you are using SQL 2005 or better. Firstly, you need to insert into the order table and get the order number by using scope_identity. Then use this to insert into the order details. The whole lot needs wrapping in a single transaction (clue - the bold words should be used for searching) Bob Ashfield Consultants Ltd

Free if you have Software Assurance, 7499$ per socket for the standard edition if you don't. It's not considered a service pack (like server 2008 R2 was not considered a service pack)

Ahh now I have to explain to my collegues why I am sitting here chuckling - quick, generic and pivot all in the same sentence. There is nothing quick or generic about pivot tables. I have an article[^] that uses dynamic sql to avoid the hard coding but it is not quick and generic. Never underestimate the power of human stupidity RAH

First and foremost, what user is going to sit there and wait for 30 minutes for the query to execute? I would spend my time optimising the query rather than worry about what happens WHEN the user closes the browser. Anyone who has a stored proc taking that amount of time to execute while a user sits waiting deserves any and all problems which they get from it. Bob Ashfield Consultants Ltd

That is a common practice, but in the previous example I assumed the questioner has no or little knoledge about aliases, therefore I followed a more explicit approach. :) I have no smart signature yet...

AlexeiXX3 wrote: Notice that the title may o may not have or may have more than 1 special character at the beggining The best I can think of is a UDF that uses the REPLACE function to strip those characters. You could add this on a separate view on the table, including the column only when needed- as it would be a very expensive operation (looping all characters for each record). It might be better (performance-wise) to store a redundant version of the Title, without any special characters. I are Troll :suss:

Problem is solved by adding full access permisions for 'MSSQLUser' user group to the file_path directory.

I got the solution for above issue Issue is we have a folder name called Reports in application and also we have same name virtual directory in IIS

You can make your stored procedure save same data in both the tables (two insert statements). BTW, why are you doing this? Don't you think it is weird?