Viewing 15 posts - 811 through 825 (of 859 total)
Artoo22 (3/19/2012)
CELKO (3/19/2012)
March 19, 2012 at 2:42 pm
you can most likely use the coalesce function. For a more detailed and tested solution please see the link in my signature on the most helpful way to ask...
March 19, 2012 at 1:23 pm
shanish (3/19/2012)
declare @minmarks intselect @minmarks=minmarks from table2
select (case when sum(convert(int,marks)) >= @minmarks then 'Pass' else 'Fail' end) as Result
from table1
GROUP BY StudentId,SubjectId,ComponentId
am getting the result, thanks
does the minimum for pass/fail...
March 19, 2012 at 1:11 pm
when you say its intermittent, is that from the same machine to the same server sometimes it will connect sometimes it wont and nothing changes in the server or app...
March 19, 2012 at 12:55 pm
CELKO (3/17/2012)
First you need to read a book on basic data modeling;"name" is an attribute property, which means your column should have been "vendor_name" instead.
it really sounds like the...
March 17, 2012 at 12:13 pm
pallavi.unde (3/17/2012)
Currently i am using express editionbut if i want to switch it then will express edition backup get restore in enterprises edition?
best analogy of enterprise and express would be...
March 17, 2012 at 8:48 am
you did not pass the parameters to the stored procedure. see my above post on how to execute the master SP.
March 16, 2012 at 6:24 pm
sbaker-757360 (3/16/2012)
http://msdn.microsoft.com/en-us/library/ms189493.aspx
Shrinking below initial size will only work if the database file is empty.
My guess is that as soon as you add data (before shrink), you...
March 16, 2012 at 12:05 pm
on multi core machines each core reports their usage time. so 3 cores at 28 seconds is roughly 90 seconds. add a couple of other cores doing a...
March 16, 2012 at 11:15 am
sbaker-757360 (3/16/2012)
I copied a 300GB table out to a new filegroup (because to was too large to shrink after mass deletes)
It ended up...
March 16, 2012 at 9:03 am
ok so you only want to pass the file name and have the folder path static? As i wrote it you pass the entire file path to the stored...
March 16, 2012 at 8:08 am
Jeff,
Depending on the application would using the created on date for the first modified date be better than some future date?
so in the above query it would be rewritten
select *...
March 16, 2012 at 8:00 am
this is starting to sound like homework to me. Any one else?
March 16, 2012 at 7:54 am
Koen Verbeeck (3/16/2012)
Gianluca Sartori (3/16/2012)
Oracle offers Standard/Enterprise editions and maintains additional...
March 16, 2012 at 7:37 am
you say you have 4 production servers on 2000. does this mean you have other servers on SQL 05 or later? The next question is how much will...
March 16, 2012 at 12:18 am
Viewing 15 posts - 811 through 825 (of 859 total)