microsoft.public.sqlserver.programming | Forum profile

  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...

   

  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 >...

  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; /*...

  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...

  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"...

  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 >...

  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...

  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...

  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...