Viewing 15 posts - 91 through 105 (of 109 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...
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.
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.
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.
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...
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...
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.
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...
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...
August 11, 2003 at 1:12 am
I have this sample data
1 2003-08-11 00:00:00.000 7
2 2003-08-11 00:00:00.000 8
3 2003-08-11 00:00:00.000 9
4 2003-08-11 00:00:00.000 15
5 2003-08-12 00:00:00.000 16
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...
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...
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.
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...
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...
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.
August 8, 2003 at 3:57 am
Viewing 15 posts - 91 through 105 (of 109 total)