Viewing 15 posts - 91 through 105 (of 110 total)
I guess you need to cast the Year to a character data type since it is int datatype and then concatenate it.
Relationships are like Banks.You Invest the Principal and...
He who knows others is learned but the wise one is one who knows himself.
August 13, 2003 at 5:56 am
Try using the COALESCE function.
Relationships are like Banks.You Invest the Principal and then get the Interest.
He who knows others is learned but the wise one is one who knows himself.
August 13, 2003 at 4:02 am
Try using a trigger on the solditemsImport table.
Relationships are like Banks.You Invest the Principal and then get the Interest.
He who knows others is learned but the wise one is one who knows himself.
August 13, 2003 at 3:41 am
This might help u
http://www.schemamania.org/jkl/booksonline/SQLBOL70/html/2_005_33.htm
Relationships are like Banks.You Invest the Principal and then get the Interest.
He who knows others is learned but the wise one is one who knows himself.
August 11, 2003 at 6:28 am
I may be completely out of my senses.
But I feel that insert operations should not be locked by delete operations ideally.
What must be happening in your case is that...
He who knows others is learned but the wise one is one who knows himself.
August 11, 2003 at 6:05 am
One thing I would like to contribute is regarding the connection string. Although it is true that opening database connections is one of the time consuming operations and connection pooling...
He who knows others is learned but the wise one is one who knows himself.
August 11, 2003 at 5:03 am
I guess you need to replace the DATEPART function (MSSQL function ) with an equivalent function in ORACLE.
Relationships are like Banks.You Invest the Principal and then get the Interest.
He who knows others is learned but the wise one is one who knows himself.
August 11, 2003 at 4:35 am
Refer to this in BOL
=======================
DBCC MEMUSAGE provided detailed reports on memory use. Removed; no longer supported or available. Remove all references of DBCC MEMUSAGE and replace with references to these...
He who knows others is learned but the wise one is one who knows himself.
August 11, 2003 at 3:34 am
Try this
======
select interviewdate,
POSTID,
sum(case when status='REJECTED' then 1 else 0 end) as 'REJECTED',
sum(case when status='SELECTED' then 1 else 0 end) as 'SELECTED'
from orders1 where interviewdate between <DATE1> and <DATE2>
group by interviewdate,postid
Relationships...
He who knows others is learned but the wise one is one who knows himself.
August 11, 2003 at 1:12 am
I have this sample data
12003-08-11 00:00:00.0007
22003-08-11 00:00:00.0008
32003-08-11 00:00:00.0009
42003-08-11 00:00:00.00015
52003-08-12 00:00:00.00016
And I m making this query
select sum(case when time_target between 7 and 11 then 1 else 0 end) as 'BREAKFAST',
sum(case...
He who knows others is learned but the wise one is one who knows himself.
August 11, 2003 at 12:20 am
It would be nice if u can paste some sample data from your table and the result expected from that data.
Relationships are like Banks.You Invest the Principal and then get...
He who knows others is learned but the wise one is one who knows himself.
August 10, 2003 at 11:27 pm
Try this link....
http://www.htmlforums.com/showthread.php?threadid=27040
Relationships are like Banks.You Invest the Principal and then get the Interest.
He who knows others is learned but the wise one is one who knows himself.
August 9, 2003 at 2:48 am
I donn think SQL server places lock on the parent table if the child table is being updated.If that is the case then there would be too much of load...
He who knows others is learned but the wise one is one who knows himself.
August 8, 2003 at 11:50 pm
If you know what records you need from table C,I mean using the where clause. Try inserting those particular rows in a temp table and then try and join it...
He who knows others is learned but the wise one is one who knows himself.
August 8, 2003 at 5:47 am
Maybe this link can help you :
http://www.windowsecurity.com/articles/Understanding_Windows_Logging.html
Relationships are like Banks.You Invest the Principal and then get the Interest.
He who knows others is learned but the wise one is one who knows himself.
August 8, 2003 at 3:57 am
Viewing 15 posts - 91 through 105 (of 110 total)