|
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:
|
46
|
196
|
925
|
|
Post:
|
100
|
549
|
2,892
|
|
|
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:
Subquery in the FROM clause in...
Published (2009-11-04 15:49:00)
Well, here is the SyBase position on your question. It is not ANSI standard and you can get what you want another way. http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sqlug/html/sqlug/sqlug413.htm FWIW, RLF "klem s" <sqlsurfring@gmail.com> wrote in message news:218412ee-d8e2-475e-a601-0a040d293bc3@s15g2000yqs.googlegroups.com... On Nov 3, 9:48 pm, "David...
user's latest post:
SQL 2005 - SQL Native Client...
Published (2009-10-31 03:36:00)
Paul Pedersen (nospam@no.spam) writes: > When trying to connect to a SQL Server 2005 instance using "SQL Native > Client", I get this message: > > [Microsoft][SQL Native Client]Unable to complete login process due to > delay in opening server connection > > > If I use the "SQL Server" driver instead, it works fine. Anyone have an >...
user's latest post:
Running value but with a string...
Published (2009-11-04 15:49:00)
Here is one example: CREATE TABLE Foo ( fookey INT NOT NULL PRIMARY KEY, y_n CHAR(1)); INSERT INTO Foo VALUES(1, 'Y'); INSERT INTO Foo VALUES(2, 'N'); INSERT INTO Foo VALUES(3, 'Y'); INSERT INTO Foo VALUES(4, 'Y'); SELECT A.fookey, A.y_n, (SELECT '' + B.y_n FROM Foo AS B WHERE B.fookey <= A.fookey ORDER BY B.fookey FOR XML PATH('')) AS yn_path FROM Foo AS A; /*...
user's latest post:
Tools to measure query...
Published (2009-11-04 17:44:00)
You can generate two query plans in SSMS (free with SQL Server) and compare them. I prefer the graphical query plans because they display bottlenecks and potential bottlenecks in a nice, easy-to-read format. Others prefer text query plans, but either way it will give you a lot of good info to identify query performance issues and find optimization opportunities. -- Thanks Michael Coles SQL Server MVP Author, "Expert SQL...
user's latest post:
Help with Query in...
Published (2009-10-29 11:14:00)
Bob This is great But I have thousands of rows. Would I need to insert them all as per below (you have the 3 lines) isn't there something I can run for the whole table Thanks > "Bob" <Bob@discussions.microsoft.com> wrote in message > news:7B317DAC-816D-4AC5-98F7-9C3C210EC210@microsoft.com... >> DECLARE @t TABLE ( url VARCHAR(500) ) >> >>...
user's latest post:
Schema changes with read...
Published (2009-10-29 13:36:00)
please ignore my reply, there was a typo. -- www.calsql.com (my blog site) "sekharsql" wrote: > send the complete sql statement , so that we can look at that > > sekhar, > www.calsql.com (my blog site) > > > "mouser" wrote: > > > Does anyone have advice on making schema changes to a very large table when > >...
user's latest post:
local temp tables in...
Published (2009-10-29 20:16:00)
>> Is this necessary in any way or is it redundant? << 1) official answer: they are supposed to be dropped by the system for you when control exits the scope of the session or procedure. 2) better answer: drop them yourself. There were situations where they could be orphaned -- sure if that is still true in 2008. But it also makes porting code to another SQL that follows the ANSI/ISO model of temp tables...
user's latest post:
Subquery in the FROM clause in...
Published (2009-11-04 12:42:00)
On Nov 3, 9:48?pm, "David Portas" <REMOVE_BEFORE_REPLYING_dpor...@acm.org> wrote: > A query used in the FROM clause is called a "derived table subquery" because > it returns some rows of data exactly as if that data existed in a table. > So essentially data returned from subquery ( inside FROM clause ) acts as a table? Also, as far as I can tell we can’t have...
user's latest post:
Strip off time in...
Published (2009-11-04 10:21:00)
David UPDATE dbo.ROTimesheets SET DateEntered = DATEADD(d,DATEDIFF(d,0,DateEntered),0) "David C" <dlchase@lifetimeinc.com> wrote in message news:OKmsVRWXKHA.1268@TK2MSFTNGP04.phx.gbl... >I have a SQL 2000 database table that has a smalldatetime column that I >want to remove the time portion for those that have a time. We added a new >application that is...
|
|
|
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 2 days, 9 hours ago (2009-11-07 12:02:00)
by Augustin Prasanna
Can the user use multiple computers when he is tagged to one specific group?
Any relation between group and computer?
" Jama" wrote:
> I have a [user] who belongs to a [group] and writes an [article] using a
> certain [computer].
> The user can move to a different group and a computer can be assigned to a
> different...
Started 3 days, 6 hours ago (2009-11-06 15:26:00)
by Q
123456123456712345678
UNIVTR0000000ORDDOCID
6 + 7 + 8 = 21
21 is bigger than 15 to me. ([NXTSPNUM] [char](15) NOT NULL)
To fix the problem, you need to extend the column NXTSPNUM to at least 21
char.
However, I think your codes mean adding leading zeros to ORDDOCID and not
adding 7's zeros in between. If...
Started 4 days, 6 hours ago (2009-11-05 15:32:00)
by Tom Dacon
Answered the question myself, as is the usual way of things...
The database that the script failed on was in SQL Server 2000 compatibility
mode. Looks like 2000 didn't SQL allow table valued UDFs in WHERE clauses if
the UDF is passed the value of a column from a table in the query.
Tom Dacon...
Started 5 days, 8 hours ago (2009-11-04 13:11:00)
by Russell Fields
Look at the CAST function. e.g.
CAST ('12345' AS INT)
RLF
"Amos Sobel" <AmosSobel@discussions.microsoft.com> wrote in message
news:7DF408BC-7C09-475B-A582-F2A2D397B780@micros oft.com...
> Dear Friends
>
> I am trying to convert code from MS ACCESS to SQL 2005 VIEW (T-SQL ?). I
> miss the function ...
Started 5 days, 11 hours ago (2009-11-04 10:18:00)
by Uri Dimant
CraigHB
I think you need to read the binary file first and then save it as a file,
I mean you will have to use .NET.
BTW , why are you using IMAGE datatype since there is VARBINARY(MAX)?
"CraigHB" <craighb@nospam.nospam> wrote in message
news:2AA25304-03FD-4DEF-817A-8D2EDF44F33C@micros oft.com...
> Question...
|
|
Hot threads for last week on Discussions in microsoft.public.sqlserver.programming:
Started 5 days, 9 hours ago (2009-11-04 12:36:00)
by klem s
On Nov 3, 9:48 pm, "David Portas"
<REMOVE_BEFORE_REPLYING_dpor...@acm.org> wrote:
> A query used in the FROM clause is called a "derived table subquery" because
> it returns some rows of data exactly as if that data existed in a table.
So essentially data returned from subquery ( inside FROM clause ) acts
as a table?
...
Started 5 days, 11 hours ago (2009-11-04 10:18:00)
by Uri Dimant
Brian
WHERE POST_DATE >= '20090803'AND POST_DATE <'200901003
If it does not help please post sample data + an expected result for
testing
"Brian Conner via SQLMonster.com" <u47161@uwe> wrote in message
news:9e9d5820e73d2@uwe...
>I am trying to pull data below Between 3/8/2009 and 3/9/2009 and for some
...
Started 1 week ago (2009-11-02 05:55:00)
by Tom Edelbrok
Some further information to help identify the problem:
When the problem occurs (ie: my data disappears within the Stored Procedure
script) I can open an SMSS window and SELECT all records from the global
temporary table - the records are actually there, they just disappear within
the SQL script of the Stored Procedure.
...
Started 1 week ago (2009-11-02 05:56:00)
by Steve
Hi All
The following query runs slow on sql server express 2008 but runs fine on
Sql server express 2005 SP2
The databases are the same (SQl server express 2008 database was restored
from sql server 2005)
The indexes are the same and have been rebuilt on both servers
On sql server express 2005 in SSME the...
Started 5 days, 8 hours ago (2009-11-04 13:11:00)
by Russell Fields
Look at the CAST function. e.g.
CAST ('12345' AS INT)
RLF
"Amos Sobel" <AmosSobel@discussions.microsoft.com> wrote in message
news:7DF408BC-7C09-475B-A582-F2A2D397B780@micros oft.com...
> Dear Friends
>
> I am trying to convert code from MS ACCESS to SQL 2005 VIEW (T-SQL ?). I
> miss the function ...
Started 6 days, 22 hours ago (2009-11-02 23:14:00)
by Plamen Ratchev
You can use multiple PIVOT operators but using CASE expressions is easier (and probably more efficient). Here are a
couple examples:
http://pratchev.blogspot.com/2009/01/pivoting-on-m ultiple-columns.html
--
Plamen Ratchev
http://www.SQLStudio.com
.
Started 1 week ago (2009-11-02 21:37:00)
by Tony Rogerson
hi Sharon,
Are you absolutely sure that is the same query you ran and you didn't have a
DISTINCT in there?
Can you post the other query please.
Given the exact same FROM clause you should be getting the same number of
rows because its the joins that bring stuff back and you've no WHERE so
there is no filtering and the SELECT ...
Started 1 week ago (2009-11-02 15:14:00)
by David Portas
1) SELECT can also be used with the INTO clause to create a new table and
populate it with data. SELECT INTO doesn't return a result table. The
variable assignment and SELECT INTO syntax are both proprietary Microsoft
features.
2) a) Actually you can also call a function using EXEC. For example:
EXEC dbo.Func
2) b) ...
Started 1 week ago (2009-11-02 15:07:00)
by Russell Fields
How about:
sqlcmd -Q "ALTER LOGIN sa WITH PASSWORD =
'newpass1'" -S"SERVER1" -Usa -Poldpass1
sqlcmd -Q "ALTER LOGIN sa WITH PASSWORD =
'newpass2'" -S"SERVER2" -Usa -Poldpass2
RLF
"Fayven Wren" <fayvenwren@gmail.com> wrote in message
news:41d3a93b-abd6-4116-a93d-2436ffa5e164@c3g200 0yqd.googlegroups...
Started 1 week ago (2009-11-02 16:15:00)
by Rich
OK I finally remembered - for dates the syntax is
{d'2009-10-30'}
include the curly braces, the d and the single quotes and enter the date
value backwards (or sql server style).
Text params have single quote delimiters - no curly braces. At least that
is working for me right now.
"Rich" wrote:...
|
|
Size: 1,265 bytes
