Viewing 15 posts - 18,586 through 18,600 (of 26,489 total)
Roy Ernest (10/28/2009)
October 28, 2009 at 1:38 pm
foxjazz-962651 (10/28/2009)
I figured out a way around it.
Okay, since you did ask for help, care to enlighten us with your solution? Others may benefit.
October 28, 2009 at 1:12 pm
Make the following changes to the code I provided:
set @incode = '%' + 'B01' + '%'
--set @incode = '%' + (select top 1 code from anotherTable where USERID=@PersonId) + '%'
October 28, 2009 at 12:59 pm
Garadin (10/28/2009)
CooLDBA (10/28/2009)
There is no trigger.I figure out.
Thanks for replying.
And.... what did you figure out?
Agreed. Forum etiquette says you should post any resolution you come up with if you...
October 28, 2009 at 12:55 pm
You may want to spend a little time reading about sp_executesql in BOL (Books Online). Based on the example there this is the code I came up with, but...
October 28, 2009 at 12:46 pm
Need to ask why? Presentation of datetime values should be handled by the UI.
October 28, 2009 at 12:35 pm
Is there a trigger on the dbo.Lead table that may be causing a rollback of the transaction? Are you getting any kind of error message?
October 28, 2009 at 10:15 am
Flo,
You indicated that this is an x86 version (32-bit) of SQL Server 2005 and that PAE is enabled on the OS, is AWE enabled for SQL Server 2005?
Is the server...
October 28, 2009 at 9:50 am
robin-892784 (10/28/2009)
This restore does drop the old DB and restores the new one...unfortunately I can't alter the restore method.
I have to ask, but why can't you modify the restore method?...
October 28, 2009 at 9:46 am
Gift Peddie (10/27/2009)
That is very good example but you will find most T-SQL developers write the old one even in SQL Server 2005 and 2008 and SQL Server in most...
October 27, 2009 at 4:36 pm
Gift Peddie (10/27/2009)
Only with regard to INNER JOINs. The old style OUTER JOINs are not supported in SQL Server 2005 and later (compatibility mode 90 and >).
I am not talking...
October 27, 2009 at 3:19 pm
Gift Peddie (10/27/2009)
I had a multi-table query with a left join against some of the tables, one table in particular was not referenced (yet) in the select nor in...
October 27, 2009 at 2:58 pm
I have to agree that experience is extremely helpful. You learn about things that you may not have known about otherwise. I have experience in computer operations, systems...
October 27, 2009 at 2:56 pm
Alvin Ramard (10/27/2009)
Jack Corbett (10/27/2009)
October 27, 2009 at 2:33 pm
J-F Bergeron (10/27/2009)
October 27, 2009 at 2:32 pm
Viewing 15 posts - 18,586 through 18,600 (of 26,489 total)