|
More site info...
Discussions in... - www.microsoft.com/communities/newsgroups... | Site profile
|
|
Site profile page for http://www.microsoft.com/communities/newsgroups....
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.microsoft.com/communities/newsgroups....
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.microsoft.com/communities/newsgroups... 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 Discussions in microsoft.public.sqlserver.programming:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
143
|
344
|
935
|
|
Post:
|
382
|
940
|
2,724
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.sqlserver.programming (http://www.microsoft.com/communities/newsgroups...)
|
|
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.
|
|
|
|
|
Discussions in microsoft.public.sqlserver.programming posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.programming Alexa graph:
|
Top authors on Discussions in microsoft.public.sqlserver.programming during last week:
user's latest post:
Invalid length parameter passed...
Published (2009-11-25 11:26:00)
The problem is that you have a description value that does not contain a '-'. Try this: SELECT CASE WHEN CHARINDEX('-', descr) > 0 THEN LEFT(descr, CHARINDEX('-', descr) - 1) ELSE descr END AS descr FROM inventory;
user's latest post:
2005 - Integer may not be NULL...
Published (2009-11-24 15:36:00)
Rich Lawson (nospam@nospam.com) writes: > I have some fields that are being imported with SSIS which are integers. I > have tried to tell SQL 2005 to default to 0, zero, but when it is imported > with SSIS, the blank field becomes NULL. Since I don't know SSIS, I cannot help you, but why are the columns nullable in the first place? Overall, the table seem have a lot of nullable columns. I don't know...
user's latest post:
Need help with Indexed View that...
Published (2009-11-25 11:16:00)
I agree with Michael, you probably will get acceptable performance with a regular view. Of course, the only way to know is to simulate your system with realistic amounts of data and query volumne. If you do that, you may well find that performance is fine, or that you have a performance problem, but the bottleneck is somewhere else in your system. If you do decide that you need an indexed view, I don't think it is possible to...
user's latest post:
data from Excel into SQL Server...
Published (2009-11-25 07:26:00)
Yes, one option if I understood you correctly is to use Multiflatfile connection manager, see details in the BOL "Doug Howell" <douglasehowell@gmail.com> wrote in message news:3e4fdbdc-7bad-4114-8359-0419941a8ca5@m26g2000yqb.googlegroups.com... > I've never used SSIS wizard before, but it seem like a "one time" data > import tool. > > The current...
user's latest post:
column with UNIQUE and NOT NULL...
Published (2009-11-17 23:36:00)
Hi AliRezaGoogle You are mixing up logical and physical constructs. Keys are a logical construct, just an expression of the behavior you want. Physical constructs are the actual method of implementation. If you declare a primary key, SQL Server will implement that with a non-null unique index. The default is to make it a clustered index, but that is not necessary. (The non-null and unique IS necessary. ) In fact, in many cases...
user's latest post:
Localized Tables in...
Published (2009-11-23 17:16:00)
>> Well, this is my idea and questions. Am I planning this correctly?<< No. There are ISO codes for languages, so do not invent your own. Depending on the article's area of study, you will find an industry standard identity (and it is never a silly IDENTITY). For example there is the ISSN (International Standard Serial Number) for magazines. Do not talk to database people; talk to a librarian. This...
user's latest post:
Need help with Indexed View that...
Published (2009-11-25 08:46:00)
If you put the query I gave you in a table-valued function or stored proc and pass in the SKU as a parameter, and add the SKU to the WHERE clause predicate you will probably see acceptable performance. The key is that you're doing this for one SKU at a time, so with a little index-tweaking on your tables I would imagine your performance would be good. "Sam" <Sam@discussions.microsoft.com> wrote...
user's latest post:
Round-ding... in...
Published (2009-11-25 06:56:00)
"JeffP->" <JeffP@discussions.microsoft.com> wrote in message news:8DBB559C-705A-4DDC-A81C-F5E539952728@microsoft.com... > a penny. It just irks me that Excel is the defacto calculator, not a real > calculator or real math but Excel math. Perhaps someone should stop using Excel... ;) .
user's latest post:
update trigger question in...
Published (2009-11-25 09:31:00)
That's what I thought. Just wanted to be sure I wan't missing something. Thanks. "Plamen Ratchev" <Plamen@SQLStudio.com> wrote in message news:V9WdnRQ1WocM2JDWnZ2dnUVZ_opi4p2d@speakeasy.net... > Collation defines how strings are compared and sorted (as well as the > character set for non Unicode data), so it will have no effect on values > like INT and date. >...
user's latest post:
Select Query Problem in...
Published (2009-11-24 15:56:00)
how about multiple EXISTS clauses? select * from table t1 where name like 'roma%' and exists (select * from table t2 where t2.name = t1.name and t2.address = t1.address and t2.skills = 'manager') and exists (select * from table t2 where t2.name = t1.name and t2.address = t1.address and t2.skills = 'engineer') I note that that query would be simple if you had a surrogate key such as an identity column...
|
|
|
Top 10 active forums on Discussions in microsoft.public.sqlserver.programming during last week:
|
|
Top 10 forums on Discussions in microsoft.public.sqlserver.programming:
|
|
|
|
Latest active threads on Discussions in microsoft.public.sqlserver.programming:
Started 1 day, 18 hours ago (2009-11-25 11:26:00)
by Plamen Ratchev
The problem is that you have a description value that does not contain a '-'. Try this:
SELECT CASE WHEN CHARINDEX('-', descr) > 0
THEN LEFT(descr, CHARINDEX('-', descr) - 1)
ELSE descr
END AS descr
FROM inventory;
Started 2 days, 10 hours ago (2009-11-24 19:19:00)
by Michael Coles
Here's a query to get you started. It grabs 2 of your vendors for each
product with the lowest prices. Note that if the 2nd and 3rd vendors offer
the same product for the same price there's no way to guarantee which one
will be returned since no business rule is defined for that:
SELECT *
FROM
(
SELECT ROW_NUMBER() OVER (...
Started 1 day, 19 hours ago (2009-11-25 10:31:00)
by Plamen Ratchev
You can use FOR XML PATH to concatenate the values:
SELECT DISTINCT A.LicenseId, STUFF(S.states_list, 1, 1, '') AS states_list
FROM #Temp AS A
CROSS APPLY (SELECT ',' + B.StateCd
FROM #Temp AS B
WHERE B.LicenseId = A.LicenseId
FOR XML PATH('')) AS S(states_list);
Started 1 day, 20 hours ago (2009-11-25 09:31:00)
by Plamen Ratchev
When you use aggregate functions you have to use the GROUP BY clause to list the grouping columns. Try the following
query (notice the predicates on the Customer table are moved from the WHERE clause to the JOIN conditions, otherwise
they turn the outer join to inner join):
SELECT sp.FirstName + ' ' + sp.LastName AS SalesPersonName,...
Started 2 days, 10 hours ago (2009-11-24 18:51:00)
by Plamen Ratchev
The UPDATE function evaluates to true if the column is listed in the SET clause of UPDATE statement. It does not
necessary mean that the value is changed. You can join the Deleted and Inserted virtual tables on NameID and then check
if FirstName or LastName is different, then update the FullName column. Below is how it may look.
But ...
Started 1 day, 20 hours ago (2009-11-25 08:46:00)
by tnichols333
2005 - thanks for any help you can provide!!!
Uri Dimant wrote:
>What is the version of SQL Server are you using?
>
>> Howdy - and thank you in advance for any help!!!
>> Here is what I have so far:
>[quoted text clipped - 29 lines]
>> g.beginingdate
>> g.endingdate
....
Started 1 day, 22 hours ago (2009-11-25 07:06:00)
by Uri Dimant
Hi
Use SSIS Package
"Doug Howell" <douglasehowell@gmail.com> wrote in message
news:8f4372b8-e019-40e9-b507-273bc0b2881d@j19g20 00yqk.googlegroups.com...
>I currently have some code in an Excel 2007 workbook which takes data
> out of a worksheet and creates records in two different Access 2007
> tables.
>
> I ...
|
|
Hot threads for last week on Discussions in microsoft.public.sqlserver.programming:
Started 2 days, 22 hours ago (2009-11-24 07:11:00)
by TheSQLGuru
1) what do you mean "retry"? can you explain the objective a bit better?
2) if possible, I recommend moving the person information to one table with
a primary key. then put the skills (0-n of them) in a separate table that
has the PK from the person table. this is basic data normalization, which
is something you probably should ...
Started 1 week, 1 day ago (2009-11-18 08:16:00)
by Plamen Ratchev
On SQL Server 2008 you can use a table-valued parameter:
CREATE TYPE store_type AS TABLE (storeid INT);
GO
DECLARE @t store_type;
INSERT INTO @t (storeid) VALUES(1);
EXEC sp_executesql N'SELECT storeid FROM @t',
N'@t store_type READONLY',
@t;
GO...
Started 4 days, 6 hours ago (2009-11-22 23:21:00)
by Balaji
Hi Sam,
You query may be some thing like this...
select * from table
where datetimecol >= convert(varchar(30),dateadd(mi,-30,GETDATE()),108)
Regards, Balaji
"sam0204" <u56410@uwe> wrote in message news:9f87af27dfbf3@uwe...
> Hi all,
>
> I have a database which is similiar to
>
> id ...
Started 1 week ago (2009-11-19 06:46:00)
by Erland Sommarskog
Tony Johansson (johansson.andersson@telia.com) writes:
> I just wonder if I use window autentisering for a SQL server on a server
> where I can log in to how can SQL Server let me do so. I assume that SQL
> Server will not insert any kind of window account into the SQL Server
> database. So I can't understand how SQL Server can use my ...
Started 1 week, 1 day ago (2009-11-18 09:32:00)
by Tom Cooper
select * from #tmp1
where (right(pwd,1) = ' ' and datalength(pwd) > 0)
Or (right(login,1) = ' ' and datalength(login) > 0);
Tom
"Rich" <Rich@discussions.microsoft.com> wrote in message
news:72FF1EC0-902C-4916-9273-BB9B2D8D4B14@micros oft.com...
>I need to isolate/retrieve rows from the following sample data where ...
Started 2 days, 4 hours ago (2009-11-25 01:16:00)
by Uri Dimant
Hi
Do you have lastest service pack? What if you insert the data via query
builder rather than SSMS?
"Jan Karel Pieterse" <jkpieterse@netscape.net> wrote in message
news:VA.00000623.17985d40@netscape.net...
> Hi,
>
> Using SQL Server 2005.
>
> I have a table with one required field (key ...
Started 2 days, 10 hours ago (2009-11-24 18:51:00)
by Plamen Ratchev
The UPDATE function evaluates to true if the column is listed in the SET clause of UPDATE statement. It does not
necessary mean that the value is changed. You can join the Deleted and Inserted virtual tables on NameID and then check
if FirstName or LastName is different, then update the FullName column. Below is how it may look.
But ...
Started 6 days, 21 hours ago (2009-11-20 08:19:00)
by Linchi Shea
Whatever answers you get here are no substitute for the detailed description
in the Books Online on this subject. I suggest you take a read there.
That said, with the full recovery mode, the most significant advantage is
that you can recover to a point in time if you back up your transaction log
regularly and preserve the log ...
Started 2 days, 13 hours ago (2009-11-24 15:36:00)
by Erland Sommarskog
Rich Lawson (nospam@nospam.com) writes:
> I have some fields that are being imported with SSIS which are integers. I
> have tried to tell SQL 2005 to default to 0, zero, but when it is imported
> with SSIS, the blank field becomes NULL.
Since I don't know SSIS, I cannot help you, but why are the columns
nullable in the first ...
Started 2 days, 10 hours ago (2009-11-24 19:19:00)
by Michael Coles
Here's a query to get you started. It grabs 2 of your vendors for each
product with the lowest prices. Note that if the 2nd and 3rd vendors offer
the same product for the same price there's no way to guarantee which one
will be returned since no business rule is defined for that:
SELECT *
FROM
(
SELECT ROW_NUMBER() OVER (...
|
|
Size: 513 bytes
