|
More site info...
SQL Server Forums - www.sqlteam.com | Site profile
|
|
Site profile page for http://www.sqlteam.com.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.sqlteam.com.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.sqlteam.com is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) 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 site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on SQL Server Forums:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
521
|
1,303
|
3,406
|
|
Post:
|
1,523
|
3,675
|
9,165
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for SQL Server Forums (http://www.sqlteam.com)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
SQL Server Forums posting activity graph:
|
|
http://www.sqlteam.com Alexa graph:
|
Top authors on SQL Server Forums during last week:
user's latest post:
I actually need an advice on...
Published (2009-11-23 21:39:00)
> Please let me know which pharmacies. I want to be sure I don't allow my personal/medical information to be stored by, or put my family's well being in the hands of a pharmacy that isn't willing to hire a professional to manage their information.
user's latest post:
Marlee Matlin singing Poker Face
Published (2009-11-23 16:53:00)
> Here's an idea...if I think Lady G spot is cool...that should turn the girls off to it...right? Brett 8-) Hint: Want your questions answered fast? Follow the direction in this link http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx Add yourself! http://www.frappr.com/sqlteam
user's latest post:
Create Stored Proc.
Published (2009-11-23 23:49:00)
> Try any of these: http://www.google.com/search?hl=en&rlz=1T4DKUS_enUS303US304&q=sql+server+stored+procedure+generator&aq=f&oq=&aqi=g-p1g9 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:
Selective Sum
Published (2009-11-23 13:53:00)
> ?? where's Schedule_Status in this?
user's latest post:
Simple update?
Published (2009-11-22 12:28:00)
> And you can do: begin tran update... rollback -- if number of records seems to be wrong or commit -- if number of records seems to be ok No, you're never too old to Yak'n'Roll if you're too young to die.
user's latest post:
Subqueries in MS Access 2007
Published (2009-11-23 09:32:00)
> Have you tried this? select . . from table t WHERE not exists ( SELECT ITEM_NO FROM...where col=t.col ) and not exists ( SELECT ITEM_NO FROM...where col=t.col ) and not exists ( SELECT ITEM_NO FROM...where col=t.col ) Madhivanan Failing to plan is Planning to fail
user's latest post:
Selective Sum
Published (2009-11-23 09:19:00)
> it will be easier if you can post your table DDL, sample records and expected result KH Time is always against us
user's latest post:
Is it possible to do a query on...
Published (2009-11-23 07:56:00)
> Maybe this? (assuming you want to update position with the column you are generating) UPDATE np SET position = r.naturalPosition FROM page np JOIN ( SELECT UniqueId , ParentId , Name , Lineage , Position , (SELECT COUNT(*) + 1 FROM Page as p2 WHERE LEFT(lineage, LEN(@Lineage)) = @Lineage AND Depth = @Depth AND p2.lineage< p1.lineage) as NaturalPosition FROM Page as p1 WHERE LEFT(lineage, LEN(@Lineage)) = @Lineage AND Depth = @Depth...
user's latest post:
Question about subqueries
Published (2009-11-18 21:15:00)
> Would I have to create another From car c1 and use that in the second count()
user's latest post:
Better Join Condition
Published (2009-11-19 13:46:00)
> I HAVE 2 TABLES TABLE 1:DW_T_BUILD_VERSIONS-WHICH HAS PHONE BUILD INFORMATION TABLE 2:DW_T_BATCH_RECORDS-WHICH HAS JOB DEATILS I HAVE TO CREATE A VIEW JOINING THESE 2 TABLES , THE ONLY COLOMNS I CAN MATCH HERE IS PHONE_BUILD AND JOB_NAME , PLEASE FIND THE BELOW LINK FOR THE STRUCTURE OF TEH TABLES AND JOIN CONDITION FOR THE VIEW http://download.yousendit.com/ZW9COU1RTXZnYU1LSkE9PQ ISSUES fACING: 1.POOR PERFORMANCE 2.UNABLE TO RETRIVE...
|
|
|
Top 10 active forums on SQL Server Forums during last week:
|
|
Top 10 forums on SQL Server Forums:
New to SQL Server
- 46,641 posts
|
Transact-SQL (2000)
- 25,402 posts
|
SQL Server Development (2000)
- 24,314 posts
|
Transact-SQL (2005)
- 20,630 posts
|
SQL Server Administration (2005)
- 10,036 posts
|
The Yak Corral
- 8,119 posts
|
SQL Server Administration (2000)
- 7,295 posts
|
Import/Export (DTS) and Replication (2000)
- 4,235 posts
|
SSIS and Import/Export (2005)
- 4,228 posts
|
Analysis Server and Reporting Services (2005)
- 3,064 posts
|
|
|
|
|
Latest active threads on SQL Server Forums:
Started 1 day, 17 hours ago (2009-11-24 05:56:00)
by mattlightbourn
>
oops, I meant:
SELECT T1.YearNum,
T1.MonthNum,
sum(T1.Revenue) AS Revenue,
sum(T1.Revenue)-sum(T2.Revenue) AS Demand
FROM T1
LEFT OUTER JOIN
T1 AS T2 ON
T1.YearNum = T2.YearNum AND
T1.MonthNum -1 = T2.MonthNum
GROUP BY T1.YearNum, T1.MonthNum
ORDER BY T1 YearNum, T1, MonthNum
Started 2 years, 11 months ago (2006-12-12 07:56:00)
by harsh_athalye
>
Wonderful implementation, Peter! Thanks for sharing. Harsh Athalye India. "The IMPOSSIBLE is often UNTRIED"
Started 16 hours, 36 minutes ago (2009-11-25 06:43:00)
by OldMySQLUser
>
Of course I realise that could just do: UPDATE PaymentArrangements SET ArrangementDate = FirstPaymentDate, DayOfMonth = DATEPART(DAY,FirstPaymentDate), NextPaymentDate = DATEADD(MONTH,1,FirstPaymentDate), ExpiryDate = DATEADD(MONTH,6,GETDATE()) WHERE CreatedBy = 93 AND DATEPART(DAY,FirstPaymentDate) < 29 UPDATE PaymentArrangements SET ArrangementDate = ...
Started 15 hours, 45 minutes ago (2009-11-25 07:34:00)
by madhivanan
>
See the running total method http://sqlblogcasts.com/blogs/madhivanan/archive/2 009/06/10/quirky-update-in-sql-server.aspx Madhivanan Failing to plan is Planning to fail
Started 1 day, 14 hours ago (2009-11-24 08:41:00)
by rajdaksha
>
Hi SQL Server linked servers Example
SELECT * INTO XLImport1 FROM EXCELLINK...[Customers$]
SELECT * INTO XLImport2 FROM OPENQUERY(EXCELLINK,
'SELECT * FROM [Customers$]')
SQL Server distributed queries Example
SELECT * INTO XLImport3 FROM OPENDATASOURCE(' Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\test\xltest.xls;Extended Properties=...
Started 15 hours, 53 minutes ago (2009-11-25 07:26:00)
by webfred
>
last_run_outcome int Outcome of the job the last time it ran: 0 = Failed 1 = Succeeded 3 = Canceled 5 = Unknown http://msdn.microsoft.com/en-us/library/ms186722 (SQL.90).aspx No, you're never too old to Yak'n'Roll if you're too young to die.
Started 20 hours, 27 minutes ago (2009-11-25 02:52:00)
by madhivanan
>
select AName from firsttable as f inner join TableA as t on ','+t.AID+',' like '%,'+cast(f.AID as varchar(10))+',%' Madhivanan Failing to plan is Planning to fail
|
|
Hot threads for last week on SQL Server Forums:
Started 1 week, 1 day ago (2009-11-17 12:35:00)
by webfred
>
What do you mean? Select the same column of a table twice? No, you're never too old to Yak'n'Roll if you're too young to die.
Started 1 week ago (2009-11-18 22:21:00)
by russell
>
Ok, let's start with "What is a database?" A database is a storage and retrieval sytem to store information. Let's illustrate with a simple example. You have an application where people place orders. You need to store your customer information, product information and sales. Where do you put it? In a database. MS SQL Server is one of a small handful of enterprise ...
Started 6 days, 16 hours ago (2009-11-19 06:47:00)
by Transact Charlie
>
Maybe this?
SELECT
c.[name]
, o.[ordId]
, o.[shipDate]
, o.[total]
FROM
customer c
JOIN ord o ON o.[custID] = c.[custId]
JOIN (
SELECT
c2.[city] AS [city]
, AVG(o2.[total]) AS [av_city_tot]
FROM
customer c2
JOIN ord o2 ON o2.[custId] = c2.[custId]
GROUP BY
c2.[city]
)
avCit ON avCit.[city] = c.[city]
WHERE
o.[...
Started 1 week ago (2009-11-18 19:56:00)
by russell
>
First, this should be a check constraint, not a trigger. Second, a logical or in SQL Server is "OR" not "||"
create table CrewAssignments(
boatname varChar(20),
planneddepart varChar(20),
crewssn int,
role varchar(20),
commission int,
PRIMARY KEY (boatname, planneddepart, crewssn),
FOREIGN KEY (boatname, planneddepart) references Charters(boatname,...
Started 2 days, 14 hours ago (2009-11-23 09:19:00)
by khtan
>
it will be easier if you can post your table DDL, sample records and expected result KH Time is always against us
Started 1 day, 17 hours ago (2009-11-24 05:56:00)
by mattlightbourn
>
oops, I meant:
SELECT T1.YearNum,
T1.MonthNum,
sum(T1.Revenue) AS Revenue,
sum(T1.Revenue)-sum(T2.Revenue) AS Demand
FROM T1
LEFT OUTER JOIN
T1 AS T2 ON
T1.YearNum = T2.YearNum AND
T1.MonthNum -1 = T2.MonthNum
GROUP BY T1.YearNum, T1.MonthNum
ORDER BY T1 YearNum, T1, MonthNum
Started 1 week ago (2009-11-18 14:41:00)
by JJ297
>
Never mind I got it: SELECT DISTINCT CONVERT(char, weekdat, 101) AS FridayDte FROM Text ORDER BY FridayDte
Started 1 week ago (2009-11-18 16:02:00)
by tkizer
>
No. You can not truncate the transaction log if you are using log shipping as it breaks the transaction log chain. Why do you need to truncate it though? It is really a bad idea. 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...
Started 1 week, 1 day ago (2009-11-17 16:42:00)
by X002548
>
So you do know the following? 'AR' <> ' Assualt Rifle' Brett 8-) Hint: Want your questions answered fast? Follow the direction in this link http://weblogs.sqlteam.com/brettk/archive/2005/05/ 25/5276.aspx Add yourself! http://www.frappr.com/sqlteam
Started 1 week, 1 day ago (2009-11-17 08:40:00)
by khtan
>
each cardnumber is unique Is it ? 2525252 seems to appear twice KH Time is always against us
|
|
Size: 611 bytes
