Search results for query: *

That was my error - i was trying to post a new thread and had his thread on my clipboard and when I pasted my code in it took his by accident. My bad. Still new to this site and cant see how to remove mine.

My current query: mySQL1="SELECT * FROM demo where tasks<>'' and cast(left(ptime,4) as unsigned) = " & xryear & " and status <=> " & xrstatus & " and subid <=> '" & xruser & "' and cast(substr(ptime,6,2) as unsigned)=" & xrmonth table called demo ptime column set as TEXT data inserted to...

I have the following that does not seem to work well. It leaves spaces where there is a null value, any idea on what the problem may be? Set full_name = rtrim(ISNULL(prefx,''))+'' +rtrim(ISNULL(first_name,''))+' ' +rtrim(ISNULL(preferred,''))+' ' +rtrim(ISNULL(middle_name,''))+' ' +...

How can I get the data type [size] [null or not null], schema from a table columns? Please, if this is posible, show me an example.

I have created a new folder for a calendar other than the default one. But when I try to share and give it a name to calendar and then add permissions to it, I cannot open this new shared calendar on another computer. Gives me an error message cannot find specified calendar. I tested the default...

It is SQL 2005

Yes, there is data in the TEST db. Sorry let me clarify: RM20201 is the open invoices table, and RM30201 is the invoice history table. The field GLPOSTDT simply needs to be checked for in both tables. I do not want to add the result together. My SQL is incorrect, I just am not sure how to...

I am working on a sql function to be fed an invoice number, then calculate the difference between the current system date and the last GL posting "GLPOSTDT" The function is not returning any results as of yet...see attached code USE [TEST] GO /****** Object: UserDefinedFunction...

Forgive me but i'm a beginner at this - could you please help with the syntax? I deeply appreciate all the help!

Sorry my error. Needs only the one Sales Date column

I posted this in SQL forum in error ... should be in Access forums (apologies ... still new to this site). I use the following code to pull a list of customers who have placed an order for a particular product between two dates. However, if the customer has ordered this item more than once in...

I don't see Add Command in my list anywhere. My source is Sybase.

I use the following code to pull a list of customers who have placed an order for a particular product between two dates. However, if the customer has ordered this item more than once in the date period multiple records appear for the customer. How can I change the SQL to just show me one...

Hi, Below query failed which executing in sql 2005 64Bit and large memory select count(*) AS Buffered_Page_Count ,count(*) * 8192 / (1024 * 1024) as Buffer_Pool_MB from sys.dm_os_buffer_descriptors Msg 8115, Level 16, State 2, Line 4 Arithmetic overflow error converting expression to...

I have a report which was written in crystal 8.5. When i open it in 8.5, i can do Show SQL and modify the sql and save it. But when i export the report to XI, i am not able to modify the sql.I can do Show SQL but not modify. Any help? Thanks