|
More site info...
microsoft.public.sqlserver.programming | Forum profile
|
|
Forum profile page for microsoft.public.sqlserver.programming on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.sqlserver.programming, located on the Message Board at http://www.microsoft.com/communities/newsgroups....
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 "microsoft.public.sqlserver.programming" on the Message Board at http://www.microsoft.com/communities/newsgroups... 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 microsoft.public.sqlserver.programming:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
46
|
196
|
925
|
|
Post:
|
100
|
549
|
2,892
|
|
|
microsoft.public.sqlserver.programming Posting activity graph:
|
Top authors 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:
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:
sp_executesql not passing...
Published (2009-10-30 10:21:00)
Figured it out. I need to put all the variable definitions in one string: EXECUTE sp_executesql @Sql, N'@ClientId int, @JobId int, @TrackingCode varchar(30), @FileName varchar(30), @Status tinyint, @ExceptionType varchar(100)', @ClientId = @ClientId, @JobId = @JobId, @TrackingCode = @TrackingCode, @FileName = @FileName, @Status = @Status, @ExceptionType = @ExceptionType Tom "tshad"...
user's latest post:
Global temporary table - data...
Published (2009-11-02 09:57:00)
Thanks for the reply. I just figured out a very dumb thing I did in the script. My mistake - nothing wrong with SQL (ie: dumb user error). Tom "Dave Ballantyne" <symlink@no5p323mmer> wrote in message news:OH6KX%235WKHA.5368@TK2MSFTNGP02.phx.gbl... > Are you able to provide a sample script to emulate this with one or two > rows ? > > > Dave Ballantyne >...
user's latest post:
invalid character for sql svr...
Published (2009-11-02 16:24:00)
Nix the single quotes for the varchar debugger param. The varchar param doesn't require single quotes - I tried 'xyz' and the debugger interpreted that as ''xyz''. when I tried xyz the debugger interpreted that as 'xyz' (as desired) but the datetime param -- for date only values is {d'2009-10-31'} "Rich" wrote: > OK I finally remembered - for dates the...
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:
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...
|
|
|
|
Latest active threads on microsoft.public.sqlserver.programming::
Started 2 days, 23 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, 20 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, 20 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, 22 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, 1 hour 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 microsoft.public.sqlserver.programming::
Started 5 days, 23 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 6 days, 1 hour 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, 1 day 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, 1 day 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, 22 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 1 week 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:...
|
|