|
More site info...
SQL Development | Forum profile
|
|
Forum profile page for SQL Development on http://www.aspfree.com.
This report page is the aggregated overview from a single forum: SQL Development, located on the Message Board at http://www.aspfree.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "SQL Development" on the Message Board at http://www.aspfree.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on SQL Development:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
4
|
32
|
76
|
|
Post:
|
7
|
69
|
142
|
|
|
SQL Development Posting activity graph:
|
Top authors during last week:
user's latest post:
Like statement help
Published (2009-11-24 09:20:00)
I have done it by Code: '%' + @varyr + '%' doing that. However, in my stored procedure, I also want to select the date field, which contains dates in DD/DD/YYYY format. I want to then extract just the year so that on my website, i can give a list of each year the person has an entry in the database, but I dont know how to get just the year from the date field and then display it only once on my website, even if I have the...
user's latest post:
[Query - General] Failure...
Published (2009-11-27 07:44:00)
Hi, I have a SQL 2005 DB and using ASP VB. I have a form that a user selects 'Month' and 'year' to run a 6-month forecast report. I'm trying to make the results page load up the next 6 months'-worth of month names in a table. So if a user selects 'June', the results page will load up 'June', 'July' etc. I'm using Dreamweaver and have tested the result set, which works OK, but...
user's latest post:
Update Query - Multiple step OLE...
Published (2009-11-27 15:47:00)
Thanks for the link. Haven't quite figured out the code but does seem pertinent. Search for related info led me to another possible solution, which is to set the CacheSize property of a recordset. http://ares.smartartist.net.au/casp...ze_property.htm I have no problem with VBA code updating a 69,000-record table using a function that does not involve data connection or Select query so that does make me think that the solution will...
user's latest post:
Update Query - Multiple step OLE...
Published (2009-11-27 21:46:00)
Had to dig through some of my old codev- I knew I had the same problem once before: Code: Set oCommand = CreateObject("ADODB.Command") Set oCommand.ActiveConnection = oConnection oCommand.Properties("Page Size") = 200 I've taken a crack at modifying your code, but no guarantees... changes in Green Code: Public Sub UpdatePrefix() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set objCmd =...
|
|
|
|
Latest active threads on SQL Development::
Started 2 weeks, 1 day ago (2009-11-17 08:54:00)
by q97
It might be the vb induced limit of 1000 records causing the problem. There is a simple fix, where you tell it how many records it is to work with at a time.
http://social. msdn.microsoft.com/Forums/en-US/vb general/thread/e483c098-b2c1-4037-b9fb-3c882f3b14c 4
Started 5 days, 8 hours ago (2009-11-27 07:44:00)
by iand109
Started 1 week, 1 day ago (2009-11-24 09:20:00)
by apachehelp
I have done it by
Code:
'%' + @varyr + '%'
doing that.
However, in my stored procedure, I also want to select the date field, which contains dates in DD/DD/YYYY format.
I want to then extract just the year so that on my website, i can give a list of each year the person has an entry in the database, but I dont know how to get just the year from the ...
Started 1 week, 6 days ago (2009-11-19 04:36:00)
by Guddu
yes .You can use like operator of sql. Please could you post your sql query here, so that we can modify it.
just for your info
Code:
select * from table_book where title like '%put your variable which contains the data to be search%'
Started 2 weeks, 2 days ago (2009-11-16 12:46:00)
by sync_or_swim
Hi,
From your description of the problem I would expect your sql to have a GROUP BY and a HAVING COUNT > 1 which it does, so at a glance it looks pretty good. To really give you any useful help it would be helpful to see a description of your table structure and a sample of your data. I will try and help if you post this information.
Started 1 month, 1 week ago (2009-10-21 16:53:00)
by June7
This can happen when you use aggregate functions and you want to include a field that you don't want to group on. Have to do something with that field (such as Last or Max or Count). Query as posted difficult to read so I have repeated it here without edits other than the line continuations.
Code:
sqlText2 = " SELECT Distinct " & _
"name AS Thename, " & _
"Count(age) ...
Started 7 months, 3 weeks ago (2009-04-15 03:59:00)
by sync_or_swim
Hi, and welcome to the forums. I'm not entirely sure what you are trying to achieve, do you just want the name and userid of the usedr along with a count of the number of of n ews records posted by this user, or do you want to return the user's name and id along with all of the ews items on the same line? If you wanted to do the latter it would be more difficult, but to simply return a...
Started 7 months, 4 weeks ago (2009-04-08 09:33:00)
by bigmike1212
Actually, I think your "end result" is what your database design should look like in the first place.
Started 9 months, 1 week ago (2009-02-24 04:27:00)
by bklr
select distinct * from @temptable where month(activedate) = month(statementdate)-1
|
|
Hot threads for last week on SQL Development::
Started 1 week, 1 day ago (2009-11-24 09:20:00)
by apachehelp
I have done it by
Code:
'%' + @varyr + '%'
doing that.
However, in my stored procedure, I also want to select the date field, which contains dates in DD/DD/YYYY format.
I want to then extract just the year so that on my website, i can give a list of each year the person has an entry in the database, but I dont know how to get just the year from the ...
Started 2 weeks, 1 day ago (2009-11-17 08:54:00)
by q97
It might be the vb induced limit of 1000 records causing the problem. There is a simple fix, where you tell it how many records it is to work with at a time.
http://social. msdn.microsoft.com/Forums/en-US/vb general/thread/e483c098-b2c1-4037-b9fb-3c882f3b14c 4
Started 5 days, 8 hours ago (2009-11-27 07:44:00)
by iand109
|
|
Size: 331 bytes
