as I understand it, the LIKE '%pattern%' will always require a tablescan, since parts of the string are not indexed.

if the pattern is 'pattern%', so the value always starts...

duplicate post.

no need to ask the same question in multiple forums, as the Recent Posts>>Posts Added Today

shows everything.

follow the thread and the answers already posted here:http://www.sqlservercentral.com/Forums/Topic728604-146-1.aspx

everyone is different, and you should use what is best for you. but here's some of the rules in out shop:

1. the primary key of each table is TableName+"ID". (one...

select convert(varchar(10),(dateadd(day, -1*day(dateadd(month, 0 ,getdate())),dateadd(month, 0 , getdate()))),101)

--results:

05/31/2009

it is finding the last day of the month prior to today. then of course it's find data in your table that is...

here's how i would do it:

ignore the end date, and calculate it based on the clinicstartdate.

i assume that if you take the year() of today, plus the month/day, that is...

i guess you need to read up on the syntax. If that is your real command, you are not specifying any of the...

dumb question first...are you sure Table1 is identical on ServerA and ServerB? different data would of course produce different results.

second, there is a sub select with this code:

select b.Code...

ok i got it, and a solution too!

what you want to do is use the PIVOT operator;

with that, you can PIVOT a single column based on the values of the...

ALTER PROCEDURE [dbo].[sp_AppendToFile](@FileName varchar(255), @Text1 varchar(255)) AS

DECLARE @FS int, @OLEResult int, @FileID int

EXECUTE @OLEResult = sp_OACreate 'Scripting.FileSystemObject', @FS OUT

IF @OLEResult 0 PRINT 'Scripting.FileSystemObject'

if that is your whole proc, it's...

david.ainsworth (6/3/2009)

---

Hi There

Thanks for any advice in advance.

I have a SQL server I wish to replace and it has a legacy Stored Procedure that gathers information from the database and...

you are right.

compatibility mode has nothing to do with how the native mdf or backups are constructed...it only decides what syntax for TSQL will be permitted to hit the database...that...

ALZDBA the version you posted has all the CrLf stripped out, making it difficult to test, since...

you didn't explain what the issue is.

is it you need to populate a table with each hour? you said "update" the table, not populate, so i'm not sure where the...

excellent point Jan,

it seems to me that if the "global" table is missing a column , it's gotta be because a different process created a table with the same...

if you are sending the email as HTML, then that is the expected behavior...HTML does not respect extra whitespace ,tabs, or CrLf; it only recognizes it's markup tags.

if you do...