Viewing 15 posts - 1 through 15 (of 1,185 total)
If you look at the 2nd $200 one it has a date where the 1st one has a NULL field.....
February 16, 2006 at 8:17 am
Have you upgraded the SQL 2K database to SQL 2K5? I think you may need to do that prior to being able to use it... (I think I read something...
January 17, 2006 at 5:33 am
Not knowing much about PHP have you looked at the AfterUpdate or LostFocus event of the USERID field to see if there is logic there that limits the length of the...
January 17, 2006 at 5:31 am
How about something like
SELECT TOP 1 A.[Name], A.Address, A.BusinessType, A.Contact
FROM tblCompanies A
INNER JOIN (SELECT DISTINCT [Name] FROM tblCompanies) B ON A.[Name] = B.[Name]
Hopefully this should get you close
January 13, 2006 at 5:28 am
Roshen please post your code so we can review it and help ID where to help make changes.
January 12, 2006 at 8:56 pm
This functionality does not exist within SQL Views. However, you can research user-defined TABLE functions where you can do this 🙂
January 12, 2006 at 6:37 am
What task is it performing? I.e. why does it have to be done row by row and not via an entire SET?
January 10, 2006 at 5:22 am
If all you are trying to do is copy a file and then delete the SOURCE have you thought about using a DOS BAT file that you could call from...
January 6, 2006 at 9:34 am
Unfortunately, without seeing the code, knowing if this process is the only item running on the server, etc. it is hard to guess as to why
January 5, 2006 at 5:26 am
What version of SQL does the other system have?
Why are you installing RS on this system when it is already installed on a different server?
January 4, 2006 at 11:30 am
I agree 100%. In the past I was in the military to defend our freedoms and more of them are taken away from me daily.
I especially love the...
December 27, 2005 at 6:02 am
What we do is assign a variable the GETDATE() and then use that variable when we call the UDF. May help you
December 21, 2005 at 5:44 am
IF you have source safe type software and have controls built to check-in/out you may want to look there as well.
IF you don't may want to start thinking about it.
December 13, 2005 at 6:04 am
Research using SET DATEFIRST in BOL. This way you can tell the system what date you want to be the 1st day of the week. This is ONLY good for...
December 13, 2005 at 6:00 am
Can you provide what it is that you are trying to do with EXECUTESQL so we can try and help diagram a solution???
Have you looked at TABLE functions? This accept...
December 5, 2005 at 6:43 am