Recent content by FatalExceptionError

Let me clarify this. The record that is the culprit is invalid (but possibly valid) as it is a name not a date. This record should not be processed since lines.line_transaction = 'receipt' AND lines.line_status = 'received' AND header_status <> 'received' AND (order LIKE...

Problem "Syntax error converting datetime from character string." I know what this means and I even know the exact record causing this problem. What I can't figure out is why I am getting this error. Details The linecode is a char field but the application that populates it defaults it to a...

It has become apparent to me that you can't use dynamic parameters in regular subscriptions. Example: =DateAdd("d",(-1*Day(today())), today()) [silly question] Will the vbscript execute for the dynamic parameter if it is a default value? [/silly question] I just need a quick and dirty...

Thanks I was confused about "use a join" but I got it came to me in less than 3 seconds when I saw the code. Performance wise the join appears to be faster as it will return a smaller amount of rows and the execution plan has far fewer tasks to complete. Both will compute the right amount for...

What makes the left join better? Performance? ======================================= The statement below is true The statement above is false There are 10 kinds of people, those who know binary and those who don't

LNBruno the status is actually a number in a char field, I just changed it to something easier to read. SQLDenis Adding the not null clause worked but not exists doesn't. From my understanding of BOL exists returns null results and IN bypasses them. Is this wrong...

I basically have a table that has multiple columns to hold data for transactions but it really boils down to two columns. A license number(char(48)) and a status code(char(2)). A license number goes through multiple status codes as it flows through the system with a new line for each. What I...

After some sleep I see. So in this scenario isn't it pointless to even declare those variables or am I reading that wrong? If I add an if statement to an update trigger that checks if any data was actually changed(not updated), would it do this check for each update or would I have to do...

BTW thanks Denis ======================================= The statement below is true The statement above is false There are 10 kinds of people, those who know binary and those who don't

Not sure but I was asking the same question. I didn't write the triggers. I was supposed to test reports made that required the triggers in the first place. My test plan involved making new customers, updating etc. This issue got in the way of that. I am slightly confused about what was...

The problem comes up on an insert of a new customer in this particular instance so I am not sure if it is a multi row but I don't think it would be returned in the error log because of the the line right after the first comment. After the trigger was disabled the test customer went in and only...

I have some triggers on two tables in an application database in our dev environment. The triggers are used to track changes to certain fields on those tables for compliance and audit reports. Long story short it appears that the triggers are causing the application to have an error when an...

Hotdamn sister I love you. Exactly what I was looking for + tax. ======================================= The statement below is true The statement above is false There are 10 kinds of people, those who know binary and those who don't

Anyone in here have any links or know where I can read up on the differences between derived tables, views and table variables. I am more concerned with performance issues and I am pretty sure it comes down to the anticipated size of the data and what kind of machine it is on, but I would just...

Been playing around and it seems when one field is left blank (for the purpose of a general list) report server chokes. This field is sorted in order. Is there a limit to the amount of rows report server can sort? ======================================= The statement below is true The...