Why there must be a dot at the end of any sentence?

Why you must start a sentence with a capital letter?

There were couple of articles about "Reading Windows registry from SQL server".

Run search with these keywords, you'll find out some of them.

This one, for example:

http://www.sqlservercentral.com/columnists/dasanka/workingwiththeregistry.asp

Values of what datatype you are talking about?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=235917

Your script is not right.

It will select lines for Client1 with Date1 not latest for this client but latest for Client2.

You must use INNER JOIN instead:

CREATE VIEW [dbo].[pools_free_view]

AS

SELECT CP.client_name, CP.date_ran,...

...

FROM    #ValidAssignments

        INNER JOIN TM_ASSN_Assignment

                on      assn_ids = ASSN_ID

        INNER JOIN TM_ASNA_AssignmentAsset

                ON      ASNA_FK_ASSN_ID = ASSN_ID

 INNER JOIN TD_RECV_Recovery

                ON      RECV_FK_ASST_ID = ASNA_FK_ASSN_ID

                        AND RECV_Date Between @DateStart AND...

Do users write SQL script from screen?

I don't think so.

So, there is a set of possible parts of SQL statements recorded in the application code. Application just picks some of...

noelson, did you read my post?

It's not 1st charachter, it's CR after the name!

Look there:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=235408

If it's you are looking for?

I don't understand the problem.

I tried this:

Create TABLE #MyTable (

 myID INT,

 MyDesc VARCHAR(10),

 CONSTRAINT PK_MyTable_1 PRIMARY KEY CLUSTERED (Myid DESC)

  )

INSERT #MyTable

SELECT 5, 'DESC5' UNION

SELECT 3, 'DESC3' UNION

SELECT 1, 'DESC1' UNION

SELECT 4,...

If you never drop temporary tables within SP?

And if yes are you sure you'll never do?

Same question about "Delete" and "Truncate".

And are you sure "Drop table" is more dangerous than...

For some reason people prefer to use slow and not reliable (locale dependable - will not work with $12,050.25) solutions and ignore proper ones.

Better to have computed column with UDF inside. You will not have to worry about background programs.

<

Would it be recommended to create a second index on Table2 for CustNo only?

>

Yes, definetely. MUST BE.

Otherwise Server will effectively find required line from PK table and than go...

If your client is stupid it does not mean you must follow his stupidity.

Create standard IDENTITY column and write a function to convert integers into required code. Create computed column...