Now he's got one more .

Oh you want it fast to!!!!!!!!!

Short of completely changing the design of the table (which seems it might be a good idea here?!?) :

create table dbo.Test1 (refNo varchar(10) primary...

Just to add to my post count and assuming that the sort must be numerical.

create

table dbo.Test1 (refNo...

Question answered here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=303903

Question answered here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=303903

This is what he means ­­>>>

SELECT 'DROP PROCEDURE ' + sp.NAME As DropNames

FROM sys.procedures sp,sys.Tables tb

WHERE LEFT(sp.NAME,CHARINDEX('_',sp.Name)-1)=tb.Name

AND LEFT(sp.NAME,CHARINDEX('_',sp.Name)) not like ''

AND sp.Name like 'Agreements_Delete'

ORDER BY sp.Name

Run this query, the results...

To add to this.. The only way to run procs at the same time is to create another connection and have that connection run the next proc...

Unless yukon figured out...

Also, it is the new norm in the sql world.   Not to mention that it's much less confusing... both for developpers and the server himself.

Something like this :

Declare @Today as datetime

--strip the time from the date

SET @Today = DATEADD(D, 0, DATEDIFF(D, 0, Getdate()))

select * from tblusers where date_added >= DATEADD(m, -6, @Today) and date_added <=...

Why not call functions like you would do in a vb or vb net application?

Pretty much all solutions are better than goto (except for err handling).

This is not a risk I would take for such a simple search operation.  The risk of sql injection is too high to save a few ms (assuming some are...

Well first of all that solution doesn't work.  Here's the working version :

SELECT   RTRIM(surname) + ', ' + RTRIM(forename) AS [full_name]

             ,company_name

FROM      pfo_both_people_search

WHERE    surname = isnull(@surname, surname)

AND        forename = isnull(@forename,...

OR you could always write 2 different stored procs and call the correct depending on the parameter value.   That also guarantees to always have to optimal plan for the query.

How do you scan this table to recreate the history of a row(s)? Or to rollback a group of transaction?

A solution to this problem has already been created on this site.  Search the script section with the keywords triggers and (generated, concatenated... sorry don't remember the name).

Basically it's a script that...