Search results for query: *

God i love this web site! Thank you guys. One follow up though. If i wanted to exclude '%P%O%BOX% from street address? I tried below but it didn't exclude the PO Box records. CASE WHEN tciAddress.AddrLine1 NOT Like '%P%O%BOX% 'THEN tciAddress.AddrLine1 ELSE '' END I also tried this but it...

Hello, I'm trying to create a CASe statement that finds PO BOX records in an address field. If i find a text containing %P%O%BOX% i want it to return the data else leave it blank. Here is what i have written so far but i do not get any results. CASE WHEN tciAddress.AddrLine1 = '%BOX%' THEN...

I don't know why i didn't think of that. I guess i made the problem more complex that it should have been. I was looking to do option #2.

Hi guys I’m looking to create a simple delete statement. I have a table that stores ref numbers. I want to delete the records in the column RefNo where the TenderTypeKey = 3. It's basically the records that are returned in this select statement; SELECT RefNo, TenderTypeKey FROM...

The error is "Failure setting SO defaults with spsoGetSalesOrdDflts" Does the NULL mean it will except a null value? ",NULL --@_iCloseDate" Is there a way to test the stored procedure in a test environment? I'm not a SQL developer.

I have a stored procedure that errors out. My question is in the following SQL text. Where the sp says; ",@EdiCustId"(is that a required field/attribute? Meaning it is looking for that value to be plugged in) next Where the sp says; ",NULL --@_iStatus" ( Does that mean a null value/attribute...

Still got an error. Here is what i did i created a formula field and used the folowing text: If {timWhseBin.Status} = 2 Then Formula = "Inactive" Else Formula = "Active" End If

Should i not be using this formula in a select expert? Should i create a new un-bound field and use the formula there? I tried putting the formula in the select expert but keep getting an error "The result of selection formula must be a boolean" I could just create a SQL view and do a CASE...

Hi guys, I'm trying to convert a number value to text. I have a table with a field called status. I'd like to convert the number 2 to "Inactive" ToText ({timWhseBin.Status},2) THEN ('Inactive') When i run it it says the remaining text does not appear to be part of a formula. Thanks for you...

I'm not sure if you're restoring a databse from an ERP system like MAS500. Typically there is a utility that copies user names and passwords after the database is restored.

Thanks George!!! RIGHT (CONVERT (VarChar(100), LogBBT.SysDate, 100), 7) Result: 4:31PM worked perfectly!!

i tried what was in the link: CONVERT (VARCHAR(10), LogBBT.SysDate, 101) + RIGHT (CONVERT (VARCHAR(20), LogBBT.SysDate, 100), 8) Result: 03/24/2009 4:31PM I just want to isolate the Hours & Minutes i do not want the date "3/24/2009" Thanks,

I'm trying to convert this system date to show me the hours and minutes in a 12 hour clock not the 24 hour format that it returns. Is there an easy way to convert to show 12 hour time? I've tried every type of casr nad convert format with no luck CONVERT (nvarchar(20), LogBBT.SysDate, 8) i ger...

Thanks guys that was perfect. It's always something simple. I'm still learing this whole SQL thing.

Hey guys i'm trying to use a DATEDIFF function by calling GETDATE within the DATEDIFF function. I get the error above when i try to insert into the SQL view. I know if i save the view and then create another view and reference the first view it will work. Is there a way to just use one view...

I guess i'm using SQL 2000

I guess I’m looking for a way to log who modified the view not just prevent them from modifying it. Preventing modification to a view is very useful though. The views are being modified via SQL Server Management Studio or Enterprise Manager. Thanks,

Does anyone know if it's possible to put a trigger on a view when it's modified? We had an issue with someone changing a custom view that runs a lot of different reports. after the change was made everything was messed up. It took me 2.5 days to figure out what the problem was. Unfortuntly...

I have a check box field i'm trying to get into a report. If the check box is checked it stores the #1 in the database if not it stores a 0. I have the following formula in "Format Formula" If {_tsrPartnerCustom.Buderus} = 1 Then Formula = "YES" Else Formula = "NO" End If It shows a yes in...

FEI*Denver Returns everything. Im guessing that proves there is more than one space between the word correct? There is no way to tell the query to ignore the spaces?