the exact error i got was this:

Msg 513, Level 16, State 0, Line 1

A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement. The...

ok, it looks like two wrongs make a right...NOT combined with [^0-9] ALMOST looks like it works:

CREATE RULE [dbo].[NumericCharsOnly]

AS

@value NOT LIKE '%[^0-9,-+]%'

but the - and + , when...

you didn't give any details, so here's an example that may help you.

a case statement can evaluate more than one item:

SELECT

CASE

WHEN Column1 = 'Approved' AND...

there's gotta be a better way, but this is all i could come up with...it works, but seems overly complicated..i need a nap or something:

select object_name(syscolumns.id) as TableName,syscolumns.name As ColumnName...

no no no...

i mean your procedure sp_AppendToFile. the procedure that calls sp_AppendToFile is not the issue.

sp_AppendTo is incomplete.

your sp_AppendTo is an exact copy of the function i posted, except it...

you are using SQLExpress, which does not come with SS Integration Services.

SLQ Express with Advanced Services, just comes with the management GUI and reporting services.

SQL Server Developer , which is...

good point Wayne; we do the same...when we get multiple FK's in a table as well.

One of the things to point out is how standards like this can help you...

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...