|
|
|
January 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 |
Filter by week: 1 2 3 4 5 Help on Partitioning column was not found. Posted by Sonny at 5/31/2007 2:11:09 PM Hi,
I don't know if I missed anything. I have 2 member tables and one
partition view in SQL 2000 defined as following
CREATE VIEW Server1.dbo.UTable
AS
SELECT *
FROM Server1..pTable1
UNION ALL
SELECT *
FROM Server2..pTable2
CREATE TABLE pTable1 (
[ID1] [int] IDENTITY (1000, 2) NO...more >>
DTS w/ Oracle Issue Posted by Jimbo at 5/31/2007 11:31:10 AM Im having an issue with DTS and I dont know if anyone else has
experienced this...In my transformation I have a sql statement that
executes against oracle..in it I'm selecting COUNT(DISTINCT
I.PX_INVOICE_ID) ...however when the DTS package executes I get an
error stating that "DISTINCTI"."PX_...more >>
How to distinguish operation type in trigger? Posted by Hubert Trzewik at 5/31/2007 3:19:11 AM Hi,
I want to have all-in-one trigger, defined like this:
CREATE TRIGGER MyInsertDeleteUpdateHandler
ON MyTable
FOR DELETE, INSERT, UPDATE
AS
BEGIN
(...)
END
Now, how can I tell why this trigger was fired (what event caused
trigger to be fired) - was it DELETE, INSERT or UPDATE?
I...more >>
DOWNLOAD CRACKED 2007's SOFTWARE: ARCHICAD 11,UNIGRAPHICS NX5,SOLIDWORKS 2008,XSTEEL 13,AUTOCAD 2008 Posted by William Eistenach at 5/30/2007 9:50:00 PM
Our team provide different types of services such as:
- proffessional cracking of any kind of software
(CAD,CAM,CAE,EDA,GIS,PCB,FEA,FEM,CNC,CFD,PDS,3D,Optics etc.) designed
for any kind of operating systems(Windows 95/98/ME/2000/XP, Linux,
FreeBSD, OS/2, MAC OS etc.)
- producing key...more >>
SQL Enterprise Manager - Not very usefull tool for building views Posted by grant NO[at]SPAM technologyworks.co.nz at 5/29/2007 3:34:26 PM Man do I struggle with Enterprise Manager as a graphical tool for
building views etc.
Its flaky and hangs frequenlty so i have to kill it with the task
manager and re open it.
You cant debug functions ( or am I missing something)
But the worst thing is that it appears to cache the results...more >>
Book recall Posted by --CELKO-- at 5/29/2007 11:11:21 AM Copies of my book "Analytics & OLAP in SQL" have pages 13-44 missing
and pages 61-92 printed twice. Please contact Morgan-Kaufmann or
your book dealer for replacements. I cannot do anything (Remember the
movie THE PRODUCERS? "Don't kill us [the producers]!! Kill the
actors!!')
...more >>
sorting table while inserting Posted by Oonz at 5/29/2007 9:04:02 AM Hi Friends,
How can we insert records in sorted order
like consider a table
No Name Phone
1 test1 12345
1 test1 23455
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594
if i add a new record like this
2 test2 34454
it should go in specific order. so...more >>
Escaping international (unicode) characters in string Posted by Greg R. Broderick at 5/29/2007 8:22:53 AM Y'all:
I am needing some way, in the SQL Server dialect of SQL, to escape unicode
code points that are embedded within an nvarchar string in a SQL script,
e.g. in Java I can do:
String str = "This is a\u1245 test.";
in Oracle's SQL dialect, it appears that I can accomplish the same thin...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
What do you think about the checksum function ? Posted by Kurt at 5/29/2007 5:39:17 AM Hi,
I'd like advices about an idea I add to resolve a problem. thanks to
you in advance for yours answers.
I have a database with tables that I load with flat file. The size of
each table is 600 Mb. The flat file are the image of an application
and there is no updated date or created date on ...more >>
Transpose column into rows Posted by Oonz at 5/29/2007 2:52:43 AM Hi Friends,
How to transpose the columns into rows
i want to convert the table which looks like this
ID Name HomePhone WorkPhone Email
1 test1 678364 643733 test1@test.com
2 test2 678344 643553 test2@test.com
to a table which should look like this
ID Name...more >>
needed: 1 + null = 1 Posted by info NO[at]SPAM vanoordt.nl at 5/29/2007 2:25:39 AM Hi,
I need this behaviour: 1 + null = 1
I have a (dynamic) set of many columns containing decimals that I want
to add as follows:
if all columns are null the result should be null
if not all columns are null, the null columns may be regarded as 0.
E.g.
null + null + 1 = 1
null + null + n...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |