I found this article to be helpful in explaining how to interpret the output when IO and/or TIME statistics are set to ON

http://www.sql-server-performance.com/articles/per/statistics_io_time_p1.aspx

This may be relevant to you. You should consider the following in this type of comparison...

While the syntax of convert(varchar,getdate(),101) will return the data in the format you are...

What problem are you getting?

What is the syntax of what you're tyring to do?

What does your code for calling the stored procedure look like?

There's always a non-cursor way, but without some sample data and sample code, you may never know that way...

Copy in some sample data depicting your scenario it will help other...

It's the way nulls are evaluated. They don't evaluate to true or false, they evaluate to unknown.

So the statement 1=1 is "true" and null = null is "unknown". ...

Will you post the error messages you are getting.

This should do the trick for you... This yields the results you are looking but may not be the most efficient way to get those results. I didn't...

macwiz (6/2/2009)

---

Jason - that's an interesting result, thank you. I've never used For XML Path before, or anything with XML for that matter. From your results, I'm actually...

I'm not sure if you are looking to see multiple rows per item for each unique supplier or a distinct list of suppliers that have supplied any item or 1...

I suggest using the "update(column)" function inside the trigger to check for changes.

Details found in BOL at: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/8e3be25b-2e3b-4d1f-a610-dcbbd8d72084.htm

Below I started an if statement to get you started.

ALTER TRIGGER [F0911_UPDATE]ON [CRPDTA].[F0911]...

The issue is you are missing the quotes...

edit your statment to this:

C:

CD "C:\BFS_Backup"

MKDIR "[/color]%DATE:~10,4%-%DATE:~4,2%-%DATE:~7,2%"

Syntatically your statement is correct. I would suspect that in every instance the problem you are facing is that the process always executes the ELSE portion. Which as...

Can you send a samle of the data found in P21PLAY.dbo.p21_view_oe_hdr.delivery_instructions?

I believe your data will be something like

"BUNCHA STUFF #999999 OTHER STUFF"

The error is probably occuring because there is no...

Either PATINDEX or CHARINDEX should work for you, just use the position of the pound sign to determine what the start pos and length will be. If other characters...