Viewing 15 posts - 121 through 135 (of 141 total)
Actually, they would be almost the same with the outer join a little slower.
The only difference here is the time consumed by the Query Optimizer to figure out an execution...
December 6, 2006 at 2:38 pm
Mathew,
The cross join allows you to generate the number of rows that you need. you just need to replace the rand(checksum(newid())) part with your function.
Can you...
December 6, 2006 at 2:22 pm
Do you need the actual data or the instantaneous data in yopur select statement? Or does it matter at all?
If it doesn't, you may want to look at the NOLOCK...
December 5, 2006 at 9:02 pm
You can do this by adding the user as a member of the db_owner database role then denying him select access to the table as Mohammed Uddin suggests. Just make...
December 5, 2006 at 7:12 pm
You'll have to restore your full backup again to do this.
This time, specify WITH REPLACE, NORECOVERY.
December 5, 2006 at 6:34 pm
If you are familiar or if you're using .NET, you can retrieve your data tables and use a dataset to hold the data. The dataset have a SaveXML method which...
December 5, 2006 at 6:25 pm
Try using the ASCII function in your filter.
December 5, 2006 at 4:47 pm
SELECT right(convert(varchar(8), cast('2003-11-17 09:08:05.223' as datetime), 108), 2)
December 5, 2006 at 4:43 pm
"But still i am afraid to run the procedure as it took 17 hours to update 2000 matching records. "
You're saying that there are only about 2000 common rows on the...
December 5, 2006 at 4:34 pm
Delete from tbl
where SessionID NOT IN
(Select min(SessionID) from tbl group by SectionID, RoomID, TimeID, DayID, PeriodID, ScheduleTyID )
December 5, 2006 at 3:00 pm
DECLARE csr CURSOR SCROLL DYNAMIC SCROLL_LOCKS FOR
SELECT PCPLastName,
PCPFirstName,
PCP_MI_Title,
PAGE
FROM AuthFormData
ORDER BY PCPLastName,
PCPFirstName,
PCP_MI_Title,
LastName,
FirstName,
MI
FOR UPDATE OF PAGE
just put specify everything you need. Usually, the defaults are the first option. In this case, [
December 5, 2006 at 2:21 pm
I think sushila had it right.
select emp_id, company, max(CheckNumber), Amount
from phbasic
where pay_period_end = '11/25/2006'
group by emp_id, company, Amount
December 5, 2006 at 1:50 pm
Here you go, khoshtip!
So far, all your queries are correct in form/syntax. The thing is, T-SQL (the language used in SQL Server) and PL-SQL (the language used in Oracle) are both...
December 4, 2006 at 6:09 pm
Hi Neetal,
Are you using email addresses or email aliases?
I had a similar problem before where I was using email aliases like 'Ronald San Juan' which was recognized by the...
December 4, 2006 at 6:04 pm
Viewing 15 posts - 121 through 135 (of 141 total)