|
More site info...
SQL Server Development (2000) | Forum profile
|
|
Forum profile page for SQL Server Development (2000) on http://www.sqlteam.com.
This report page is the aggregated overview from a single forum: SQL Server Development (2000), located on the Message Board at http://www.sqlteam.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 Server Development (2000)" on the Message Board at http://www.sqlteam.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 Server Development (2000):
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
6
|
21
|
85
|
|
Post:
|
16
|
55
|
194
|
|
|
SQL Server Development (2000) Posting activity graph:
|
Top authors during last week:
user's latest post:
Buffer Cache issue
Published (2009-12-29 07:29:00)
> quote: Originally posted by Transact Charlie what are you actually trying to do with the connection? Are you trying to pull back the whole table? If so then you'd be much better off using some of the bulk import / extract tools (bcp, ect). I'm geussing you are getting a timeout on your connections or a thread pool limit. Check the database with sp_who2 while making the connection. Could be a blocking job also. Hi Chrlie, Thanks...
user's latest post:
Problem with searching MAX Date...
Published (2009-12-22 10:16:00)
> please do post some sample data in an easy to use format. See the FAQs if you need more info.
user's latest post:
Problem with searching MAX Date...
Published (2009-12-22 09:37:00)
> quote: Originally posted by RickD Ok, then you join condition: and fc.LastModifiedDate > qlc.LastModifiedDate seems to be wrong for me. Without sample data, it is difficult to say whether your logic is correct though, especially as you have an ISNULL condition in the select statement. Tell you what, I have tried that join condition too and it hasn't worked :). If you refer to the first post, this is whats happening (ofcourse...
user's latest post:
Buffer Cache issue
Published (2009-12-29 09:03:00)
> you could mount the database somewhere with a different name from the latest backup, delete all the information from the database (or maybe this particular table if you've isolated it down to that table). Run the tool to copy the schema and then bulk export the original data into the new database. Apart from that suggestion then obviously contact the third party vendor. Don't think I can be much more help. Charlie...
user's latest post:
Buffer Cache issue
Published (2009-12-29 10:57:00)
> This is not a SQL Server buffer cache issue. You wouldn't see that in a Java error. You need to contact the vendor of the third party software. Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that everything you've done up until this point is wrong."
user's latest post:
Input Mask for a unique date...
Published (2009-12-25 09:00:00)
> hi, my question is: how to make input mask for telephon number( which is nchar) :111-111-111 ?
user's latest post:
Input Mask for a unique date...
Published (2009-12-28 00:46:00)
> quote: Originally posted by ruman hi, my question is: how to make input mask for telephon number( which is nchar) :111-111-111 ? This is nothing to do with the question Start a new thread Madhivanan Failing to plan is Planning to fail
user's latest post:
Buffer Cache issue
Published (2009-12-28 09:34:00)
> Have a look at this link. http://support.microsoft.com/kb/817326 I dont think its your exact scenario, but the problem cud be same.
user's latest post:
problem in cursor
Published (2009-12-28 05:13:00)
> There are SrNo, Id, Desc , Qty, amount , formula column in grid view in formula column if we write Q4 * Q5 it means multiplication of Quantity column of row 4&5 Ques is how to read this formula and implement in sql cursor. multiplication ya addition of two rows on the basis of formula in formula column eg-- Q4* Q5 ( multiplication of Quantities of 4 th and 5th row
user's latest post:
problem in cursor
Published (2009-12-28 16:28:00)
> Is this data stored in a MS Sql Server table? If so, post executable code to CREATE TABLE and post executable code to INSERT a few sample rows of data to your table. Finally post the EXPECTED OUTPUT you want based on your sample data. Be One with the Optimizer TG
|
|
|
|
Latest active threads on SQL Server Development (2000)::
Started 5 days, 4 hours ago (2009-12-28 09:34:00)
by vijayisonly
>
Have a look at this link. http://support.microsoft.com/kb/817326 I dont think its your exact scenario, but the problem cud be same.
Started 4 days, 21 hours ago (2009-12-28 16:28:00)
by TG
>
Is this data stored in a MS Sql Server table? If so, post executable code to CREATE TABLE and post executable code to INSERT a few sample rows of data to your table. Finally post the EXPECTED OUTPUT you want based on your sample data. Be One with the Optimizer TG
Started 5 days, 13 hours ago (2009-12-28 00:46:00)
by madhivanan
>
quote: Originally posted by ruman hi, my question is: how to make input mask for telephon number( which is nchar) :111-111-111 ? This is nothing to do with the question Start a new thread Madhivanan Failing to plan is Planning to fail
Started 2 weeks, 4 days ago (2009-12-15 06:46:00)
by RickD
>
How about posting your query as i'm sure you have an issue with the query, not the data?
Started 2 weeks, 2 days ago (2009-12-17 07:21:00)
by madhivanan
>
SELECT p.* FROM product as p left outer join product_categories as pc on p.productId = pc.productId and pc.categoryId IN (565) OR (p.name LIKE '%gold%' OR p.description LIKE '%gold%') Madhivanan Failing to plan is Planning to fail
Started 2 weeks, 2 days ago (2009-12-17 06:27:00)
by rajdaksha
>
Hi where its not working? & where its working? ------------------------- R...
Started 2 weeks, 3 days ago (2009-12-16 13:07:00)
by RyanRandall
>
Something like this? declare @freq table (Action datetime datetime, Action varchar(50), ClientID varchar(50))
insert @freq
select '20091216 08:55:45.554', 'Arrive', 'abc'
union all select '20091216 14:25:33.519', 'Leave', 'abc'
union all select '20091216 08:55:45.554', 'Arrive', 'xyz'
union all select '20091216 14:25:33.519', 'Leave', 'xyz'
union ...
Started 2 weeks, 4 days ago (2009-12-15 11:58:00)
by vijayisonly
>
Insert into Maintable
(Invoice ,Type , Desc)
Select Invoice1 ,Type , Desc1 from #table1
UNION ALL
Select Invoice2 ,Type , Desc1 from #table2 EDIT: You need to worry about the ORDER only when you SELECT from the table.
Started 2 weeks, 4 days ago (2009-12-15 03:29:00)
by madhivanan
>
See if this helps http://sqlblogcasts.com/blogs/madhivanan/archive/2 009/11/18/parsing-a-string.aspx Madhivanan Failing to plan is Planning to fail
|
|
Hot threads for last week on SQL Server Development (2000)::
Started 5 days, 4 hours ago (2009-12-28 09:34:00)
by vijayisonly
>
Have a look at this link. http://support.microsoft.com/kb/817326 I dont think its your exact scenario, but the problem cud be same.
Started 4 days, 21 hours ago (2009-12-28 16:28:00)
by TG
>
Is this data stored in a MS Sql Server table? If so, post executable code to CREATE TABLE and post executable code to INSERT a few sample rows of data to your table. Finally post the EXPECTED OUTPUT you want based on your sample data. Be One with the Optimizer TG
Started 5 days, 13 hours ago (2009-12-28 00:46:00)
by madhivanan
>
quote: Originally posted by ruman hi, my question is: how to make input mask for telephon number( which is nchar) :111-111-111 ? This is nothing to do with the question Start a new thread Madhivanan Failing to plan is Planning to fail
|
|
Size: 427 bytes
