|
More site info...
New to SQL Server | Forum profile
|
|
Forum profile page for New to SQL Server on http://www.sqlteam.com.
This report page is the aggregated overview from a single forum: New to SQL Server, 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 "New to SQL Server" 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 New to SQL Server:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
160
|
367
|
897
|
|
Post:
|
565
|
1,145
|
2,730
|
|
|
New to SQL Server Posting activity graph:
|
Top authors during last week:
user's latest post:
SQL 2000 - Blank Date()
Published (2009-11-21 09:42:00)
> That's a presentation issue And actually that date really is represented by 0 You should make the column nullable And in the front end, when null, display nothing 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:
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:
Tuning
Published (2009-11-25 07:34:00)
> See the running total method http://sqlblogcasts.com/blogs/madhivanan/archive/2009/06/10/quirky-update-in-sql-server.aspx Madhivanan Failing to plan is Planning to fail
user's latest post:
Need help with ORDER BY and...
Published (2009-11-24 22:43:00)
> Show us the exact code that you ran when you got that error. 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:
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:
Clusterd and Non Clusterd Index
Published (2009-11-24 13:31:00)
> Take a little time to read: http://weblogs.sqlteam.com/mladenp/archive/2007/09/18/Back-To-Basics-What-is-a-Clustered-and-a-Non-Clustered.aspx No, you're never too old to Yak'n'Roll if you're too young to die.
user's latest post:
Clusterd and Non Clusterd Index
Published (2009-11-24 13:27:00)
> Can anybody explain clearly with some easy example difference between and clusterd and non clusterd index..i am trying to improve the performance of a view, how does the difference in performance vary with an clustered and non clustered index.. and how many non clustered indexes can be for table or a view , i know there should be only one clustered index .. can i have same columns as a clustered and non clustered index...?
user's latest post:
running total by month
Published (2009-11-25 19:22:00)
> SELECT title, YEAR(paymentDate) AS 'Year', datename(mm, paymentDate) AS 'Month', datepart(wk,paymentDate) AS 'Week', count(*) AS [Units sold], r.[Running total] from transactions t cross apply ( select count(*) AS [Running total] from transactions x where x.title = t.title and datediff(wk, 0, x.paymentDate) <= datediff(wk, 0, t.paymentDate) ) r KH Time is always against us
user's latest post:
Counter? What?
Published (2009-11-24 13:32:00)
> That is really cool. I totally get that. Thanks alot guys.
user's latest post:
Need help for querry
Published (2009-11-23 09:12:00)
> Select Functinality, count(TestScript) as [Total Test Cases], count(case when Status='Passed' then 1 else null end) as [pass count] , count(case when Status='failed' then 1 else null end) as [fail count] from Results group by TestScript
|
|
|
|
Latest active threads on New to SQL Server::
Started 1 day, 11 hours ago (2009-11-26 11:36:00)
by Transact Charlie
>
that depends on how you are storing them. What's the data type of the column in question? If you are storing them as VARCHAR's then you'd do something like:
UPDATE <yourTable> SET
<TEL NUMBER COLUMN> = '246' + <TEL NUMBER COLUMN>
(if you want to do all the rows) Charlie ================================================== ============= Msg 3903, ...
Started 1 day, 14 hours ago (2009-11-26 08:32:00)
by madhivanan
>
What is the logic? Why is ambrella10 and not ambrella1? Madhivanan Failing to plan is Planning to fail
Started 1 day, 13 hours ago (2009-11-26 09:06:00)
by madhivanan
>
EXEC SP_help <table name> Madhivanan Failing to plan is Planning to fail
Started 1 day, 14 hours ago (2009-11-26 08:02:00)
by shaggy
Started 1 day, 14 hours ago (2009-11-26 08:35:00)
by madhivanan
>
If you want default value to be taken by the column, you should omit it from insert statement Refer this to know why you should not assign '' for datetime columns http://sqlblogcasts.com/blogs/madhivanan/archive/2 008/09/02/empty-string-and-default-values.aspx Madhivanan Failing to plan is Planning to fail
Started 1 day, 14 hours ago (2009-11-26 08:01:00)
by rajdaksha
>
Hi Try like this..
create table t1(col1 int, col2 int, col3 char(50))
insert into t1 values (1, 1, 'data value one')
insert into t1 values (1, 1, 'data value one')
insert into t1 values (1, 2, 'data value two')
SELECT col1, col2, count(*)
FROM t1
GROUP BY col1, col2
HAVING count(*) > 1
------------------------- R...
Started 2 days, 10 hours ago (2009-11-25 12:44:00)
by vijayisonly
>
Do you have a question or a problem?
|
|
Hot threads for last week on New to SQL Server::
Started 1 week, 2 days 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 1 week, 1 day 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, 2 days 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, 10 hours ago (2009-11-25 12:44:00)
by vijayisonly
>
Do you have a question or a problem?
Started 1 week ago (2009-11-20 14:54:00)
by russell
>
why not just make a copy of the ddl from the customer table, then add 5 fields: date, login, host, application, username. Then your update/delete trigger simply inserts what is in the DELETED virtual table plus current_timestamp, SYSTEM_USER, host_name(), APP_NAME(), user_name(). Your insert trigger copies INSERTED plus those 5 in (if that's even necessary)
Started 1 week, 2 days 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 3 days, 23 hours ago (2009-11-23 23:47:00)
by tkizer
>
Could you show us a data example of what you mean? 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."
Started 1 week, 1 day ago (2009-11-19 19:24:00)
by Bustaz Kool
>
select title, retail from books where retail = (select min(retail) from books where category = 'COMPUTER') and category = 'COMPUTER' ======================================= Few things are harder to put up with than the annoyance of a good example. ( Mark Twain)
Started 1 week ago (2009-11-20 13:31:00)
by X002548
>
You're just not getting the set based thing, are you 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-19 18:35:00)
by X002548
>
How the hell do you have duplicates with that? Post some of the sample result set 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
|
|
Size: 913 bytes
