|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 IsNull/Coalesce bug in Yukon? Posted by Morgan at 4/1/2006 11:18:09 PM Shouldn't this return -1? I don't have a SQL Server 2000 instance to compare
to, but doesn't this look like a bug?
Thanks,
Morgan
create table Test(col1 int identity not null primary key, col2 varchar(9))
go
insert into Test(col2)values('test2')
go
Select coalesce(col1, -1)
...more >>
Trying to Connect to SQL Server Express 2005 Posted by PParker at 4/1/2006 9:37:23 PM
I have SQL server 2005express installed
I have framework 2 installed
I can use the CTP to create databases tables and see them
I have applications running on my machine which uses SQL server express
- and they work
BUT
When I use the command outlined in the Microsoft Tutorial to conne...more >>
Count records in a group Posted by sk at 4/1/2006 8:24:48 PM Hi
I want to return all records from a table and include a group count. For
example
ColA, ColB, Count as
P100, AB1, 1
P100, AB2, 2
P100, AB3, 3
P200, BB1, 1
P300, AB1, 1
P400, AB1, 1
P400, AB1, 2
I would then somehow like to filter out any records where the count is 1.
For examp...more >>
Multiple SQL Server - Central Server Problem Posted by Odyssey at 4/1/2006 8:06:11 PM Hello,
We had some problems about our project. We have 60 sql server over the
country. We want to collect all data in central server. For collecting data
we developed a project. We get data from local server and transfer them to
central server. We have to transfer huge data. While we transfer da...more >>
Invalid Column Name Posted by Paul D. at 4/1/2006 7:27:51 PM When I execute the following command under SQL Server 2000, "ALT_1_UNIT" is
correctly interpreted as the column name ALT_1_UNIT:
set quoted_identifier on
select "ALT_1_UNIT"
from IM_ITEM
However, I would like to be able to dynamically set the column name like
this:
set quoted_identifier...more >>
DTCTransaction Vs. SQLTransaction (Performance) Posted by Arif Khan at 4/1/2006 6:29:01 PM Can anyone pinpoint the differences between DTCTransaction and
SQLTransaction. I am specifically interested in terms of performance. I am
not sure if there is any performance penalties that you have to pay using
DTCTransaction versus SQLTransaction. If so how much e.g. is there something
lik...more >>
Newb with a serious Trigger question. Posted by Colin Smart at 4/1/2006 5:48:56 PM Ok I am stumped. I am a newbie in terms of triggers and procedures and am
used to writing inline sql statements , so here is my situation.
I have an audit table for all the updates , inserts and deletes throughout
one of my application database(SQL2005).
Whenever something happens a record ...more >>
need to write complex query without cursor Posted by cooltech77 at 4/1/2006 3:13:02 PM Hi all,
I am trying to do the following and am getting stuck.Your help wil be higly
appreciated.
I am matching two tables.If i get a single matching row then get that single
row
but if i get >1 matching rows i should select only the one with the latest
date.
for example
Table1
-----...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Determine Date Range Falls between other Date Range Posted by mbonsted NO[at]SPAM yahoo.com at 4/1/2006 1:50:08 PM I need to figure out how to see if a date in a date range falls between
another date range. For instance - I need to know if any date between
3/1/06 and 3/31/06 falls between a date range of 2/16/03 to 4/1/06.
Does anyone know of a way to code that without using a cursor to go
through every d...more >>
View Inline Function Results? Posted by Bill Cohagan at 4/1/2006 1:42:57 PM I'm using the Server Explorer in VS2005 to execute an "Inline Function" in a
SQL 2005 database, but all I get back is 1 row containing the column
labels -- but no data at all. If I run the same inline function as input in
a select then the data comes through fine. In other words, for an inlin...more >>
Problems with tables named 'User' and 'Workflow' Posted by JerryR at 4/1/2006 12:53:01 PM Downloaded an app that scripts a Sql Server db. It works well--except with
the two aforementioned tables. These show no INSERT statements. I know
there are problems with a table named 'User'. For example, one cannot SELECT
* FROM User. One must SELECT * FROM [User]. I guess something sim...more >>
Embedding multiple .sql files Posted by JerryR at 4/1/2006 12:35:01 PM How do I write a .sql script that executes a number of other scripts in .sql
files? This has to be easy. I just can't find it.
Thanks,
JerryR...more >>
DSN madness Posted by Paul Pedersen at 4/1/2006 10:07:13 AM I have an app that accesses a SQL db via a DSN (and MSDE). The user name and
password are contained in the app, and passed to the data source at run
time.
Everything works fine if the user is an Adminstrator (on Windows), but can't
connect if the user is a User or Power User. If I promote t...more >>
reporting services 2000 rendering Posted by Mike P at 4/1/2006 8:54:29 AM I am using SQL Server 2000 sp3 and reporting services sp2, and I cannot
get the render method to work for my reports
(http://help.maximumasp.com/SmarterTicket/Customer/KBArticle.aspx?articl
eid=847).
I get serveral errors such as :
1) The best overloaded match has some invalid arguments
2)...more >>
Querying data from multiple tables Posted by vm at 4/1/2006 8:04:02 AM I am trying to write a query that will compare values from two different
tables in the same database. I have a db with a table called indexes which
has 3 columns of int values {ColumnA, ColumnB, ColumnC}. There is a second
table called StockVals which has 3 columns of int values {ColumnA, Colu...more >>
Halloween Problem Posted by Leila at 4/1/2006 12:00:00 AM Hi,
According to this page:
http://support.microsoft.com/kb/294860/EN-US
Halloween problem occurs where the physical location of a row within a table
changes due to a modification operation. As a result, the same row may be
revisited multiple times within the context of a single logical opera...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |